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" & "Yellow " 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 psp.products_id from products p, products_specific_property psp, products_to_stones pts where psp.products_id = p.products_id and pts.products_id = p.products_id and p.products_status = 1 and (p.products_model like '%' or p.products_model like 'D%') and lower(property_name) = 'color' and property_value = 'Yellow ' and stone_name_id = '287'

[TEP STOP]