KmH72jEa

1CREATE TEMPORARY TABLE IF NOT EXISTS tmp_access_with_motherdivision_records AS (SELECT * FROM access WHERE player_id=66143);
2
3INSERT INTO tmp_access_with_motherdivision_records
4		(
5			club_id,
6			sector,
7			area,
8			sub,
9			`level`,
10			player_id,
11			status
12		)
13		SELECT new_clubs.id, '', '', '', 100, 66143, 'Active'
14		FROM new_clubs
15		JOIN `access` ON new_clubs.subdiv_to = `access`.club_id
16			WHERE `access`.sector = '' AND `access`.area = ''
17			AND `access`.sub = '' AND `access`.`level` <= 200
18			AND `access`.player_id = 66143
19			AND `access`.status = 'Active';
20
21SELECT ftpTopic_ID as topic_id, ftpForum_ID as forum_id, ftpTopicTitle as topic_title, ftpTopicCreated_DT as topic_created_date, ftpTopicStatus as topic_status, ftpTopicStatusLock as topic_status_lock, ftpTopicType as topic_type, ftpTopicViews as topic_views, ftpTopicReplies as topic_replies, ftpTopicFirstPoster_ID as author_id, ftpTopicFirstPosterName as author_name, ftpPost_ID as topic_post_id, ftpTopicLastPost_ID as last_post_id, ftpTopicLastPoster_ID as last_person_id, ftpTopicLastPosterName as last_person_name, ftpTopicLastPostSubject as last_post_subject, ftpTopicLastPostTime_DT as last_post_date, forum.club_code as forum_club_id, master.id as master_id, master.name as master_name, master.birthday as master_birthday, messages.status as message_status, messages.norank as message_norank, body.body as message_body, access.id as access_id, access.level as access_level, access.club_id as access_club_id, access.status as access_status, access.alias as access_alias, access.sector as access_sector, access.area as access_area, access.sub as access_sub, rank.name as rank_name, rank.abbrev as rank_short_name, reply_master.id as reply_master_id, reply_master.name as reply_master_name, reply_master.birthday as reply_master_birthday, reply_post.status as reply_message_status, reply_post.norank as reply_message_norank, reply_body.body as reply_message_body, reply_access.id as reply_access_id, reply_access.level as reply_access_level, reply_access.club_id as reply_access_club_id, reply_access.status as reply_access_status, reply_access.alias as reply_access_alias, reply_access.sector as reply_access_sector, reply_access.area as reply_access_area, reply_access.sub as reply_access_sub, reply_rank.name as reply_rank_name, reply_rank.abbrev as reply_rank_short_name FROM tmp_access_with_motherdivision_records AS auth_access LEFT JOIN .cl_info AS forum ON forum.disabled = 0 AND ( forum.club_id = 0 || forum.access = 0 || auth_access.club_id = forum.club_id || auth_access.mod_club_id = forum.club_id || auth_access.mod_club_id = 0 ) AND ( auth_access.status = forum.astatus || forum.astatus = "" || forum.astatus IS null ) AND ( forum.access = 0 || ( auth_access.level <= forum.access AND ( auth_access.sector = forum.sector || ( auth_access.sector = "" || auth_access.sector IS null || forum.sector = "%" ) ) AND ( auth_access.area    = forum.area || ( auth_access.area = "" || auth_access.area IS null || forum.area = "%" ) ) AND ( auth_access.sector = forum.sub || ( auth_access.sub = "" || auth_access.sub IS null || forum.sub = "%" ) ) ) )	LEFT JOIN .cl_topics AS topic  ON forum.id = topic.ftpForum_ID LEFT JOIN .master AS master  ON ftpTopicFirstPoster_ID = master.id LEFT JOIN .cl_messages AS messages   ON ftpPost_ID = messages.id LEFT JOIN .cl_body AS body   ON messages.id = body.msg_id LEFT JOIN .access AS access   ON messages.access_id = access.id LEFT JOIN .ranks AS rank   ON access.rank_id = rank.rank_id LEFT JOIN .master AS reply_master  ON ftpTopicLastPoster_ID = reply_master.id LEFT JOIN .cl_messages AS reply_post  ON ftpTopicLastPost_ID = reply_post.id LEFT JOIN .cl_body AS reply_body   ON ftpTopicLastPost_ID = reply_body.msg_id LEFT JOIN .access AS reply_access  ON reply_post.access_id = reply_access.id LEFT JOIN .ranks AS reply_rank   ON reply_access.rank_id = reply_rank.rank_id WHERE ftpForum_ID = 2091 AND ftpTopicType IN (0, 1, 3, 5, 7) AND auth_access.player_id = 66143 GROUP BY ftpTopic_Id ORDER BY ftpTopicType DESC, ftpTopicLastPostTime_DT DESC LIMIT 0, 20