Мои маст хэв запросы, чтоб не забыть
SELECT `topic_id`,`peer_id` FROM `bb_bt_tracker` WHERE 1 GROUP BY `user_id` ORDER BY `peer_id` LIMIT 10000 SELECT * FROM phpbb_users WHERE `user_id_motolodka` IN ( SELECT * FROM phpbb_users GROUP BY `user_email` HAVING COUNT( `user_email` ) > 1 LIMIT 0 , 30 ) ORDER BY `user_id_motolodka` LIMIT 0 , 30 DELETE FROM `phpbb_users` WHERE `user_id`>48; DELETE FROM `phpbb_user_group` WHERE `user_id`>48; DELETE FROM `phpbb_user_notifications` WHERE `user_id`>48; DELETE FROM `phpbb_profile_fields_data` WHERE `user_id`>2; ALTER TABLE phpbb_users AUTO_INCREMENT=0; ALTER TABLE phpbb_profile_fields_data AUTO_INCREMENT=0; UPDATE `phpbb_config` SET `config_value`=2 WHERE `config_name`='num_users';
UPDATE bb_bookmarks SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_bt_dlstatus_main SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_bt_dlstatus_mrg SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_bt_dlstatus_new SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_bt_last_torstat SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_bt_torrents SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_bt_torstat SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_bt_tracker SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_bt_tracker_snap SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_posts SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_topics SET topic_id= 12512 WHERE topic_id= 100334; UPDATE bb_topics_watch SET topic_id= 12512 WHERE topic_id= 100334;