| lastBuiltQuery |
SELECT DISTINCT *
FROM tx_dam
LEFT JOIN tx_dam_mm_cat AS tx_dam_mm_cat_a ON tx_dam.uid=tx_dam_mm_cat_a.uid_local
WHERE
user_rating.rating > '0' AND tx_dam.pid=1
AND (tx_dam_mm_cat_a.uid_foreign IN (76))
AND tx_dam.deleted=0 AND tx_dam.hidden=0 AND (tx_dam.starttime<=1328357025) AND (tx_dam.endtime=0 OR tx_dam.endtime>1328357025) AND (tx_dam.fe_group='' OR tx_dam.fe_group IS NULL OR tx_dam.fe_group='0' OR (tx_dam.fe_group LIKE '%,0,%' OR tx_dam.fe_group LIKE '0,%' OR tx_dam.fe_group LIKE '%,0' OR tx_dam.fe_group='0') OR (tx_dam.fe_group LIKE '%,-1,%' OR tx_dam.fe_group LIKE '-1,%' OR tx_dam.fe_group LIKE '%,-1' OR tx_dam.fe_group='-1'))
GROUP BY tx_dam.uid
ORDER BY user_rating.rating DESC
LIMIT 12
|