tpokorra
New update:
Wrong SQL: INSERT INTO discussions ( id, title, comments_count, participants_count, start_time, start_user_id, last_time, last_user_id, slug, is_private ) VALUES ('6802', '\"Looking for genuine BPO Non voice projects? Here is the great opportunity for the startups\" was flagged as spam', '2', '1', '2016-09-07 02:24:39.968105', '-1', '2016-09-07 02:24:40.618333', '-1', 'looking-for-genuine-bpo-non-voice-projects-here-is-the-great-opportunity-for-the-startups-was-flagged-as-spam', '1' );
Importing new discussions_tags item... (3710)
Importing new discussions_tags item... (7420)
Importing new discussions_tags item... (11130)
Importing new discussions_tags item... (14840)
Importing new discussions_tags item... (18550)
18553 out of 18553 total discussions_tags items converted.
UPDATE discussions d SET is_private=1 WHERE EXISTS (SELECT * FROM discussions_tags dt, tags t where dt.discussion_id = d.id and dt.tag_id = t.id and t.name='Staff')
UPDATE posts p SET is_private=1 WHERE EXISTS (SELECT * FROM discussions d where d.id = p.discussion_id and d.is_private=1)
UPDATE posts p SET is_private=1 WHERE p.user_id<=0
UPDATE discussions d SET is_private=1 WHERE NOT EXISTS (SELECT * from posts p WHERE p.discussion_id = d.id and p.is_private=0)
UPDATE tags t SET t.discussions_count = (SELECT COUNT(*) FROM discussions_tags dt, discussions d WHERE dt.discussion_id = d.id AND dt.tag_id = t.id AND d.is_private=0)
UPDATE tags t SET is_hidden=1, is_restricted=1 WHERE t.discussions_count = 0
DELETE FROM users WHERE id=1
Exporting: SELECT u.id, username, email, password_hash, u.created_at, last_posted_at FROM users u, user_emails um WHERE user_id=u.id AND "primary"=true AND u.id > 0 ORDER BY u.id
Importing new users item... (3724)
Importing new users item... (7448)
Importing new users item... (11172)
Importing new users item... (14896)
Importing new users item... (18620)
18624 out of 18624 total users items converted.
UPDATE users u SET discussions_count=(SELECT count() FROM discussions d WHERE d.is_private=0 AND d.start_user_id=u.id)
UPDATE users u SET comments_count=(SELECT count() FROM posts p WHERE p.is_private=0 AND p.user_id=u.id)