MEMBER: last_visit: / --

MEMBER: uagent_key: alexa

MEMBER: uagent_type: search

MEMBER: uagent_version: 0

SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','ranks','reputation_levels','chatting','birthdays','calendar_events','calendars','support_staff','support_departments','support_statuses','donation_goals','blog_stats','blogmods','idm_cats','idm_mods','nexus_ads' )

SELECT * FROM sessions WHERE id='alexa=5b5999d5c1ae15227c8559d61d262959_session'

DELETE FROM sessions WHERE id='alexa=5b5999d5c1ae15227c8559d61d262959_session' OR ip_address='204.236.226.210' OR id='alexa=9301e14a51cb76bbe3fa6623e29d3ce1_session'

SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )

SELECT * FROM skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')

SELECT id, member_id, member_name, seo_name, login_type, running_time, member_group, uagent_type FROM sessions WHERE running_time > 1358474030

SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' )

SELECT b.*,t.tpb_name FROM ccs_blocks b LEFT JOIN ccs_template_blocks t ON ( t.tpb_id=b.block_template ) WHERE b.block_active=1

SELECT cache_content FROM ccs_template_cache WHERE cache_type='full'

SELECT * FROM cache_store WHERE cs_key IN ( 'ccs_databases' )

SELECT * FROM cache_store WHERE cs_key IN ( 'ccs_fields' )

SHOW TABLES FROM `worlds33_ipb` LIKE 'ccs_custom_database_1'

SELECT c.*, c.category_id as catid,r.*,p.* FROM ccs_database_categories c LEFT JOIN ccs_custom_database_1 r ON ( r.primary_id_field=c.category_last_record_id AND r.record_approved=1 ) LEFT JOIN permission_index p ON ( p.perm_type='categories' AND p.app='ccs' AND p.perm_type_id=c.category_id ) WHERE c.category_database_id=1

SHOW fields FROM ccs_custom_database_1

SELECT * FROM ccs_custom_database_1 WHERE record_approved=1 AND category_id IN(1,18,25,2,6,10,14,3,4,7,8,11,12,15,16,31,36,41,42,32,33,37,38) AND field_4 <= 1358474931 ORDER BY record_saved desc LIMIT 0,7

SELECT * FROM cache_store WHERE cs_key IN ( 'emoticons' )

SELECT * FROM ccs_pages WHERE page_content LIKE '%\{parse articles\}%'

SELECT * FROM ccs_database_moderators WHERE moderator_database_id=1

SELECT * FROM ccs_custom_database_3 WHERE primary_id_field IN(16,13,7,6)

SELECT * FROM ccs_pages WHERE (page_content LIKE '%parse database="giochi"%' OR page_content LIKE '%parse database="giochi"%')

SELECT c.*, c.category_id as catid,r.*,p.* FROM ccs_database_categories c LEFT JOIN ccs_custom_database_3 r ON ( r.primary_id_field=c.category_last_record_id AND r.record_approved=1 ) LEFT JOIN permission_index p ON ( p.perm_type='categories' AND p.app='ccs' AND p.perm_type_id=c.category_id ) WHERE c.category_database_id=3

SELECT * FROM ccs_custom_database_2 WHERE primary_id_field IN(15,13,5,4)

SELECT * FROM ccs_pages WHERE (page_content LIKE '%parse database="video"%' OR page_content LIKE '%parse database="video"%')

SELECT c.*, c.category_id as catid,r.*,p.* FROM ccs_database_categories c LEFT JOIN ccs_custom_database_2 r ON ( r.primary_id_field=c.category_last_record_id AND r.record_approved=1 ) LEFT JOIN permission_index p ON ( p.perm_type='categories' AND p.app='ccs' AND p.perm_type_id=c.category_id ) WHERE c.category_database_id=2

SELECT * FROM ccs_custom_database_6 WHERE primary_id_field IN(17,10,5,2)

SELECT * FROM ccs_pages WHERE (page_content LIKE '%parse database="film"%' OR page_content LIKE '%parse database="film"%')

SELECT c.*, c.category_id as catid,r.*,p.* FROM ccs_database_categories c LEFT JOIN ccs_custom_database_6 r ON ( r.primary_id_field=c.category_last_record_id AND r.record_approved=1 ) LEFT JOIN permission_index p ON ( p.perm_type='categories' AND p.app='ccs' AND p.perm_type_id=c.category_id ) WHERE c.category_database_id=6

SELECT * FROM ccs_custom_database_6 WHERE primary_id_field IN(5)

SELECT * FROM ccs_custom_database_3 WHERE primary_id_field IN(6)

SELECT * FROM ccs_custom_database_3 WHERE primary_id_field IN(6)

SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (14,3,2)

UPDATE ccs_blocks SET block_cache_output='<link href=\'/media/css/slidorion.css\' rel=\'stylesheet\' /><link href=\'/media/css/style.css\' rel=\'stylesheet\' /><script src=\'/media/js/jquery.slidorion.min.js\'></script><style>#slidorion{ width:auto!important; }</style>\r\n \r\n <div id=\"slidorion\" >\r\n <div id=\"slider\" style=\"width:100%;\">\r\n \r\n <div id=\"slide1\" class=\"slide\">\r\n <div class=\"content\">\r\n <h2><a href=\"\">test</a></h2>\r\n <div></div>\r\n <a href=\"\"><img src=\"\"></a>\r\n </div>\r\n </div>\r\n \n\r\n <div id=\"slide2\" class=\"slide\">\r\n <div class=\"content\">\r\n <h2><a href=\"\">Libro</a></h2>\r\n <div>blablabab</div>\r\n <a href=\"\"><img src=\"\"></a>\r\n </div>\r\n </div>\r\n \n\r\n <div id=\"slide3\" class=\"slide\">\r\n <div class=\"content\">\r\n <h2><a href=\"\">Prova</a></h2>\r\n <div></div>\r\n <a href=\"\"><img src=\"/forum/uploads/394797ec8e4246e2a1f112037e623467.jpg\"></a>\r\n </div>\r\n </div>\r\n \n\r\n <div id=\"slide4\" class=\"slide\">\r\n <div class=\"content\">\r\n <h2><a href=\"\">Evviva gli Argonauti</a></h2>\r\n <div></div>\r\n <a href=\"\"><img src=\"\"></a>\r\n </div>\r\n </div>\r\n \n\r\n <div id=\"slide5\" class=\"slide\">\r\n <div class=\"content\">\r\n <h2><a href=\"\">Ho detto che spacca!</a></h2>\r\n <div></div>\r\n <a href=\"\"><img src=\"\"></a>\r\n </div>\r\n </div>\r\n \n\r\n <div id=\"slide6\" class=\"slide\">\r\n <div class=\"content\">\r\n <h2><a href=\"\">Planetside 2 spacca</a></h2>\r\n <div></div>\r\n <a href=\"\"><img src=\"/forum/uploads/c74e88e5a8273bfe4d569de85eb325fe.jpg\"></a>\r\n </div>\r\n </div>\r\n \n\r\n <div id=\"slide7\" class=\"slide\">\r\n <div class=\"content\">\r\n <h2><a href=\"\">splinter cell</a></h2>\r\n <div>Splinter cell</div>\r\n <a href=\"\"><img src=\"/forum/uploads/250290de7e71c9671bfc7be71335bf27.jpg\"></a>\r\n </div>\r\n </div>\r\n \n </div>\r\n \r\n <div id=\"accordion\" style=\"width:100%;\">\r\n \r\n <div class=\"link-header left clickable\" style=\"width:160px;height: 40px;\">test</div>\r\n <div class=\"link-content\" style=\'display:none;\'></div>\r\n \n\r\n <div class=\"link-header left clickable\" style=\"width:160px;height: 40px;\">Libro</div>\r\n <div class=\"link-content\" style=\'display:none;\'></div>\r\n \n\r\n <div class=\"link-header left clickable\" style=\"width:160px;height: 40px;\">Prova</div>\r\n <div class=\"link-content\" style=\'display:none;\'></div>\r\n \n\r\n <div class=\"link-header left clickable\" style=\"width:160px;height: 40px;\">Evviva gli Argonauti</div>\r\n <div class=\"link-content\" style=\'display:none;\'></div>\r\n \n\r\n <div class=\"link-header left clickable\" style=\"width:160px;height: 40px;\">Ho detto che spacca!</div>\r\n <div class=\"link-content\" style=\'display:none;\'></div>\r\n \n\r\n <div class=\"link-header left clickable\" style=\"width:160px;height: 40px;\">Planetside 2 spacca</div>\r\n <div class=\"link-content\" style=\'display:none;\'></div>\r\n \n\r\n <div class=\"link-header left clickable\" style=\"width:160px;height: 40px;\">splinter cell</div>\r\n <div class=\"link-content\" style=\'display:none;\'></div>\r\n \n </div>\r\n </div>\r\n<br class=\'clear\' />\r\n <script>\r\njQuery(\'#slidorion\').slidorion({\r\n effect: \'fade\',\r\n hoverPause: true,\r\n interval: 8000,\r\n speed: 1\r\n });\r\n \r\n </script>\r\n',block_cache_last=1358474931 WHERE block_id=3

SELECT * FROM cache_simple WHERE cache_id='b8be4bd0f565a43fdd9aa4b71860ae20' AND cache_perm_key='c81e728d9d4c2f636f067f89cc14862c'

SELECT t.tag_text, COUNT(t.tag_text) as times, t.tag_meta_app, t.tag_meta_area FROM core_tags t WHERE 1=1 AND t.tag_aai_lookup IN( SELECT p.tag_perm_aai_lookup FROM core_tags_perms p WHERE ( ( FIND_IN_SET(2,p.tag_perm_text) ) OR ( p.tag_perm_text='*' ) ) AND p.tag_perm_visible=1 ) GROUP BY t.tag_text ORDER BY times DESC LIMIT 0, 50

INSERT INTO cache_simple (`cache_id`,`cache_perm_key`,`cache_time`,`cache_data`) VALUES('b8be4bd0f565a43fdd9aa4b71860ae20','c81e728d9d4c2f636f067f89cc14862c',1358474930,'a:2:{s:4:\"tags\";a:50:{i:0;a:6:{s:3:\"tag\";s:7:\"ubisoft\";s:5:\"count\";s:1:\"5\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:6:\"100.00\";s:6:\"weight\";s:4:\"1.00\";}i:1;a:6:{s:3:\"tag\";s:6:\"hitman\";s:5:\"count\";s:1:\"2\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"40.00\";s:6:\"weight\";s:4:\"0.40\";}i:2;a:6:{s:3:\"tag\";s:6:\"ZombiU\";s:5:\"count\";s:1:\"2\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"40.00\";s:6:\"weight\";s:4:\"0.40\";}i:3;a:6:{s:3:\"tag\";s:3:\"FPS\";s:5:\"count\";s:1:\"2\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"40.00\";s:6:\"weight\";s:4:\"0.40\";}i:4;a:6:{s:3:\"tag\";s:9:\"far cry 3\";s:5:\"count\";s:1:\"2\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"40.00\";s:6:\"weight\";s:4:\"0.40\";}i:5;a:6:{s:3:\"tag\";s:6:\"hobbit\";s:5:\"count\";s:1:\"2\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_6\";s:7:\"percent\";s:5:\"40.00\";s:6:\"weight\";s:4:\"0.40\";}i:6;a:6:{s:3:\"tag\";s:11:\"king arthur\";s:5:\"count\";s:1:\"2\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_6\";s:7:\"percent\";s:5:\"40.00\";s:6:\"weight\";s:4:\"0.40\";}i:7;a:6:{s:3:\"tag\";s:4:\"halo\";s:5:\"count\";s:1:\"2\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"40.00\";s:6:\"weight\";s:4:\"0.40\";}i:8;a:6:{s:3:\"tag\";s:10:\"dishonored\";s:5:\"count\";s:1:\"2\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"40.00\";s:6:\"weight\";s:4:\"0.40\";}i:9;a:6:{s:3:\"tag\";s:20:\"meteor entertainment\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:10;a:6:{s:3:\"tag\";s:6:\"hawken\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:11;a:6:{s:3:\"tag\";s:10:\"blablablal\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_1\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:12;a:6:{s:3:\"tag\";s:6:\"mmorts\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:13;a:6:{s:3:\"tag\";s:5:\"trion\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:14;a:6:{s:3:\"tag\";s:28:\"unknown worlds entertainment\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:15;a:6:{s:3:\"tag\";s:10:\"petroglyph\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:16;a:6:{s:3:\"tag\";s:8:\"2k games\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:17;a:6:{s:3:\"tag\";s:7:\"stealth\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:18;a:6:{s:3:\"tag\";s:24:\"call of duty black ops 2\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:19;a:6:{s:3:\"tag\";s:12:\"planetside 2\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:20;a:6:{s:3:\"tag\";s:19:\"natural SELECTion 2\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:21;a:6:{s:3:\"tag\";s:16:\"war of the roses\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:22;a:6:{s:3:\"tag\";s:8:\"chivalry\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:23;a:6:{s:3:\"tag\";s:17:\"lord of the rings\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:24;a:6:{s:3:\"tag\";s:14:\"arkane studios\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:25;a:6:{s:3:\"tag\";s:17:\"assassins creed 3\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:26;a:6:{s:3:\"tag\";s:10:\"activision\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:27;a:6:{s:3:\"tag\";s:19:\"torn banner studios\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:28;a:6:{s:3:\"tag\";s:8:\"fatshark\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:29;a:6:{s:3:\"tag\";s:10:\"aventurine\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:30;a:6:{s:3:\"tag\";s:9:\"sondaggio\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:6:\"forums\";s:7:\"section\";s:0:\"\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:31;a:6:{s:3:\"tag\";s:3:\"SoE\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:32;a:6:{s:3:\"tag\";s:11:\"racing game\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:33;a:6:{s:3:\"tag\";s:10:\"dragonborn\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:34;a:6:{s:3:\"tag\";s:8:\"fanghoul\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_1\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:35;a:6:{s:3:\"tag\";s:8:\"darkfall\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:36;a:6:{s:3:\"tag\";s:14:\"end of nations\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:37;a:6:{s:3:\"tag\";s:9:\"milestone\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:38;a:6:{s:3:\"tag\";s:8:\"adsadasa\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:6:\"forums\";s:7:\"section\";s:0:\"\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:39;a:6:{s:3:\"tag\";s:4:\"lego\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:40;a:6:{s:3:\"tag\";s:8:\"treyarch\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:41;a:6:{s:3:\"tag\";s:19:\"xcom: enemy unknown\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:42;a:6:{s:3:\"tag\";s:6:\"MMOFPS\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:43;a:6:{s:3:\"tag\";s:17:\"the elder scrolls\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:44;a:6:{s:3:\"tag\";s:19:\"paradox interactive\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:45;a:6:{s:3:\"tag\";s:6:\"mmorpg\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:46;a:6:{s:3:\"tag\";s:7:\"fps/rts\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:47;a:6:{s:3:\"tag\";s:6:\"skyrim\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_2\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:48;a:6:{s:3:\"tag\";s:21:\"darkfall: unholy wars\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}i:49;a:6:{s:3:\"tag\";s:5:\"wrc 3\";s:5:\"count\";s:1:\"1\";s:3:\"app\";s:3:\"ccs\";s:7:\"section\";s:10:\"database_3\";s:7:\"percent\";s:5:\"20.00\";s:6:\"weight\";s:4:\"0.20\";}}s:4:\"nums\";a:3:{s:3:\"min\";s:1:\"1\";s:3:\"max\";s:1:\"5\";s:5:\"count\";i:62;}}') ON DUPLICATE KEY UPDATE cache_id=VALUES(cache_id),cache_perm_key=VALUES(cache_perm_key),cache_time=VALUES(cache_time),cache_data=VALUES(cache_data)

SELECT t.tid, t.title as topic_title, t.title_seo, t.start_date, t.starter_id, t.starter_name, t.moved_to, t.views, t.posts,m.*,pp.* FROM topics t LEFT JOIN members m ON ( m.member_id=t.starter_id ) LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) WHERE t.tid IN (10,9,4,3,2)