
SIPCAM Iberia participa en la VI Jornada de Campo Expo Algodón '19
Una oportunidad única para enseñar las innovaciones, variedades y ensayos, así como resultados en este cultivo.
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