Valtti Opaque

Array
(
    [0] => 43
    [1] => 36
    [2] => 13
    [3] => 14
    [4] => 15
    [5] => 19
    [6] => 20
    [7] => 26
    [8] => 27
    [9] => 28
    [10] => 29
    [11] => 34
    [12] => 6
    [13] => 8
    [14] => 37
    [15] => 35
    [16] => 10
    [17] => 11
    [18] => 67
)
SELECT `main_table`.* FROM `srp_paintcolour_colour_management` AS `main_table` WHERE (`colour_status` = '1') AND (`category_id` IN('43', '36', '13', '14', '15', '19', '20', '26', '27', '28', '29', '34', '6', '8', '37', '35', '10', '11', '67')) GROUP BY `colour_code` ORDER BY find_in_set(category_id,'43,36,13,14,15,19,20,26,27,28,29,34,6,8,37,35,10,11,67') ASC