1. set names utf8

2. SET SESSION sql_mode = ''

3. select * from g5_config

4. select * from g5_shop_default

5. select * from g5_new_win where '2015-06-20 13:42:48' between nw_begin_time and nw_end_time and nw_device IN ( 'both', 'pc' ) and nw_division IN ( 'both', 'comm' ) order by nw_id asc

6. select sum(IF(mb_id<>'',1,0)) as mb_cnt, count(*) as total_cnt from g5_login  where mb_id <> 'admin'

7. select * from g5_menu where me_use = '1' and length(me_code) = '2' order by me_order, me_id

8. select * from g5_menu where me_use = '1' and length(me_code) = '4' and substring(me_code, 1, 2) = '10' order by me_order, me_id

9. select MAX(po_id) as max_po_id from g5_poll

10. select bo_table from `g5_board` a left join `g5_group` b on (a.gr_id=b.gr_id) where a.bo_device <> 'mobile'  and a.bo_use_cert = ''  order by b.gr_order, a.bo_order

11. select * from g5_board where bo_table = 'notice'

12. select * from g5_write_notice where wr_is_comment = 0 order by wr_num limit 0, 5

13. select * from g5_board where bo_table = 'qa'

14. select * from g5_write_qa where wr_is_comment = 0 order by wr_num limit 0, 5

15. select * from g5_board where bo_table = 'free'

16. select * from g5_write_free where wr_is_comment = 0 order by wr_num limit 0, 5

17. select pp_word, count(*) as cnt from g5_popular where pp_date between '2015-06-17' and '2015-06-20' group by pp_word order by cnt desc, pp_word limit 0, 7

18. select count(*) as cnt from g5_login where lo_ip = '::1'

19. update g5_login set mb_id = '', lo_datetime = '2015-06-20 13:42:48', lo_location = '그누보드5', lo_url = '/yc5037/' where lo_ip = '::1'