SELECT
scms_catalog.*,
scms_pictures.picture_file,
scms_pictures.comment,
scms_spr_category.psevd as spr_category,
scms_spr_subcategory.psevd as subcategory,
scms_spr_subcategory.title as title_spr_subcategory
FROM
scms_catalog
LEFT JOIN
scms_pictures ON (scms_pictures.item_id = scms_catalog.id AND temp=0 AND m=1 AND chapter='catalog')
LEFT JOIN
scms_spr_category ON (scms_spr_category.id = scms_catalog.category_spr)
LEFT JOIN
scms_spr_subcategory ON (scms_spr_subcategory.id = scms_catalog.subcategory_spr)
WHERE scms_catalog.psevd='led-kartina-73x33sm-nochnye-ogni-goroda' and scms_catalog.active