1 | SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_h1`, `Site`.`introduction`, `Site`.`site_intro`, `Site`.`site_keyword`, `Site`.`site_url`, `Site`.`site_body`, `Site`.`analysis`, `Site`.`news_num`, `Site`.`disp_flag`, `Site`.`sitemap_flag`, `Site`.`contact_flag`, `Site`.`created`, `Site`.`modified` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
2 | SELECT `Site`.`id`, `Site`.`site_name`, `Site`.`site_h1`, `Site`.`introduction`, `Site`.`site_intro`, `Site`.`site_keyword`, `Site`.`site_url`, `Site`.`site_body`, `Site`.`analysis`, `Site`.`news_num`, `Site`.`disp_flag`, `Site`.`sitemap_flag`, `Site`.`contact_flag`, `Site`.`created`, `Site`.`modified` FROM `sites` AS `Site` WHERE `Site`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
3 | SELECT `Space`.`space_name`, `Space`.`id`, `Space`.`space_file`, `Space`.`adv_type`, `Space`.`adv_timage`, `Space`.`adv_tagtitle`, `Space`.`adv_tagtext`, `Space`.`adv_text`, `Space`.`adv_intro`, `Space`.`adv_html`, `Space`.`adv_image`, `Space`.`adv_url`, `Space`.`adv_alt`, `Space`.`adv_follow`, `Space`.`adv_target`, `Space`.`adv_space` FROM `spaces` AS `Space` WHERE `Space`.`use_flag` = 1 ORDER BY `Space`.`id` DESC | | 4 | 4 | 0 |
4 | SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 7 AND `Advertisement`.`start_date` < '2024-11-21 21:46:44' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-21 21:46:44')))) | | 1 | 1 | 0 |
5 | SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 6 AND `Advertisement`.`start_date` < '2024-11-21 21:46:44' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-21 21:46:44')))) | | 1 | 1 | 22 |
6 | SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 5 AND `Advertisement`.`start_date` < '2024-11-21 21:46:44' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-21 21:46:44')))) | | 1 | 1 | 16 |
7 | SELECT COUNT(*) AS `count` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 4 AND `Advertisement`.`start_date` < '2024-11-21 21:46:44' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-21 21:46:44')))) | | 1 | 1 | 18 |
8 | SELECT `Advertisement`.`adv_name`, `Advertisement`.`adv_type`, `Advertisement`.`adv_text`, `Advertisement`.`adv_timage`, `Advertisement`.`adv_tagtitle`, `Advertisement`.`adv_tagtext`, `Advertisement`.`adv_intro`, `Advertisement`.`adv_html`, `Advertisement`.`adv_image`, `Advertisement`.`adv_url`, `Advertisement`.`adv_alt`, `Advertisement`.`adv_follow`, `Advertisement`.`adv_target`, `Advertisement`.`adv_space` FROM `advertisements` AS `Advertisement` LEFT JOIN `spaces` AS `Space` ON (`Advertisement`.`space_id` = `Space`.`id`) WHERE `Advertisement`.`use_flag` = 1 AND `Advertisement`.`space_id` = 4 AND `Advertisement`.`start_date` < '2024-11-21 21:46:44' AND ((`Advertisement`.`end_flag` = 0) OR (((`Advertisement`.`end_flag` = 1) AND (`Advertisement`.`end_date` > '2024-11-21 21:46:44')))) ORDER BY `Advertisement`.`id` DESC | | 1 | 1 | 20 |
9 | SELECT `Ranking`.`id`, `Ranking`.`ng_ip`, `Ranking`.`recognition_flag`, `Ranking`.`limit_rating`, `Ranking`.`type_write`, `Ranking`.`created`, `Ranking`.`modified` FROM `rankings` AS `Ranking` WHERE `Ranking`.`id` = 1 LIMIT 1 | | 1 | 1 | 4 |
10 | SELECT `Basis`.`title`, `Basis`.`path_file`, `Basis`.`new_text`, `Basis`.`cat_id`, `Basis`.`disp_date`, `Category`.`belong_id`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`new_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-21 21:46:44' ORDER BY `Basis`.`disp_date` DESC, `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 2 | | 2 | 2 | 3 |
11 | SELECT `Category`.`id`, `Category`.`belong_id`, `Category`.`position`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Category`.`cat_temp`, `Category`.`list_temp`, `Category`.`order`, `Category`.`cat_description`, `Category`.`cat_keyword`, `Category`.`cat_exp`, `Category`.`catchcopy`, `Category`.`lead`, `Category`.`keitai_flag`, `Category`.`disp_flag`, `Category`.`pimg_size`, `Category`.`rank_flag`, `Category`.`limit_page`, `Category`.`renewal_adm`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`id` = 5 LIMIT 1 | | 1 | 1 | 3 |
12 | SELECT `Basis`.`id`, `Basis`.`title`, `Basis`.`cat_id`, `Basis`.`path_file`, `Basis`.`keyword`, `Basis`.`description`, `Basis`.`image`, `Basis`.`img_size`, `Basis`.`link_url`, `Basis`.`order`, `Basis`.`rate_number`, `Basis`.`rate_member`, `Basis`.`catchcopy`, `Basis`.`lead`, `Basis`.`page_temp`, `Basis`.`cont_temp`, `Basis`.`topdisp_flag`, `Basis`.`new_flag`, `Basis`.`renewal_flag`, `Basis`.`pickup_flag`, `Basis`.`bkup_flag`, `Basis`.`keitai_flag`, `Basis`.`new_text`, `Basis`.`comment_flag`, `Basis`.`list_disp_flag`, `Basis`.`disp_flag`, `Basis`.`disp_date`, `Basis`.`page_memo`, `Basis`.`renewal_adm`, `Basis`.`created`, `Basis`.`modified` FROM `bases` AS `Basis` WHERE `Basis`.`cat_id` = (5) ORDER BY `Basis`.`order` DESC | | 38 | 38 | 0 |
13 | SELECT `Category`.`id`, `Category`.`belong_id`, `Category`.`position`, `Category`.`cat_name`, `Category`.`cat_path_file`, `Category`.`cat_temp`, `Category`.`list_temp`, `Category`.`order`, `Category`.`cat_description`, `Category`.`cat_keyword`, `Category`.`cat_exp`, `Category`.`catchcopy`, `Category`.`lead`, `Category`.`keitai_flag`, `Category`.`disp_flag`, `Category`.`pimg_size`, `Category`.`rank_flag`, `Category`.`limit_page`, `Category`.`renewal_adm`, `Category`.`created`, `Category`.`modified` FROM `categories` AS `Category` WHERE `Category`.`id` = 5 LIMIT 1 | | 1 | 1 | 0 |
14 | SELECT `Basis`.`id`, `Basis`.`title`, `Basis`.`cat_id`, `Basis`.`path_file`, `Basis`.`keyword`, `Basis`.`description`, `Basis`.`image`, `Basis`.`img_size`, `Basis`.`link_url`, `Basis`.`order`, `Basis`.`rate_number`, `Basis`.`rate_member`, `Basis`.`catchcopy`, `Basis`.`lead`, `Basis`.`page_temp`, `Basis`.`cont_temp`, `Basis`.`topdisp_flag`, `Basis`.`new_flag`, `Basis`.`renewal_flag`, `Basis`.`pickup_flag`, `Basis`.`bkup_flag`, `Basis`.`keitai_flag`, `Basis`.`new_text`, `Basis`.`comment_flag`, `Basis`.`list_disp_flag`, `Basis`.`disp_flag`, `Basis`.`disp_date`, `Basis`.`page_memo`, `Basis`.`renewal_adm`, `Basis`.`created`, `Basis`.`modified` FROM `bases` AS `Basis` WHERE `Basis`.`cat_id` = (5) ORDER BY `Basis`.`order` DESC | | 38 | 38 | 0 |
15 | SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag`, `Category`.`rank_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 0 ORDER BY `Category`.`order` ASC | | 5 | 5 | 0 |
16 | SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-21 21:46:44' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 2 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC | | 8 | 8 | 1 |
17 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 15 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 3 |
18 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 15 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
19 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 15 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
20 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 2 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
21 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 2 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
22 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 2 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
23 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 35 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
24 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 35 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
25 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 35 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
26 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 6 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
27 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 6 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
28 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 6 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
29 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 5 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
30 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 5 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
31 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 5 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
32 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 4 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
33 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 4 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
34 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 4 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
35 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 3 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
36 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 3 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
37 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 3 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
38 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 73 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
39 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 73 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
40 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 73 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
41 | SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 2 ORDER BY `Category`.`order` ASC | | 1 | 1 | 0 |
42 | SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-21 21:46:44' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 1 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC | | 11 | 11 | 2 |
43 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 19 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
44 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 19 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
45 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 19 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
46 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 1 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
47 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 1 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
48 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 1 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
49 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 21 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
50 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 21 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
51 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 21 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
52 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 20 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
53 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 20 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
54 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 20 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
55 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 23 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
56 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 23 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
57 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 23 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
58 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 22 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
59 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 22 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
60 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 22 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
61 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 24 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
62 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 24 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
63 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 24 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
64 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 42 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
65 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 42 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
66 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 42 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
67 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 66 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
68 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 66 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
69 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 66 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
70 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 52 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
71 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 52 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
72 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 52 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
73 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 25 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
74 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 25 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
75 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 25 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
76 | SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 1 ORDER BY `Category`.`order` ASC | | 0 | 0 | 0 |
77 | SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-21 21:46:44' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 5 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC | | 21 | 21 | 2 |
78 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 87 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
79 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 87 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
80 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 87 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
81 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 87 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
82 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 68 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
83 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 68 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
84 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 68 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
85 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 68 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
86 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 18 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
87 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 18 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
88 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 18 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
89 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 18 ORDER BY `ContentList`.`id` ASC | | 13 | 13 | 0 |
90 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 77 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
91 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 77 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
92 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 77 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
93 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 77 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
94 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 78 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
95 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 78 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
96 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 78 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
97 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 78 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
98 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 95 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
99 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 95 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
100 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 95 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
101 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 95 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
102 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 93 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
103 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 93 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
104 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 93 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
105 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 93 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
106 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 91 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
107 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 91 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
108 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 91 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
109 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 91 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
110 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 90 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
111 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 90 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
112 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 90 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
113 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 90 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
114 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 88 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
115 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 88 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
116 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 88 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
117 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 88 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
118 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 86 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
119 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 86 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
120 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 86 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
121 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 86 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
122 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 85 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
123 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 85 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
124 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 85 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
125 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 85 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
126 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 79 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
127 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 79 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
128 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 79 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
129 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 79 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
130 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 34 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
131 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 34 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
132 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 34 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
133 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 34 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
134 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 33 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
135 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 33 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
136 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 33 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
137 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 33 ORDER BY `ContentList`.`id` ASC | | 11 | 11 | 0 |
138 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 9 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
139 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 9 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
140 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 9 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
141 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 9 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
142 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 80 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
143 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 80 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
144 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 80 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
145 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 80 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
146 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 32 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
147 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 32 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
148 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 32 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
149 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 32 ORDER BY `ContentList`.`id` ASC | | 11 | 11 | 0 |
150 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 17 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
151 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 17 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
152 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 17 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
153 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 17 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
154 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 81 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
155 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 81 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
156 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 81 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
157 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 81 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
158 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 70 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
159 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 70 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
160 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 70 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
161 | SELECT `ContentList`.`tag_value`, `ContentList`.`tag_type`, `ContentList`.`alt`, `ContentList`.`tag_field`, `ContentList`.`tag_name` FROM `content_lists` AS `ContentList` WHERE `ContentList`.`base_id` = 70 ORDER BY `ContentList`.`id` ASC | | 12 | 12 | 0 |
162 | SELECT `Category`.`id`, `Category`.`cat_name`, `Category`.`belong_id`, `Category`.`cat_path_file`, `Category`.`disp_flag` FROM `categories` AS `Category` WHERE `Category`.`disp_flag` = 1 AND `Category`.`belong_id` = 5 ORDER BY `Category`.`order` ASC | | 1 | 1 | 0 |
163 | SELECT `Basis`.`id`, `Basis`.`image`, `Basis`.`title`, `Basis`.`path_file`, `Basis`.`pickup_flag`, `Category`.`cat_path_file`, `Category`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`disp_flag` = 1 AND `Basis`.`disp_date` <= '2024-11-21 21:46:44' AND `Basis`.`list_disp_flag` = 1 AND `Basis`.`cat_id` = 3 ORDER BY `Basis`.`order` ASC, `Content`.`id` DESC, `MContent`.`id` DESC | | 13 | 13 | 1 |
164 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 41 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 3 |
165 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 41 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
166 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 41 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
167 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 44 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
168 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 44 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
169 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 44 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
170 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 46 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
171 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 46 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
172 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 46 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
173 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 48 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
174 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 48 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
175 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 48 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
176 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 47 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
177 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 47 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
178 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 47 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
179 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 51 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
180 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 51 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
181 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 51 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
182 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 49 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
183 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 49 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
184 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 49 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
185 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 60 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
186 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 60 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
187 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 60 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
188 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 45 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
189 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 45 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
190 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 45 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
191 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 56 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
192 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 56 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
193 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 56 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
194 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 50 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
195 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 50 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
196 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 50 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
197 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 98 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |
198 | SELECT sum(rating) as sum_rating FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 98 AND `Rating`.`disp_flag` = 1 ORDER BY `Rating`.`id` ASC | | 1 | 1 | 0 |
199 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`base_id` = 98 AND `Rating`.`disp_flag` = 1 | | 1 | 1 | 0 |
200 | SELECT `Basis`.`rate_member`, `Basis`.`rate_number`, `Basis`.`id` FROM `bases` AS `Basis` LEFT JOIN `categories` AS `Category` ON (`Basis`.`cat_id` = `Category`.`id`) LEFT JOIN `contents` AS `Content` ON (`Content`.`base_id` = `Basis`.`id`) LEFT JOIN `m_contents` AS `MContent` ON (`MContent`.`base_id` = `Basis`.`id`) WHERE `Basis`.`id` = 55 ORDER BY `Content`.`id` DESC, `MContent`.`id` DESC LIMIT 1 | | 1 | 1 | 0 |