SELECT * FROM product_range WHERE product_range_name LIKE 'clearance items (complete list)' AND product_range_website = 1

Clearance Items (complete List)