date_add
SELECT c.*, l.*, l.meta_title as title, blc.link_rewrite as category_link_rewrite , blc.title as category_title FROM ps_leoblog_blog c LEFT JOIN ps_leoblog_blog_lang l ON (c.id_leoblog_blog = l.id_leoblog_blog) and l.id_lang=1 LEFT JOIN ps_leoblog_blog_shop s ON (c.id_leoblog_blog = s.id_leoblog_blog) and s.id_shop=1 LEFT JOIN ps_leoblogcat bc ON bc.id_leoblogcat = c.id_leoblogcat LEFT JOIN ps_leoblogcat_lang blc ON blc.id_leoblogcat=bc.id_leoblogcat and blc.id_lang=1 WHERE l.id_lang = 1 AND s.id_shop=1 AND c.active=1 GROUP BY c.id_leoblog_blog ORDER BY `c`.`date_add` DESC LIMIT 0, 6 SIPCAM Iberia - Blog - Sipcam Iberia

Últimos Blogs

Nuevo registro de cuenta

¿Ya tienes una cuenta?
Entrar en vez O Restablecer la contraseña