|
SELECT
cd.id_cd,
capa,
codigo,
titulo,
preco,
desconto_reais,
disponivel
FROM
cd, artista art, link lk
WHERE
lk.id_cd=cd.id_cd AND lk.id_artista=art.id_artista AND visivel_b2c=1
AND
(
art.nome LIKE '%%'
OR
titulo LIKE '%%'
OR
codigo LIKE '%%'
OR
ano LIKE '%%'
)
AND
merchandising=0
GROUP BY
posicao,
id_cd,
codigo,
titulo,
preco,
disponivel
ORDER BY
posicao DESC
|
![]() |
|