Pisa

Il n'y a pas de joueurs dans l'équipe

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 (74046) OR pm2.meta_value IN (74046) ) AND pm8.meta_value IS NULL GROUP BY p.ID ORDER BY pm6.meta_value DESC

Mercato d'été

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 (74046) OR pm2.meta_value IN (74046) ) AND pm8.meta_value = 'mid' GROUP BY p.ID ORDER BY pm6.meta_value DESC

Mercato d'hiver

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 (74046) OR pm2.meta_value IN (74046) ) AND pm8.meta_value = 'pre' GROUP BY p.ID ORDER BY pm6.meta_value DESC

Author: Master