{exp:channel:entries channel="slider" category="{embed:cat}" show_expired="no" dynamic="no" sort="desc" disable="categories|member_data|pagination"}

{exp:query sql="
 SELECT DISTINCT exp_channel_titles.url_title, exp_channel_titles.title AS game_title, exp_channel_data.field_id_335 AS slider_title_text, exp_channel_data.field_id_337 AS slider_text_content_desktop, exp_channel_data.field_id_339 AS slider_title_text_position, exp_categories.cat_id,
 REPLACE (exp_channel_data.field_id_340, '{filedir_21}', '') AS slider_image_desktop
 FROM exp_channel_titles
 JOIN exp_channel_data ON exp_channel_data.entry_id = exp_channel_titles.entry_id
 JOIN exp_categories ON exp_channel_data.site_id = exp_categories.site_id
 JOIN exp_category_posts ON exp_categories.cat_id = exp_category_posts.cat_id AND exp_categories.cat_id IN (94)
 WHERE exp_channel_titles.channel_id='28' AND (expiration_date = '0' OR expiration_date > UNIX_TIMESTAMP(NOW())) AND status = 'open'
 ORDER BY exp_channel_data.entry_id ASC
 "}

{exp:channel:entries channel="slider" category="{embed:cat}" show_expired="no" transcribe="disable" dynamic="no" sort="desc" disable="member_data|pagination"}

LEFT JOIN exp_transcribe_variables_languages ON exp_transcribe_variables_languages .language_id = exp_transcribe_languages.id AND exp_transcribe_variables_languages.site_id = 1
  LEFT JOIN exp_transcribe_entries_languages ON exp_transcribe_entries_languages.language_id = exp_transcribe_languages.id
  LEFT JOIN exp_channel_titles ON exp_channel_titles.entry_id = exp_transcribe_entries_languages .entry_id AND exp_channel_titles.site_id = 1