SELECT r.vTitle,r.tDescription, r.sDescription, r.iRangeId, r.vImage FROM `brand_range_map` brm LEFT JOIN `range` r ON brm.iRangeId = r.iRangeId WHERE brm.iBrandId = '189' AND r.eStatus = 'Active' AND r.iRangeId NOT IN (1039,1743,242) ORDER BY r.iDispOrder ASC Authentic Models

Authentic Models

3 great reasons to buy Authentic Models from us - UK’s Best Brands, Lowest Prices and 24 X 7 Support!

Authentic Models

Read moreClose
Top