L'Echo des paris

Parier en direct

L'Echo des paris dresse la liste de tous les matchs sur lesquels vous pouvez parier en direct ! Profitez de cotes plus élevées et multipliez vos gains en vous lançant dans le pari en direct.
SELECT m.*, e1.equipeFR AS equipe_domicile, e1.type AS type_domicile, e2.equipeFR AS equipe_exterieur, e2.type AS type_exterieur, c_s.nom_competitionFR AS compet, c_s.saison, m_c.nom_compet_url, p.id_phase, p.phaseFR FROM `match` AS m, competition_saison AS c_s, competition AS c, menu_competition AS m_c, phase AS p, equipe AS e1, equipe AS e2 WHERE m.id_competition_saison=c_s.id_competition_saison AND c_s.id_competition=c.id_competition AND c.id_competition=m_c.id_competition AND m.id_phase=p.id_phase AND e1.id_equipe=m.id_equipe_domicile AND e2.id_equipe=m.id_equipe_exterieur AND m.id_phase!=0 AND ( (m.`date`>=DATE_SUB(NOW(), INTERVAL 30 MINUTE) AND m.`date`<=DATE_ADD(NOW(), INTERVAL 1 DAY)) OR m.minute_live!='' ) AND m_c.id_menu_competition_redirection=0 AND m_c.id_marche=1 AND (`pari_directUNIBET`=1 OR `pari_directBETCLIC`=1 OR `pari_directPMU`=1 OR `pari_directBWIN`=1 OR `pari_directPARIONSWEB`=1 OR `pari_directNETBET`=1 OR `pari_directWINAMAX`=1) AND m.type_fin!='reporte' AND m.type_fin!='annule' AND m.but_equipe_domicile IS NULL AND m.but_equipe_exterieur IS NULL ORDER BY m.date, m_c.ordre

Une erreur est survenue sur le serveur distant
Veuillez réessayer dans quelques instants

Retour