hex: 2d4be1 red: 212 green: 190 blue: 1

SELECT * FROM artitems art JOIN color_match color on art.id = color.art_id WHERE ( (art.status = 'a') OR (art.status = 0)) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND (color.r_val > 162 AND color.r_val < 262 AND color.g_val > 140 AND color.g_val < 240 AND color.b_val > -49 AND color.b_val < 51 ) AND (art.publish = 1 AND art.hidden = 0) AND (status = 0 OR (status > 4 AND status < 10)) ORDER BY(CASE WHEN STATUS='0' THEN 0 WHEN STATUS='a' THEN 0 WHEN STATUS='5' THEN 2 WHEN STATUS='a5' THEN 2 WHEN STATUS='10' THEN 3 WHEN STATUS='aa' THEN 3 WHEN STATUS='9' THEN 1 WHEN STATUS='a9' THEN 1 ELSE 3 END), `status` ASC, art.when_published_timestamp DESC Search Color: 2d4be1

SELECT * FROM artitems art JOIN color_match color on art.id = color.art_id WHERE ( (art.status = 'a') OR (art.status = 0)) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND ( 1 ) AND (color.r_val > 162 AND color.r_val < 262 AND color.g_val > 140 AND color.g_val < 240 AND color.b_val > -49 AND color.b_val < 51 ) AND (art.publish = 1 AND art.hidden = 0) AND (status = 0 OR (status > 4 AND status < 10)) ORDER BY(CASE WHEN STATUS='0' THEN 0 WHEN STATUS='a' THEN 0 WHEN STATUS='5' THEN 2 WHEN STATUS='a5' THEN 2 WHEN STATUS='10' THEN 3 WHEN STATUS='aa' THEN 3 WHEN STATUS='9' THEN 1 WHEN STATUS='a9' THEN 1 ELSE 3 END), `status` ASC, art.when_published_timestamp DESC