SELECT `sites`.`id` AS t0_r0, `sites`.`site_name` AS t0_r1, `sites`.`site_url` AS t0_r2, `sites`.`site_logo` AS t0_r3, `sites`.`site_domain` AS t0_r4, `sites`.`created_at` AS t0_r5, `sites`.`updated_at` AS t0_r6, `sites`.`flags_enabled` AS t0_r7, `sites`.`max_flags_per_post` AS t0_r8, `sites`.`is_child_meta` AS t0_r9, `sites`.`last_users_update` AS t0_r10, `posts`.`id` AS t1_r0, `posts`.`title` AS t1_r1, `posts`.`body` AS t1_r2, `posts`.`link` AS t1_r3, `posts`.`post_creation_date` AS t1_r4, `posts`.`created_at` AS t1_r5, `posts`.`updated_at` AS t1_r6, `posts`.`site_id` AS t1_r7, `posts`.`u…