Your Computer Might Be At Risk trailer

Find wt.entry_id as entry_id, we.entry_id as evaluation_id, wt.title, we.industry_id_46 as ranking, wd.discipline_id_71 as series FROM exp_channel_titles AS wt, exp_channel_facts AS wd Still left Join exp_playa_associations as rl ON (rl.kid_entry_id = wd.entry_id AND rl.father or mother_field_id = 31) Left sign up for exp_channel_details as we ON we.entry_id = rl.parent_entry_id The place wt.entry_id NOT IN (Select entry_id FROM exp_group_posts Wherever cat_id = 10) AND wd.channel_id = '2' AND wt.position = 'open' AND wt.entry_id = wd.entry_id AND wd.field_id_19 NOT LIKE '%Concealed Object' AND wd.area_id_85 != '0'  AND wd.area_id_17 = 'First-Person'  AND wd.industry_id_23 = 'Stylized art'  AND wd.discipline_id_76 = 'Mystery'  AND wd.discipline_id_75 = 'Realtime 3D'  AND wd.area_id_22 = 'Point-and-click'  AND wd.field_id_19 = 'Puzzle'  Get BY score DESC Restrict 16