lol.sql

=> "SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM universes WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM characters WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM locations WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM items WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM buildings WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM conditions WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM continents WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM countries WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM creatures WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM deities WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM floras WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM foods WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM governments WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM groups WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM jobs WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM landmarks WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM languages WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM lores WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM magics WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM planets WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM races WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM religions WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM scenes WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM schools WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM sports WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM technologies WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM towns WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM traditions WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 UNION ALL SELECT id,name,page_type,user_id,created_at,updated_at,deleted_at,archived_at,privacy,universe_id FROM vehicles WHERE user_id = 1 AND deleted_at IS NULL AND archived_at IS NULL AND universe_id = 2 ORDER BY page_type, id"