Mira – Refreshed trailer | Adventure Gamers

SELECT wt.entry_id as entry_id, we.entry_id as review_id, wt.title, we.field_id_46 as ranking, wd.field_id_71 as sequence FROM exp_channel_titles AS wt, exp_channel_data AS wd LEFT JOIN exp_playa_relationships as rl ON (rl.child_entry_id = wd.entry_id AND rl.parent_field_id = 31) LEFT be part of exp_channel_data as we ON we.entry_id = rl.parent_entry_id WHERE wt.entry_id NOT IN (SELECT entry_id FROM exp_category_posts WHERE cat_id = 10) AND wd.channel_id = '2' AND wt.standing = 'open' AND wt.entry_id = wd.entry_id AND wd.field_id_19 NOT LIKE '%Hidden Object' AND wd.field_id_85 != '0'  AND wd.field_id_17 = 'Third-Particular person'  AND wd.field_id_23 = 'Illustrated realism'  AND wd.field_id_76 = 'Fantasy'  AND wd.field_id_75 = '2D or 2.5D'  AND wd.field_id_22 = 'Level-and-click'  AND wd.field_id_19 = 'Quest'  ORDER BY ranking DESC LIMIT 16