select m.manufacturers_id, m.manufacturers_name, m.address_key, mi.manufacturers_meta_title, mi.manufacturers_meta_descp, mp.manufacturersportion_image from manufacturers m left join manufacturers_portion mp on m.manufacturers_id = mp.manufacturers_id and mp.manufacturersportion_position = 'Left Menu', manufacturers_info mi where m.manufacturers_id = mi.manufacturers_id and m.manufacturers_id = '648'
Dermal Therapy is an Australian skincare brand with an extensive range of affordable and effective products, delivering proven results against all skin concerns from dryness and sensitivity to itchy scalp. The range is recommended by dermatologists n...ationally and is made with the highest quality ingredients.
