Indietro

Elenco Partite Disputate

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 (data<'2012-09-01' or (data>='2012-09-01' and (rispesatte+risperrate+rispas' at line 6 SQL=SELECT p.id_partita,p.nonvisualizzare ,date_add(p.data, INTERVAL -6 HOUR) as data,year(p.data) as anno,p.id_locale,v.venue as nomelocale,v.locimage,com.comune, com.provincia,count(c.id_partita) as numsquadre,rispesatte+risperrate+rispastenuti as totdomande,MAX(puntipub) as maxpunteggio, GROUP_CONCAT(CAST(c.id_squadra AS CHAR(8)) order by puntipub desc) as idsquadre, GROUP_CONCAT(CAST((ifnull(g.name, '-')) AS CHAR(20)) order by puntipub desc) as nomisquadrecard, GROUP_CONCAT(CAST(c.nomesquadra AS CHAR(20)) order by puntipub desc) as nomisquadresenzacard, GROUP_CONCAT(CAST((ifnull(g.thumb, '-')) AS CHAR(100)) order by puntipub desc) as avatarsquadre FROM cerv_partite_contenuto c left join cerv_partite p on c.id_partita=p.id_partita left join jos_eventlist_venues v on v.id=p.id_locale left join comuni com on com.id=v.id_comune left join jos_community_groups g on g.id=c.id_squadra where id_locale= AND (data<'2012-09-01' or (data>='2012-09-01' and (rispesatte+risperrate+rispastenuti>4))) group by c.id_partita HAVING numsquadre>4 order by data desc,puntipub desc limit 0,100
Nessun dato disponibile.