Search Trades

Find a Scaffolder in Derby, Derbyshire

Post your job and get free quotes from tradespeople near you! Post your job
SELECT a.memberID, a.memberName, a.memberURL2, a.memberImage, a.memberDescr, a.townID, b.countyID, COALESCE(c.isPaid, 0) AS isPaid, c.listingType, a.isVerified AS premierMember, b.place_name, b.county, a.liabilityFile, a.liabilityExpiry, a.idFile, a.addressMatched, d.secondStageInterview FROM ( SELECT memberID, memberName, memberURL2, memberImage, memberDescr, townID, isVerified, liabilityFile, liabilityExpiry, idFile, addressMatched FROM members WHERE isActive=1 AND memberID IN (SELECT memberID FROM listings WHERE expiryDate>NOW() AND listingID IN (SELECT listingID FROM listingcats WHERE categoryID=58)) AND memberID IN (SELECT memberID FROM listings WHERE listingID IN (SELECT listingID FROM (SELECT *, MIN(( 3959 * acos( cos( radians(52.91576) ) * cos( radians( listinglocations.latitude ) ) * cos( radians( listinglocations.longitude ) - radians(-1.47351) ) + sin( radians(52.91576) ) * sin( radians( listinglocations.latitude ) ) ) )) AS distance FROM listinglocations GROUP BY listlocID HAVING (distance <= 30 OR listinglocations.countyID=46) ORDER BY distance) z)) ) a INNER JOIN areas b ON LEFT JOIN ( SELECT memberID, 1 AS isPaid, MAX(listingType) AS listingType, MAX(expiryDate) AS expiryDate FROM listings WHERE listingType>=0 AND expiryDate>NOW() GROUP BY memberID ) c ON a.memberID=c.memberID LEFT JOIN ( SELECT memberID, 1 AS secondStageInterview FROM listings WHERE listingType>=0 AND upgrdSpokenTo=1 GROUP BY memberID ) d ON a.memberID=d.memberID GROUP BY a.memberID ORDER BY isVerified DESC, listingType DESC
Book a free wren kitchen design
Nottingham, Nottinghamshire.
Jmr roofing are a Nottingham based business offering... read more »
Derby, Derbyshire.
NXT Level Scaffolding offers a variety of scaffolding... read more »
Derby, Derbyshire.
Midlands based scaffold company. Offering a quality,... read more »
Tamworth, Staffordshire.
welcome to Goldline scaffolding .over 20 years experience... read more »
Glossop, Derbyshire.
Established over 20 years ago, Numark Scaffolding is a... read more »
Nottingham, Nottinghamshire.
Welcome to Samson Scaffolding & Building Ltd. We are... read more »
Nottingham, Nottinghamshire.
M M scaffolding service‚Äôs Our number is sbove on our... read more »
Leicester, Leicestershire.
Total Scaffold Services are a Leicester based business... read more »
Derby, Derbyshire.
Here at scaffolding midland services we preform high... read more »
Cossington, Leicestershire.
Aspire Scaffolding are a Cossington based business offering... read more »
Trentham, Staffordshire.
Mr Scaffold are a Trentham based business offering... read more »
Shenstone, Staffordshire.
MAP SCAFFOLDING LTD. Access solutions. Domestic, private,... read more »
Norwich, Norfolk.
Scaffolding and H&R Safety nets Rigging industrial... read more »
Nottingham, Nottinghamshire.
Apm scaffolding is a family run business with over 40... read more »
Leicester Forest East, Leicestershire.
A fresh rebranded scaffolding service with backing with... read more »
© Copyright. 2023. All Rights Reserved.