Filter sur condition:
Tous
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 'AND p.id_edicions = 1 order by (data_propera_funcio is null or data_propera_fu' at line 15

SELECT distinct p.id, pd.name,p.grouped,p.fotos_groups_id,p.fotos_groups_id_premsa,p2c.categories_id, pd.subtitol,pd.destacat,pd.link_comprar, pd.desc_short, pd.description, pd.tecnical, pd.box_content, p.image, p.video,p.video2, p.price, p.tax_class_id, p.espais_id, p.web_companyia,p.companyia, p.autor,p.disponibility_id, p.available, p.status, p.entered, pd.download,pd.download2, pd.download_premsa,pd.download_premsa2,pd.download_title,pd.download2_title,pd.download_premsa_title,pd.download_premsa2_title, p.id_edicions,ed.titol as titol_edicio,p.amagar_fitxa, (SELECT COUNT(f.id) FROM products_funcions f WHERE f.id_espectacle=p.id) AS total_funcions, ( SELECT data FROM products_funcions f2 WHERE f2.id_espectacle = p.id ORDER BY data desc LIMIT 1 ) AS data_propera_funcio FROM products p LEFT JOIN products_description pd ON p.id = pd.products_id AND pd.language_id = '4' LEFT JOIN products_to_categories p2c ON p.id = p2c.products_id LEFT JOIN edicions_description ed ON (p.id_edicions = ed.edicions_id and ed.language_id = '4') WHERE p.status = '1' AND p.id = p2c.products_id AND pd.products_id = p2c.products_id AND pd.language_id = '4' AND p2c.categories_id = AND p.id_edicions = 1 order by (data_propera_funcio is null or data_propera_funcio='0000-00-00 00:00:00') desc, data_propera_funcio DESC, p2c.listorder asc LIMIT 0, 25
Les cookies assurent le bon fonctionnement de nos services. En utilisant ces derniers, vous acceptez l'utilisation des cookies En savoir plus
ACCEPTAR