• Log In | Sign Up

  • News
  • Reviews
  • Games Database
  • Game Discovery
  • Search
  • New Releases
  • Forums
continue reading below

The Medium - Screenshot Gallery

Screenshots (21) for the Adventure Game The Medium


'The Medium - Screenshot #1
'The Medium - Screenshot #2
'The Medium - Screenshot #3
'The Medium - Screenshot #4
'The Medium - Screenshot #5
'The Medium - Screenshot #6
'The Medium - Screenshot #7
'The Medium - Screenshot #8
'The Medium - Screenshot #9
'The Medium - Screenshot #10
'The Medium - Screenshot #11
'The Medium - Screenshot #12
'The Medium - Screenshot #13
'The Medium - Screenshot #14
'The Medium - Screenshot #15
Advertising
'The Medium - Screenshot #16
'The Medium - Screenshot #17
'The Medium - Screenshot #18
'The Medium - Screenshot #19
'The Medium - Screenshot #20
'The Medium - Screenshot #21
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 = 'Illustrated realism'  AND wd.field_id_76 = 'Horror'  AND wd.field_id_75 = 'Realtime 3D'  AND wd.field_id_19 = ''  ORDER BY rating DESC LIMIT 16
Back to the top