Australian Bridal Industry Academy
SELECT B.id, B.temp_member as memnon, B.email as mememail, B.id as businessid, C.id as category_business_id , C.category_id as category_id , B.address as address , B.suburb as suburb, B.state as state, B.postcode as postcode from business B LEFT JOIN abia_vendor D ON B.id = D.business_id LEFT JOIN category_business C ON B.id = C.business_id WHERE C.active='1' AND B.active='1' AND ( D.bride_state LIKE '%wa%' ) AND ( D.wedding_state LIKE '%Albany%' ) AND B.temp_member='1' ORDER BY B.temp_member DESC

Find Your Wedding Vendors