SELECT SQL_CALC_FOUND_ROWS DISTINCT g.* ,news.`news_short_desk`,news.`news_desk`,news.`news_date`,news.`display_in_reviews`,news.`img_letter`,news.`reviews_logo`,news.`reviews_fio`,news.`reviews_position`,news.`reviews_company`,news.`news_nodisplay_reviews` , `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_news_ecommerce_fields` as news ON news.good_id = g.id
WHERE (`status` = 'enable' AND `good_off`=0 AND `id` in (3764) AND g.parent_id IS NULL AND g.main_parent_id IS NULL ) and ( 1=1 ) ORDER BY g.id
Поздравляем с Днем Защитника Отечества! - новости компании в Химках
