Page Loader gif

Spend $100 or More & Get 60% off - Use Code BULK60
OR Spend $500 or More & Get 65% off - Use Code BULK65
Spend $1000 or More & Get 70% off - Use Code BULK70

All Sales Final & No Returns. Excludes gift vouchers

Products matching "Color" & "Clear           " Tag

View by
Stone Type
View by
Shape
View All
Products
View All
Color Tags
1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

select distinct p.products_id from products p, products_specific_property psp where psp.products_id = p.products_id and lower(psp.property_name) = 'color' and psp.property_value = 'Clear           ' and p.products_status = 1 and (p.products_model like '%' or p.products_model like 'D%')

[TEP STOP]