Australian Health Directory


Find cosmetic medicine and aesthetic therapists - for that magic touch



176 listings - Page 0 of 18
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Next 15 | End

SELECT * FROM (SELECT id, name, logo, comp_id, list_category_id, pname, operating, priority, nation_wide, short_desc, char_length(coalesce(short_desc, '')) as clength FROM cosmetic_enhancement WHERE display = 't' AND list_category_id = 56) as lc LEFT JOIN (SELECT * FROM (SELECT lcc.catable_id as catable_id2, COUNT(*) as num_loc FROM cosmetic_enhancement_location lcc WHERE catable_id IN (SELECT id FROM cosmetic_enhancement WHERE display ='t' AND list_category_id = 56) GROUP BY catable_id) as sl1, (SELECT DISTINCT ON (catable_id) catable_id, address, address2, postcode, state_id, tel, suburb FROM cosmetic_enhancement_location WHERE catable_id IN (SELECT id FROM cosmetic_enhancement WHERE display ='t' AND list_category_id = 56) ORDER BY catable_id, type) as sl2 WHERE sl1.catable_id2 = sl2.catable_id) as sl ON (lc.id = sl.catable_id) ORDER BY priority, lc.id LIMIT 10 OFFSET -10 [nativecode=ERROR: OFFSET must not be negative]