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