SQL: SELECT produtoCodigo ,produtoNome ,produtoResumo ,produtoDescricao ,produtoAtivoFlag ,CASE WHEN produtoAtivoFlag = 'S' THEN 'Sim' ELSE 'Não' END AS produtoAtivoFlagDescricao ,produtoDestaqueFlag ,CASE WHEN produtoDestaqueFlag = 'S' THEN 'Sim' ELSE 'Não' END AS produtoDestaqueFlagDescricao ,produtoPromocaoFlag ,CASE WHEN produtoPromocaoFlag = 'S' THEN 'Sim' ELSE 'Não' END AS produtoPromocaoFlagDescricao FROM produto LEFT JOIN produtoProdutoCategoria ON produtoProdutoCategoriaProdutoCodigo = produtoCodigo LEFT JOIN produtoCategoria ON produtoCategoria.produtoCategoriaCodigo = produtoProdutoCategoriaProdutoCategoriaCodigo WHERE 1 AND produtoAtivoFlag = 'S' AND produtoCategoria.produtoCategoriaCodigo IN (5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,9,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,14,15,15,15,15,15,15,15,18,18,18,18,18,18,18,18,18,18,18,19,19,19,19,19,19,19,19,19,23,23,23,23,24,24,24,24,24,24,24,24,24,24,24,24,24,24,24,27,27,28,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,32,32,32,32,32,32,32,32,32,32,32,32,32,32,33,33,33,33,33,33,33,33,33,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,34,35,35,35,35,35,35,35,35,35,38,41,48,48,48,48,48,48,48,52,62,62,62,62,62,62,62,62,62,62,62,62,62,62,62,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,63,65,65,65,65,67,67,67,67,67,67,67,68,68,68,68,68,68,68,69,69,69,69,69,69,69,69,70,70,70,70,70,71,72,73,73,73,73,73,73,73,73,73,73,74,74,74,74,74,74,74,74,74,75,75,75,76,77,77,77,77,77,77,77,77,77,77,77,77,77,77,77,77,78,78,78,79,79,79,79,79,79,79,79,79,79,79,79,79,80,80,80,81,81,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,82,84,84,85,85,85,86,87,88,88,88,88,88,88,88,88,88,88,88,88,93,93,95,95,96,96,97,98,98,98,98,98,98,98,98,98,98,98,98,98,99,99,100,100,100,100,100,100,100,100,100,100,101,101,101,101,102,102,102,102,102,102,102,102,103,103,104,104,104,104,105,105,105,105,105,106,106,106,106,106,107,107,108,108,109,110,110,110,110,110,110,112,113,115,115,115,115,115,115,115,115,115,116,116,117,118,120,121,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,122,123,123,123,124,124,124,125,125,125,125,126,126,126,127,127,127,127,127,128,129,129,130,131,132,132,133,134,135,135,136,136,136,137,137,137,137,137,137,138,138,138,138,138,138,138,138,138,138,138,138,138,139,139,139,139,139,139,140,141,142,143,143,143,143,143,143,143,143,143,143,143,143,143,143,144,144,144,144,144,144,144,144,145,145,145,145,145,145,145,145,145,145,145,145,145,145,145,145,146,146,146,146,146,146,146,146,146,146,147,147,147,147,147,147,148,148) AND produtoCodigo <> GROUP BY produtoCodigo ORDER BY RAND()