SportyTrader - Actu Paris sportifs et pronostic foot

Devenez Champion d'Europe des Paris Sportifs !

Affrontez les parieurs du monde entier pendant l'Euro 2012 de foot sur Betting World Cup. Placez vos paris sur un maximum de matchs, remportez des points, et montrez que vous êtes le meilleur. En plus de la gloire, le Champion d'Europe des paris remportera un superbe prix !

Les prochains matchs

  
Partagez Partager sur Facebook Envoyer par e-mail Plus d'options
    
( SELECT 'st' AS origine, j.id_joueur AS id, i.pseudo AS login, CONCAT(cl.codecourt,'_',UPPER(cl.codecourt)) AS locale, i.image_forum AS avatar, i.sexe AS sexe, i.validation AS avatar_valide, mp.trusted AS trusted, j.total as total, j.matchs AS matchs, j.pronos AS pronos, j.en_cours AS en_cours, j.bons AS bons, 'FR' AS code_pays, j.rentabilite AS rent, j.reussite AS reussite, j.date_first_prono AS date_first_prono FROM bettingworldcup.joueur j INNER JOIN mutu_sportytrader.inscrit i ON i.id = j.id_joueur INNER JOIN sportytrader.membres_public mp ON mp.id_forum = j.id_joueur LEFT OUTER JOIN cotes.langues cl ON cl.LCID = mp.LCID ) UNION ( SELECT 'fb' AS origine, j.FB_UID AS id, f.first_name AS login, f.locale AS locale, f.pic AS avatar, f.sex AS sexe, 1 AS avatar_valide, 0 AS trusted, j.total as total, j.matchs AS matchs, j.pronos AS pronos, j.en_cours AS en_cours, j.bons AS bons, LOWER(iso.code) AS code_pays, j.rentabilite AS rent, j.reussite AS reussite, j.date_first_prono AS date_first_prono FROM bettingworldcup.joueur j INNER JOIN bettingworldcup.facebook f ON f.FB_UID = j.FB_UID INNER JOIN bettingworldcup.ISO_3666_country_codes iso ON iso.code = RIGHT(IF(j.FB_UID=0,'fr_FR',f.locale),2) AND iso.autorisation=1 WHERE j.FB_UID NOT IN (0) ) ORDER BY total DESC,rent DESC,reussite DESC,pronos DESC,date_first_prono ASC,id ASC LIMIT 10
Table 'bettingworldcup.ISO_3666_country_codes' doesn't exist