SELECT
td_img.td_brand_id,
td_img.file_name
FROM
td_brands
JOIN
td_img ON td_img.td_brand_id = td_brands.td_brand_id AND td_img.kod = ""
WHERE
td_brands.ao_brand_id =
ORDER BY
td_img.number
SELECT
ART_MEDIA_INFO.ART_MEDIA_ART_ID AS article,
ART_MEDIA_INFO.ART_MEDIA_TYPE AS type,
( CASE
WHEN ART_MEDIA_INFO.ART_MEDIA_TYPE = "URL"
THEN ART_MEDIA_INFO.ART_MEDIA_HIPPERLINK
WHEN ART_MEDIA_INFO.ART_MEDIA_TYPE = "PDF"
THEN CONCAT_WS( "/", "PDF", ART_MEDIA_INFO.ART_MEDIA_SUP_ID, ART_MEDIA_INFO.ART_MEDIA_FILE_NAME )
ELSE
CONCAT_WS( "/", "IMAGES", ART_MEDIA_INFO.ART_MEDIA_SUP_ID, ART_MEDIA_INFO.ART_MEDIA_FILE_NAME )
END) AS file,
get_text( ART_MEDIA_INFO.ART_MEDIA_NORM_DES_ID, 48 ) as description
-- CONCAT_WS( "/", "IMAGES", ART_MEDIA_INFO.ART_MEDIA_SUP_ID, ART_MEDIA_INFO.ART_MEDIA_FILE_NAME ) AS file
FROM
ART_MEDIA_INFO
WHERE
ART_MEDIA_INFO.ART_MEDIA_ART_ID = ( SELECT ART_ID FROM ARTICLES WHERE ART_ARTICLE_SEARCH = "" AND ART_SUP_BRAND = "" )
-- AND ART_MEDIA_INFO.ART_MEDIA_TYPE IN ( "PNG", "JPG", "JPEG", "BMP" )
-- AND ART_MEDIA_SORT = 1