филиал белгосстраха по г минску слободская

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

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

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