Goetia 2 – Trailer | Adventure Gamers

Pick out wt.entry_id as entry_id, we.entry_id as evaluate_id, wt.title, we.discipline_id_46 as score, wd.industry_id_71 as collection FROM exp_channel_titles AS wt, exp_channel_data AS wd Remaining Be part of exp_playa_relationships as rl ON (rl.child_entry_id = wd.entry_id AND rl.dad or mum_discipline_id = 31) Remaining be part of exp_channel_info as we ON we.entry_id = rl.dad or mum_entry_id Where wt.entry_id NOT IN (Decide on entry_id FROM exp_group_posts Exactly 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.area_id_85 != '0'  AND wd.discipline_id_17 = 'Third-Person'  AND wd.subject_id_76 = 'Horror'  AND wd.industry_id_75 = '2D or 2.5D'  AND wd.subject_id_22 = 'Point-and-click'  AND wd.subject_id_19 = ''  Order BY score DESC Restrict 16