> >

SELECT listing.*, (SELECT file.name FROM file WHERE file.source='listing' AND file.record_id=listing.id AND file.type='image' AND file.status='enabled' ORDER BY file.sequence ASC LIMIT 1 ) AS image FROM listing WHERE listing.listing_category_id= AND listing.listing_subcategory_id= AND listing.listing_subsubcategory_id= AND listing.status='enabled' ORDER BY listing.sequence ASC, listing.name ASC LIMIT 0, 50

No results found...

Go Back


PS! You only need to Register Once!

Special "Trade Specific" discounts apply to Contractors and Resellers.

Free Deliveries for orders over R1000.00, to Major Cities in South Africa.

We never ask for your Bank Details.

All Prices Exclude VAT.

Prices may change without prior notice.

© LEDZ - LED Lights and Lighting Systems - 2014 | promo 3 led bicycle light head light promotions | Info & Terms | Contact | Links

Website Design, Search Engine Optimisation (SEO) by ZAWebs Designs | Web Hosting by ZAWebs Hosting