QUERY = SELECT a.*, count(a.id) as total FROM `galerias` a LEFT JOIN visitas_galerias b ON a.id = b.id_galeria WHERE 1=1 AND (aprobada=1 AND id_cat LIKE '%00020%' AND (datum=(DATE_SUB(CURDATE(),INTERVAL 1 DAY))) GROUP BY a.id ORDER BY total DESC LIMIT 5