Relationships in Query Module

{exp:query sql="
SELECT DISTINCT exp_channel_data.field_id_97 AS title, exp_channel_data.field_id_98 AS id, exp_channel_data.field_id_399 AS ratio, exp_channel_data.field_id_160 AS fullscreen_mode,
  REPLACE (exp_channel_data.field_id_454, '\\\\{filedir_29\\\\}', '') AS image
  FROM exp_channel_titles
  JOIN exp_channel_data ON exp_channel_data.entry_id = exp_channel_titles.entry_id
  JOIN exp_category_posts ON exp_category_posts.entry_id = exp_channel_titles.entry_id
  JOIN exp_relationships ON exp_relationships.child_id= exp_channel_titles.entry_id 
  WHERE exp_channel_titles.channel_id='34' AND exp_relationships.field_id = 455 AND(expiration_date = '0' OR expiration_date > UNIX_TIMESTAMP(NOW())) AND exp_category_posts.cat_id = '{embed:cat}' AND status = 'open'
  ORDER BY exp_channel_titles.entry_date
"}

  <a href="#" class="class2">/images/uploads/example/{image}<div class="winner"><span class="title">{title}</span><span class="js3"></span></div></a>
  
</div>

{/exp:query}