Erreur de la base de données WordPress : [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY gamedatetime ASC' at line 10]
SELECT
post.*,
team.post_title AS teamname,
team.ID as team_id,
metachampseason.meta_value AS season_id,
metagamechamp.meta_value AS championship_id,
championship.post_title AS championshipname,
metagametime.meta_value AS gamedatetime
FROM wp1_posts post
INNER JOIN wp1_postmeta metagametime ON (metagametime.post_id = post.ID AND metagametime.meta_key = 'gamedatetime') INNER JOIN wp1_postmeta metagamechamp ON (metagamechamp.post_id = post.ID AND metagamechamp.meta_key = 'championship_id') INNER JOIN wp1_posts championship ON (metagamechamp.meta_value = championship.ID AND championship.post_type = 'bbc_cp_championship') INNER JOIN wp1_postmeta metachampteam ON (metachampteam.post_id = championship.ID AND metachampteam.meta_key = 'team_id') INNER JOIN wp1_postmeta metachampseason ON (metachampseason.post_id = championship.ID AND metachampseason.meta_key = 'season_id') INNER JOIN wp1_posts team ON (metachampteam.meta_value = team.ID AND team.post_type = 'bbc_cp_team') INNER JOIN wp1_posts season ON (metachampseason.meta_value = season.ID AND season.post_type = 'bbc_cp_season') WHERE post.post_type = 'bbc_cp_game' AND post.post_status = 'publish' AND post.ID = metagamechamp.post_id AND championship.post_status = 'publish' AND championship.ID = ORDER BY gamedatetime ASC
Aucun match.
Aucune actualité.