| Ville | Nîmes |
|---|---|
| Pays | |
| Adresse | Avenue de la Bouvine |
| Site Internet | www.nimesolympique.fr |
| Fondation | 1937 |
| Stade | STADE DES COSTIÈRES |
| Social |
Erreur de la base de données WordPress : [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT p.ID, pm1.meta_value club_in, pm2.meta_value club_out, pm3.meta_value player_id, pm5.meta_value fee, pm6.meta_value transfer_date, pm7.meta_value status, pm8.meta_value `window`, pm9.meta_value custom_club_in_text, pm10.meta_value custom_club_out_text
FROM www_posts p
LEFT JOIN www_postmeta pm1 ON ( pm1.post_id = p.ID AND pm1.meta_key = '_anwpfl_club_in' )
LEFT JOIN www_postmeta pm2 ON ( pm2.post_id = p.ID AND pm2.meta_key = '_anwpfl_club_out' )
LEFT JOIN www_postmeta pm3 ON ( pm3.post_id = p.ID AND pm3.meta_key = '_anwpfl_player_id' )
LEFT JOIN www_postmeta pm4 ON ( pm4.post_id = p.ID AND pm4.meta_key = '_anwpfl_season' )
LEFT JOIN www_postmeta pm5 ON ( pm5.post_id = p.ID AND pm5.meta_key = '_anwpfl_fee' )
LEFT JOIN www_postmeta pm6 ON ( pm6.post_id = p.ID AND pm6.meta_key = '_anwpfl_transfer_date' )
LEFT JOIN www_postmeta pm7 ON ( pm7.post_id = p.ID AND pm7.meta_key = '_anwpfl_status' )
LEFT JOIN www_postmeta pm8 ON ( pm8.post_id = p.ID AND pm8.meta_key = '_anwpfl_window' )
LEFT JOIN www_postmeta pm9 ON ( pm9.post_id = p.ID AND pm9.meta_key = '_anwpfl_custom_club_in_text' )
LEFT JOIN www_postmeta pm10 ON ( pm10.post_id = p.ID AND pm10.meta_key = '_anwpfl_custom_club_out_text' )
WHERE p.post_status = 'publish' AND p.post_type = 'anwp_transfer' AND pm3.meta_value IS NOT NULL AND ( pm1.meta_value IS NOT NULL OR pm2.meta_value IS NOT NULL )
AND pm4.meta_value = 342 AND ( pm1.meta_value IN (4224) OR pm2.meta_value IN (4224) ) AND pm8.meta_value IS NULL GROUP BY p.ID ORDER BY pm6.meta_value DESC
Erreur de la base de données WordPress : [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT p.ID, pm1.meta_value club_in, pm2.meta_value club_out, pm3.meta_value player_id, pm5.meta_value fee, pm6.meta_value transfer_date, pm7.meta_value status, pm8.meta_value `window`, pm9.meta_value custom_club_in_text, pm10.meta_value custom_club_out_text
FROM www_posts p
LEFT JOIN www_postmeta pm1 ON ( pm1.post_id = p.ID AND pm1.meta_key = '_anwpfl_club_in' )
LEFT JOIN www_postmeta pm2 ON ( pm2.post_id = p.ID AND pm2.meta_key = '_anwpfl_club_out' )
LEFT JOIN www_postmeta pm3 ON ( pm3.post_id = p.ID AND pm3.meta_key = '_anwpfl_player_id' )
LEFT JOIN www_postmeta pm4 ON ( pm4.post_id = p.ID AND pm4.meta_key = '_anwpfl_season' )
LEFT JOIN www_postmeta pm5 ON ( pm5.post_id = p.ID AND pm5.meta_key = '_anwpfl_fee' )
LEFT JOIN www_postmeta pm6 ON ( pm6.post_id = p.ID AND pm6.meta_key = '_anwpfl_transfer_date' )
LEFT JOIN www_postmeta pm7 ON ( pm7.post_id = p.ID AND pm7.meta_key = '_anwpfl_status' )
LEFT JOIN www_postmeta pm8 ON ( pm8.post_id = p.ID AND pm8.meta_key = '_anwpfl_window' )
LEFT JOIN www_postmeta pm9 ON ( pm9.post_id = p.ID AND pm9.meta_key = '_anwpfl_custom_club_in_text' )
LEFT JOIN www_postmeta pm10 ON ( pm10.post_id = p.ID AND pm10.meta_key = '_anwpfl_custom_club_out_text' )
WHERE p.post_status = 'publish' AND p.post_type = 'anwp_transfer' AND pm3.meta_value IS NOT NULL AND ( pm1.meta_value IS NOT NULL OR pm2.meta_value IS NOT NULL )
AND pm4.meta_value = 342 AND ( pm1.meta_value IN (4224) OR pm2.meta_value IN (4224) ) AND pm8.meta_value = 'mid' GROUP BY p.ID ORDER BY pm6.meta_value DESC
Erreur de la base de données WordPress : [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
SELECT p.ID, pm1.meta_value club_in, pm2.meta_value club_out, pm3.meta_value player_id, pm5.meta_value fee, pm6.meta_value transfer_date, pm7.meta_value status, pm8.meta_value `window`, pm9.meta_value custom_club_in_text, pm10.meta_value custom_club_out_text
FROM www_posts p
LEFT JOIN www_postmeta pm1 ON ( pm1.post_id = p.ID AND pm1.meta_key = '_anwpfl_club_in' )
LEFT JOIN www_postmeta pm2 ON ( pm2.post_id = p.ID AND pm2.meta_key = '_anwpfl_club_out' )
LEFT JOIN www_postmeta pm3 ON ( pm3.post_id = p.ID AND pm3.meta_key = '_anwpfl_player_id' )
LEFT JOIN www_postmeta pm4 ON ( pm4.post_id = p.ID AND pm4.meta_key = '_anwpfl_season' )
LEFT JOIN www_postmeta pm5 ON ( pm5.post_id = p.ID AND pm5.meta_key = '_anwpfl_fee' )
LEFT JOIN www_postmeta pm6 ON ( pm6.post_id = p.ID AND pm6.meta_key = '_anwpfl_transfer_date' )
LEFT JOIN www_postmeta pm7 ON ( pm7.post_id = p.ID AND pm7.meta_key = '_anwpfl_status' )
LEFT JOIN www_postmeta pm8 ON ( pm8.post_id = p.ID AND pm8.meta_key = '_anwpfl_window' )
LEFT JOIN www_postmeta pm9 ON ( pm9.post_id = p.ID AND pm9.meta_key = '_anwpfl_custom_club_in_text' )
LEFT JOIN www_postmeta pm10 ON ( pm10.post_id = p.ID AND pm10.meta_key = '_anwpfl_custom_club_out_text' )
WHERE p.post_status = 'publish' AND p.post_type = 'anwp_transfer' AND pm3.meta_value IS NOT NULL AND ( pm1.meta_value IS NOT NULL OR pm2.meta_value IS NOT NULL )
AND pm4.meta_value = 342 AND ( pm1.meta_value IN (4224) OR pm2.meta_value IN (4224) ) AND pm8.meta_value = 'pre' GROUP BY p.ID ORDER BY pm6.meta_value DESC
