Ref # DZ12654
Need to Hire Attachments? in Sydney
Find reputable suppliers near you
For assistance call 1300 156 789 | Click here for detailed quote request
SELECT cl.id,cl.user_id, cl.suspended_id, cl.deleted,cl.loc_suburbtown,cl.loc_state, cl.title, cl.title_url, cl.featured,cl.description, cl.safetyfeatures, cl.units, cl.images, cl.actual_machine, cl.noimagefolder, cl.noimagesaved, cl.show_machine, cl.image_order, cl.images, cl.phone1, cl.phone2, cl.email,cl.attachments, cl.contractor, cl.url,pd.suburb,pd.state, pd.id as postcodeid, ll.id as listinglocid, (
6371 *
acos(
cos(radians(151.268071)) *
cos(radians(pd.lon)) *
cos(radians(-33.794883) - radians(pd.lat)) +
sin(radians(151.268071)) *
sin(radians(pd.lon))
)) as distanceSort , CONVERT( 6371 *
acos(
cos(radians(151.268071)) *
cos(radians(pd.lon)) *
cos(radians(-33.794883) - radians(pd.lat)) +
sin(radians(151.268071)) *
sin(radians(pd.lon))
) , UNSIGNED INTEGER) as distInt FROM directory_listing cl JOIN framework_user fu ON cl.user_id = fu.id AND fu.deleteduser = 0 JOIN listings_locations ll ON cl.id = ll.listing_id JOIN postcode_db pd ON ll.location_id = pd.id JOIN directory_listing_category clc ON clc.category_id IN (35) AND clc.listing_id = cl.id WHERE cl.wantedadd is null AND cl.contractor = 0 AND (cl.approved = 1 AND cl.deleted = 0) ORDER BY (case when cl.featured > 0 AND cl.deleted = 0 and DistanceSort < 100
then distInt else 100
end),
distInt, fu.suspended, fu.paid DESC LIMIT 0, 20
{ ?>
Ref # DZ12648
Ref # DZ12705
Ref # DZ12702
Ref # DZ12699
Ref # DZ12697
Ref # DZ12684
Ref # DZ12682
Ref # DZ12679
Ref # DZ12662
Ref # DZ12647
Ref # DZ12646
Ref # DZ11553
Ref # DZ11551
Ref # DZ11528
Ref # DZ11515
Ref # DZ18374
Ref # DZ18375
Ref # DZ18397
Ref # DZ18396
