×
![]()
| Partager : |
|
VOS REACTIONS
Soyez le premier à réagir sur cet article
Seuls les membres du site peuvent commenter les articles
Inscrivez-vous gratuitement ou connectez-vous
Inscrivez-vous gratuitement ou connectez-vous
Erreur de base de données :
Erreur retournée : 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 'AND xg_console=fj.xg_console AND (moy_membres >= fj.moy_membres)) AS rank_m, ' at line 1Erreur1064
Page concernée : "www.xbox-gamer.net/newsaff_10951.html"
Date : "18/04/2024 - 12h55"
Requête Mysql : SELECT (SELECT COUNT(id) FROM fiches WHERE id!= AND xg_console=fj.xg_console AND (moy_membres >= fj.moy_membres)) AS rank_m, (SELECT COUNT(id) FROM fiches WHERE id!= AND xg_console=fj.xg_console AND (moy_presse >= fj.moy_presse)) AS rank_r, (SELECT COUNT(id) FROM fiches WHERE id!= AND xg_console=fj.xg_console AND (moy_globale >= fj.moy_globale)) AS rank_g, (SELECT COUNT(id) FROM collection WHERE id_jeu=) AS nb_collec, (SELECT COUNT(id) FROM images WHERE id_jeu=) AS nb_img, (SELECT COUNT(id) FROM tests_membre WHERE id_jeu= AND validation=1) AS nb_tests, (SELECT AVG(note_finale) FROM tests_membre WHERE id_jeu= AND validation=1) AS moy_test_membre, (SELECT lien_petite_image FROM images WHERE id_jeu= ORDER by id DESC LIMIT 0,1) AS image_1, (SELECT id FROM images WHERE id_jeu= ORDER by id DESC LIMIT 0,1) AS image_1id, (SELECT lien_petite_image FROM images WHERE id_jeu= ORDER by id DESC LIMIT 1,1) AS image_2, (SELECT id FROM images WHERE id_jeu= ORDER by id DESC LIMIT 1,1) AS image_2id, (SELECT lien_petite_image FROM images WHERE id_jeu= ORDER by id DESC LIMIT 2,1) AS image_3, (SELECT id FROM images WHERE id_jeu= ORDER by id DESC LIMIT 2,1) AS image_3id, (SELECT lien_petite_image FROM images WHERE id_jeu= ORDER by id DESC LIMIT 3,1) AS image_4, (SELECT id FROM images WHERE id_jeu= ORDER by id DESC LIMIT 3,1) AS image_4id, (SELECT COUNT(id) FROM images WHERE id_jeu= AND (type="" OR type="Screens")) AS nb_img_screens, (SELECT COUNT(id) FROM images WHERE id_jeu= AND type="Artworks") AS nb_img_artworks, (SELECT COUNT(id) FROM images WHERE id_jeu= AND type="Scans") AS nb_img_scans, (SELECT COUNT(id) FROM images WHERE id_jeu= AND type="Divers") AS nb_img_divers, (SELECT COUNT(id) FROM fiches WHERE support="") AS nb_jeux, (SELECT COUNT(id) FROM succes WHERE id_jeu_wid=fj.id_wid) AS nb_succes, (SELECT SUM(gscore) FROM succes WHERE id_jeu_wid=fj.id_wid) AS gscore, fj.description_valide, fj.description_auteur, fj.description, fj.reso4k, fj.xboxgamepass, fj.hdr, fj.attente_1, fj.attente_2, fj.attente_3, fj.attente_4, fj.attente_5, tests.id AS test_id, tests.note, fj.moy_membres, fj.moy_presse, fj.moy_globale, fj.id, fj.id_wid, fj.update_fiche, fj.xg_nom, fj.xg_console, fj.adfever, fj.seize_neuvieme, fj.type, fj.nom_fr, fj.nom_en, fj.espace_hdd, fj.distributeur_nom, fj.distributeur, fj.soixante_hz, fj.sortie_fr_j, fj.sortie_fr_m, fj.sortie_fr_a, fj.sortie_us_j, fj.sortie_us_m, fj.sortie_us_a, fj.sortie_jp_j, fj.sortie_jp_m, fj.sortie_jp_a, fj.box, fj.tag, fj.code, fj.url_site, fj.joueur_min, fj.joueur_max, fj.prix_fr, fj.prix_en, fj.classification_fr, fj.classification_en, fj.compat_online, fj.nom_similaire, fj.nb_format, fj.localisation, fj.reso480p, fj.reso720p, fj.reso1080p, fj.reso1080i, fj.memoire, fj.son, fj.etat, fj.nom_autre, fj.support, fj.editeur, fj.developpeur, fj.editeur_nom, fj.developpeur_nom, fj.format, fj.statut, fj.type_aff, fj.sortie_fr, fj.sortie_us, fj.sortie_jp, fj.genre_aff, fj.theme_aff, fj.jeu_une, fj.hits, fj.bandeau, tests.selectionXG, tests.id_news as idNews FROM fiches AS fj LEFT JOIN tests ON tests.id_jeu=fj.id WHERE fj.id=