Faded Stories: Greenberg – trailer

Find wt.entry_id as entry_id, we.entry_id as overview_id, wt.title, we.discipline_id_46 as ranking, wd.field_id_71 as series FROM exp_channel_titles AS wt, exp_channel_information AS wd Left Join exp_playa_associations as rl ON (rl.baby_entry_id = wd.entry_id AND rl.mum or dad_industry_id = 31) Remaining sign up for exp_channel_info as we ON we.entry_id = rl.mother or father_entry_id In which wt.entry_id NOT IN (Pick entry_id FROM exp_category_posts Where cat_id = 10) AND wd.channel_id = '2' AND wt.status = 'open' AND wt.entry_id = wd.entry_id AND wd.field_id_19 NOT LIKE '%Concealed Object' AND wd.field_id_85 != '0'  AND wd.discipline_id_17 = '
1st-Man or woman
'  AND wd.subject_id_23 = '
Stylized art
'  AND wd.area_id_76 = '
Secret
'  AND wd.industry_id_75 = '
2D or 2.5D
'  AND wd.industry_id_22 = '
Place-and-click
'  AND wd.subject_id_19 = ''  Purchase BY ranking DESC Limit 16