3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ev_selvacultura.l.listorder' which is not in SELECT list; this is incompatible with DISTINCT

select distinct l.id,ld.titol from products_funcions f left join llistats l on (l.id = f.espais_id) left join llistats_description ld on (ld.llistats_id = l.id and ld.language_id = 1) left join products p on (p.id = f.id_espectacle and p.id_edicions = 1) left join products_to_categories ptc on (ptc.products_id = p.id) WHERE not ISNULL(l.id) AND l.id != '' AND p.status = 1 AND ptc.categories_id != 15 and f.status > 0 and ptc.categories_id = 1000 OR ptc.categories_id = 1000 and (f.data>=NOW() OR f.te_data = 0) ORDER BY l.listorder

Exposicions  

3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ev_selvacultura.l.listorder' which is not in SELECT list; this is incompatible with DISTINCT

select distinct l.id,ld.titol from products_funcions f left join llistats l on (l.id = f.espais_id) left join llistats_description ld on (ld.llistats_id = l.id and ld.language_id = 1) left join products p on (p.id = f.id_espectacle and p.id_edicions = 1) left join products_to_categories ptc on (ptc.products_id = p.id) WHERE not ISNULL(l.id) AND l.id != '' AND p.status = 1 AND ptc.categories_id != 15 and f.status > 0 and ptc.categories_id = 1000 OR ptc.categories_id = 1000 and (f.data>=NOW() OR f.te_data = 0) ORDER BY l.listorder
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'ev_selvacultura.l.listorder' which is not in SELECT list; this is incompatible with DISTINCT

select distinct l.id,ld.titol from products_funcions f left join llistats l on (l.id = f.espais_id) left join llistats_description ld on (ld.llistats_id = l.id and ld.language_id = 1) left join products p on (p.id = f.id_espectacle and p.id_edicions = 1) left join products_to_categories ptc on (ptc.products_id = p.id) WHERE not ISNULL(l.id) AND l.id != '' AND p.status = 1 AND ptc.categories_id != 15 and f.status > 0 and ptc.categories_id = 1000 and (f.data>=NOW() OR f.te_data = 0) ORDER BY l.listorder
Francisca: una dona enamorada del bosc
Festa de la Ratafia
Del 08.11.18 al 17.11.18
Santa Coloma de Farners
Exposicions
Joan Busquets Cantal
Escultura
Del 26.10.18 al 31.12.18
Sant Hilari Sacalm
Exposicions
Gemma Esclusa i taller Fina Milà
Pintura i gravat
Del 27.10.18 al 30.11.18
Sant Hilari Sacalm
Exposicions
La Cadira
Instal·lació · Esther Polo
Del 15.10.18 al 01.12.18
Santa Coloma de Farners
Exposicions
2n Mercat de Nadal
Exposició Col·lectiva
Del 05.12.18 al 12.01.19
Santa Coloma de Farners
Exposicions
El Rostre de l'Ànima
Exposició Escultura · Jordi Parera
Del 10.12.18 al 19.01.19
Santa Coloma de Farners
Exposicions
Aquest lloc web utilitza "cookies" pròpies i de tercers per oferir-te un millor servei. En navegar-hi n'acceptes l'ús. Més informació
ACCEPTAR