Contest Tematici | Il Cervellone Champions Quiz

Il Cervellone Champions Quiz


No valid database connection 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 '' at line 1 SQL=select * from cerv_contest_tematici where enabled=1 and cat=
No valid database connection 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 pc.id_partita,pc.id_squadra) t group by date(date_add(t.data, INTERVAL ' at line 8 SQL=select id_squadra,nomesquadra,thumb,GROUP_CONCAT(id_partita2 SEPARATOR '|' ) as idpartite,GROUP_CONCAT(id_locale2 SEPARATOR '|' ) as idlocale,GROUP_CONCAT(locale SEPARATOR '|') as locale,GROUP_CONCAT(comune SEPARATOR '|') as comune,GROUP_CONCAT(provincia SEPARATOR '|') as provincia,count(id_partita) as totmanche,MAX(sommapunti2) as bestscore from ( select t2.*,v.venue as locale,c.comune,c.provincia from ( select *, SUBSTRING_INDEX(CAST(GROUP_CONCAT(id_partita order by data) AS CHAR(10000) CHARACTER SET utf8),',',1) as id_partita2, SUBSTRING_INDEX(CAST(GROUP_CONCAT(id_locale order by data) AS CHAR(10000) CHARACTER SET utf8),',',1) as id_locale2, SUBSTRING_INDEX(GROUP_CONCAT(sommapunti order by data),',',1)+0 as sommapunti2 from (select id_squadra,id_locale,p.data,g.name as nomesquadra,g.thumb,p.id_partita,SUM(punti_domanda) as sommapunti from cerv_partite_puls pc left join cerv_partite p on p.id_partita=pc.id_partita left join jos_community_groups g on g.id=pc.id_squadra where p.id_locale!=0 and g.name IS NOT NULL and pc.id_squadra!=0 and p.data<='2020-05-27 12:00:00' and p.data>='2019-10-21 12:00:00' and p.cat= group by pc.id_partita,pc.id_squadra) t group by date(date_add(t.data, INTERVAL -6 HOUR)),id_squadra) t2 LEFT JOIN jos_eventlist_venues v on v.id=id_locale2 left join comuni c on c.id=v.id_comune) t3 group by id_squadra order by bestscore desc limit 0,100

Dati non ancora disponibili.