минск тц столица швейная фурнитура

/*background: url("//www.refer.by/images/experiments/wavy-underline.png") repeat-x scroll 0 100% transparent;*/

WHERE firm_type_prod.prod_id = 29104 AND firms.region = 1

FROM firms LEFT JOIN firm_type_prod ON ( firms.id = firm_type_prod.id_firm )