Try using:
Code:
select mi.manufacturers_url from zen_manufacturers m join zen_manufacturers_info mi ON m.manufacturers_id = mi.manufacturers_id where m.manufacturers_name = 'Some Manufacturer';