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.status='enabled' ORDER BY listing.sequence ASC, listing.name ASC LIMIT 0, 50

No results found...

Go Back

© LEDZ - LED Lights and Lighting Systems - 2014 | led valve lights - 32 patterns | Info & Terms | Contact | Links

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