Indietro | Vai al Regolamento | Cronologia Ultime Partite Disputate

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 'order by p.data desc limit 0,1' at line 1 SQL=select date(date_add(p.data, INTERVAL -6 HOUR)) as datagiusta,year(p.data) as anno,v.venue as nomelocale,v.datafinechampions,v.locimage,com.comune, com.provincia,pr.provincia as provinciaestesa,r.regione as regioneestesa from jos_eventlist_venues v left join cerv_partite p on p.id_locale=v.id left join comuni com on com.id=v.id_comune left join province pr on pr.sigla=com.provincia left join regioni r on r.id=pr.id_regione WHERE v.id= order by p.data desc limit 0,1
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 'order by p.data desc limit 0,1' at line 1 SQL=select date(date_add(p.data, INTERVAL -6 HOUR)) as datagiusta,year(p.data) as anno,v.venue as nomelocale,v.datafinechampions,v.locimage,com.comune, com.provincia,pr.provincia as provinciaestesa,r.regione as regioneestesa from jos_eventlist_venues v left join cerv_partite p on p.id_locale=v.id left join comuni com on com.id=v.id_comune left join province pr on pr.sigla=com.provincia left join regioni r on r.id=pr.id_regione WHERE v.id= order by p.data desc limit 0,1
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 'and id_squadra!=0 and (rispesatte+rispastenuti+risperrate)>4 and date_add(p.data' at line 1 SQL=select count(id_squadra) as totmanche,id_squadra,g.name as nomesq,g.thumb,SUM(puntitorneo) as totpuntitorneo,SUM(puntipub) as totpuntipub,SUM(IF(posizioneclassifica=1,1,0)) as primoposto,SUM(IF(posizioneclassifica=2,1,0)) as secondoposto,SUM(IF(posizioneclassifica=3,1,0)) as terzoposto from (select id_squadra,nomesquadra,posizioneclassifica,CASE posizioneclassifica WHEN 1 THEN 6 WHEN 2 THEN 5 WHEN 3 THEN 4 WHEN 4 THEN 3 WHEN 5 THEN 3 WHEN 6 THEN 3 WHEN 7 THEN 3 WHEN 8 THEN 3 WHEN 9 THEN 2 WHEN 10 THEN 2 WHEN 11 THEN 2 WHEN 12 THEN 2 WHEN 13 THEN 2 WHEN 14 THEN 2 ELSE 1 END as puntitorneo,puntipub from cerv_partite_contenuto pc left join cerv_partite p on p.id_partita=pc.id_partita LEFT JOIN jos_eventlist_venues v on v.id=p.id_locale where p.id_locale= and id_squadra!=0 and (rispesatte+rispastenuti+risperrate)>4 and date_add(p.data, INTERVAL -6 HOUR)<='2019-05-27 12:00:00' and date_add(p.data, INTERVAL -6 HOUR)>='2018-10-21 12:00:00' and date_add(p.data, INTERVAL -6 HOUR)>=datainiziochampions) t left join jos_community_groups g on g.id=t.id_squadra where name IS NOT NULL group by id_squadra order by totpuntitorneo desc,totmanche desc,primoposto desc,secondoposto desc,terzoposto desc,totpuntipub desc

Dati non ancora disponibili.