SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,portfolio.`oborudovanie`,portfolio.`powers_obj`,portfolio.`work_obj`,portfolio.`client_name`,portfolio.`adress_obj`,portfolio.`short_desc`,portfolio.`foto1`,portfolio.`foto2`,portfolio.`foto3`,portfolio.`realize_project`,portfolio.`otzyv_object`,portfolio.`oborudovanie_short`,portfolio.`power_short`,portfolio.`work_short`,portfolio.`object_categories`,portfolio.`producer`,portfolio.`pictures`,portfolio.`logo_img`,portfolio.`portfolio_producer`,portfolio.`portfolio_power`,portfolio.`akb_flag`,portfolio.`object`,portfolio.`otrasl`,portfolio.`portfolio_date`,portfolio.`foto4`,portfolio.`foto5`,portfolio.`foto6`,portfolio.`foto7` , `tbl_currencies`.price_rub_fields, `tbl_currencies`.price_rub, `tbl_currencies`.price_old_rub
FROM `tbl_ecommerce_goods` g
LEFT JOIN `tbl_currencies` ON (`tbl_currencies`.good_id=g.`id`)
LEFT JOIN `tbl_portfolio_ecommerce_fields` as portfolio ON portfolio.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (12829) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY g.id
Установка ИБП Makelsan Boxer BX3320 для магазина "ДА" в г. Коломна - Портфолио компании "Системотехника" в Солнечногорске