[Résolu ?] A traiter : Pages non accessibles.

Question aux experts mysql.

Voici la requête coupable. Si elle retourne 1 enregistrement c'est bon sinon c'est : la page demandée est introuvable.

Chacun (experts) comprendra qu'il y a un lien évident entre les pages et les utilisateurs ( d'où la mesure à prendre pour la suppression de compte)

En revanche si je vire la jointure en gras et que je remplace l'alias u par u2 ..ça marche !!!!

Help !

SELECT f.friend_id AS is_friend, l.like_id AS is_liked, p.*, u.user_image as image_path, p.image_path as pages_image_path, u.user_id as page_user_id, p.use_timeline, pc.claim_id, pu.vanity_url, pg.name AS category_name, pg.page_type, pt.text_parsed AS text, u.full_name, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id, u2.user_id AS owner_user_id, u2.profile_page_id AS owner_profile_page_id, u2.server_id AS owner_server_id, u2.user_name AS owner_user_name, u2.full_name AS owner_full_name, u2.gender AS owner_gender, u2.user_image AS owner_user_image, u2.is_invisible AS owner_is_invisible, u2.user_group_id AS owner_user_group_id, u2.language_id AS owner_language_id, u2.last_activity AS owner_last_activity
FROM thechangebook_pages AS p
LEFT JOIN thechangebook_friend AS f
ON(f.user_id = p.user_id AND f.friend_user_id = 12476)
LEFT JOIN thechangebook_like AS l
ON(l.type_id = 'pages' AND l.item_id = p.page_id AND l.user_id = 12476)
JOIN thechangebook_pages_text AS pt
ON(pt.page_id = p.page_id)
JOIN thechangebook_user AS u
ON(u.profile_page_id = p.page_id)
JOIN thechangebook_user AS u2
ON(u2.user_id = p.user_id)
LEFT JOIN thechangebook_pages_url AS pu
ON(pu.page_id = p.page_id)
LEFT JOIN thechangebook_pages_category AS pg
ON(pg.category_id = p.category_id)
LEFT JOIN thechangebook_theme_style AS ts
ON(ts.style_id = p.designer_style_id)
LEFT JOIN thechangebook_theme AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN thechangebook_pages_claim AS pc
ON(pc.page_id = p.page_id AND pc.user_id = 12476)

WHERE p.page_id = 852

852 = n° de page
12476 = compte utilisateur