Síguenos en

Sígue a Vive Campoo en facebook Sígue a Vive Campoo en twitter Sígue a Vive Campoo en youtube
30 galerías |1.513 fotos

Últimos comentarios

Warning: Invalid argument supplied for foreach() in /var/www/vhosts/vps90544.ovh.net/httpdocs/vivecampoo/categoria-fotos.php on line 803
HOY
MES
MySQL Error Occured
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY a.id ORDER BY total DESC LIMIT 5' at line 1

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 (upper(etiquetas) LIKE '%,LAS ROZAS DE VALDEARROYO,%' OR upper(etiquetas) LIKE 'LAS ROZAS DE VALDEARROYO,%' OR upper(etiquetas) LIKE '%,LAS ROZAS DE VALDEARROYO') AND (datum=(DATE_SUB(CURDATE(),INTERVAL 1 DAY))) GROUP BY a.id ORDER BY total DESC LIMIT 5