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

Aa - Clearance Items (complete List)