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
1267 - Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'find_in_set'
SELECT sp.*, s.stone_name, s.stone_image FROM `stone_properties` sp join stone_names s on sp.stone_name_id=s.stone_name_id WHERE property_id=8 and find_in_set('black ', lower(replace(replace(property_value, ', ' , ','), ' ', '-')))