Animation Source

D'après une membre anglaise, Lucario a quitté AS.
A confirmer ?.

SELECT fan_comment.id_comment, fan_comment.id_author, fan_comment.id_object, fan_comment.numsite, fan_comment.lang, fan_comment.type_module, fan_comment.type_module_text, fan_comment.date_posted, fan_comment.pseudo, fan_comment.comment, fan_comment.IPA, fan_comment.m_id, fan_comment.old_id_comment, fan_comment.old_id_author, fan_comment.old_id_object, member.id, member.user_id, member.lang, member.member_name, member.points, member.gender, member.age, member.country, member.country_flag, member.description, member.avatar, member.show_profile, member.show_email, member.show_friend_PM, member.nbChgtPseudo, member.nbBans, member.nbWarnings, member.registration_numsite, member.lastNameChange, member.lastArtEntranceChange, member.date_creat, member.date_last_action, member.date_last_login, member.regIP, member.id_fb, member.registered_fb, COALESCE(t1.user_id, t2.user_id) as user_id , COALESCE(t1.user_type, t2.user_type) as user_type , COALESCE(t1.group_id, t2.group_id) as group_id , COALESCE(t1.user_permissions, t2.user_permissions) as user_permissions , COALESCE(t1.user_perm_from, t2.user_perm_from) as user_perm_from , COALESCE(t1.user_ip, t2.user_ip) as user_ip , COALESCE(t1.user_regdate, t2.user_regdate) as user_regdate , COALESCE(t1.username, t2.username) as username , COALESCE(t1.username_clean, t2.username_clean) as username_clean , COALESCE(t1.user_password, t2.user_password) as user_password , COALESCE(t1.user_passchg, t2.user_passchg) as user_passchg , COALESCE(t1.user_pass_convert, t2.user_pass_convert) as user_pass_convert , COALESCE(t1.user_email, t2.user_email) as user_email , COALESCE(t1.user_email_hash, t2.user_email_hash) as user_email_hash , COALESCE(t1.user_birthday, t2.user_birthday) as user_birthday , COALESCE(t1.user_lastvisit, t2.user_lastvisit) as user_lastvisit , COALESCE(t1.user_lastmark, t2.user_lastmark) as user_lastmark , COALESCE(t1.user_lastpost_time, t2.user_lastpost_time) as user_lastpost_time , COALESCE(t1.user_lastpage, t2.user_lastpage) as user_lastpage , COALESCE(t1.user_last_confirm_key, t2.user_last_confirm_key) as user_last_confirm_key , COALESCE(t1.user_last_search, t2.user_last_search) as user_last_search , COALESCE(t1.user_warnings, t2.user_warnings) as user_warnings , COALESCE(t1.user_last_warning, t2.user_last_warning) as user_last_warning , COALESCE(t1.user_login_attempts, t2.user_login_attempts) as user_login_attempts , COALESCE(t1.user_inactive_reason, t2.user_inactive_reason) as user_inactive_reason , COALESCE(t1.user_inactive_time, t2.user_inactive_time) as user_inactive_time , COALESCE(t1.user_posts, t2.user_posts) as user_posts , COALESCE(t1.user_lang, t2.user_lang) as user_lang , COALESCE(t1.user_timezone, t2.user_timezone) as user_timezone , COALESCE(t1.user_dst, t2.user_dst) as user_dst , COALESCE(t1.user_dateformat, t2.user_dateformat) as user_dateformat , COALESCE(t1.user_style, t2.user_style) as user_style , COALESCE(t1.user_rank, t2.user_rank) as user_rank , COALESCE(t1.user_colour, t2.user_colour) as user_colour , COALESCE(t1.user_new_privmsg, t2.user_new_privmsg) as user_new_privmsg , COALESCE(t1.user_unread_privmsg, t2.user_unread_privmsg) as user_unread_privmsg , COALESCE(t1.user_last_privmsg, t2.user_last_privmsg) as user_last_privmsg , COALESCE(t1.user_message_rules, t2.user_message_rules) as user_message_rules , COALESCE(t1.user_full_folder, t2.user_full_folder) as user_full_folder , COALESCE(t1.user_emailtime, t2.user_emailtime) as user_emailtime , COALESCE(t1.user_topic_show_days, t2.user_topic_show_days) as user_topic_show_days , COALESCE(t1.user_topic_sortby_type, t2.user_topic_sortby_type) as user_topic_sortby_type , COALESCE(t1.user_topic_sortby_dir, t2.user_topic_sortby_dir) as user_topic_sortby_dir , COALESCE(t1.user_post_show_days, t2.user_post_show_days) as user_post_show_days , COALESCE(t1.user_post_sortby_type, t2.user_post_sortby_type) as user_post_sortby_type , COALESCE(t1.user_post_sortby_dir, t2.user_post_sortby_dir) as user_post_sortby_dir , COALESCE(t1.user_notify, t2.user_notify) as user_notify , COALESCE(t1.user_notify_pm, t2.user_notify_pm) as user_notify_pm , COALESCE(t1.user_notify_type, t2.user_notify_type) as user_notify_type , COALESCE(t1.user_allow_pm, t2.user_allow_pm) as user_allow_pm , COALESCE(t1.user_allow_viewonline, t2.user_allow_viewonline) as user_allow_viewonline , COALESCE(t1.user_allow_viewemail, t2.user_allow_viewemail) as user_allow_viewemail , COALESCE(t1.user_allow_massemail, t2.user_allow_massemail) as user_allow_massemail , COALESCE(t1.user_options, t2.user_options) as user_options , COALESCE(t1.user_avatar, t2.user_avatar) as user_avatar , COALESCE(t1.user_avatar_type, t2.user_avatar_type) as user_avatar_type , COALESCE(t1.user_avatar_width, t2.user_avatar_width) as user_avatar_width , COALESCE(t1.user_avatar_height, t2.user_avatar_height) as user_avatar_height , COALESCE(t1.user_sig, t2.user_sig) as user_sig , COALESCE(t1.user_sig_bbcode_uid, t2.user_sig_bbcode_uid) as user_sig_bbcode_uid , COALESCE(t1.user_sig_bbcode_bitfield, t2.user_sig_bbcode_bitfield) as user_sig_bbcode_bitfield , COALESCE(t1.user_from, t2.user_from) as user_from , COALESCE(t1.user_icq, t2.user_icq) as user_icq , COALESCE(t1.user_aim, t2.user_aim) as user_aim , COALESCE(t1.user_yim, t2.user_yim) as user_yim , COALESCE(t1.user_msnm, t2.user_msnm) as user_msnm , COALESCE(t1.user_jabber, t2.user_jabber) as user_jabber , COALESCE(t1.user_website, t2.user_website) as user_website , COALESCE(t1.user_occ, t2.user_occ) as user_occ , COALESCE(t1.user_interests, t2.user_interests) as user_interests , COALESCE(t1.user_actkey, t2.user_actkey) as user_actkey , COALESCE(t1.user_newpasswd, t2.user_newpasswd) as user_newpasswd , COALESCE(t1.user_form_salt, t2.user_form_salt) as user_form_salt , COALESCE(t1.user_new, t2.user_new) as user_new , COALESCE(t1.user_reminded, t2.user_reminded) as user_reminded , COALESCE(t1.user_reminded_time, t2.user_reminded_time) as user_reminded_time , COALESCE(t3.user_id, t4.user_id) as user_id , COALESCE(t3.pf_group_pack, t4.pf_group_pack) as pf_group_pack , COALESCE(t3.pf_gender, t4.pf_gender) as pf_gender , fan_comment.m_id as m_id_comment,fan_author.m_id as m_id_gallery FROM fan_comment LEFT JOIN member ON (id = fan_comment.m_id) LEFT JOIN aphpbb_users as t1 on (member.user_id = t1.user_id and member.lang = 1) LEFT JOIN xphpbb_users as t2 on (member.user_id = t2.user_id and member.lang = 2) LEFT JOIN aphpbb_profile_fields_data as t3 on (member.user_id = t3.user_id and member.lang = 1) LEFT JOIN xphpbb_profile_fields_data as t4 on (member.user_id = t4.user_id and member.lang = 2) LEFT JOIN fan_author on (fan_comment.id_author = fan_author.id_author) WHERE 0=0 AND fan_comment.id_author = 5838 AND fan_comment.id_object = 163 AND fan_comment.type_module = 102 AND fan_comment.numsite = 1 ORDER BY fan_comment.date_posted DESC LIMIT 0,10


SELECT COUNT(*) as c FROM fan_comment LEFT JOIN member ON (id = fan_comment.m_id) LEFT JOIN aphpbb_users as t1 on (member.user_id = t1.user_id and member.lang = 1) LEFT JOIN xphpbb_users as t2 on (member.user_id = t2.user_id and member.lang = 2) LEFT JOIN aphpbb_profile_fields_data as t3 on (member.user_id = t3.user_id and member.lang = 1) LEFT JOIN xphpbb_profile_fields_data as t4 on (member.user_id = t4.user_id and member.lang = 2) LEFT JOIN fan_author on (fan_comment.id_author = fan_author.id_author) WHERE 0=0 AND fan_comment.id_author = 5838 AND fan_comment.id_object = 163 AND fan_comment.type_module = 102 AND fan_comment.numsite = 1

C'est du langage SQL.
En tout cas, ça concerne la BDD...
Et il me semble bien que les tables SQL en questions concernent les membres.

http://encyclopediadramatica.ch/Animation_Source