You are born into a beautiful, pure land, but everything is not as it seems. Darkness seeps through every crevice and forms the foundation of the world you live in. Open your eyes to the shadows of the world to uncover the hidden truth.
There haven't been any reader that reviewed The Sojourn yet. Please share your (short) verdict, a review or post your star rating!
SELECT wt.entry_id as entry_id, we.entry_id as review_id, wt.title, we.field_id_46 as rating, wd.field_id_71 as series 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 join 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.status = '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 = 'First-Person' AND wd.field_id_23 = 'Stylized art' AND wd.field_id_76 = 'Fantasy' AND wd.field_id_75 = 'Realtime 3D' AND wd.field_id_19 = 'Quest' ORDER BY rating DESC LIMIT 16