Helmi 10

Array
(
    [0] => 36
    [1] => 13
    [2] => 14
    [3] => 34
    [4] => 15
    [5] => 19
    [6] => 67
    [7] => 66
)
SELECT `main_table`.* FROM `srp_paintcolour_colour_management` AS `main_table` WHERE (`colour_status` = '1') AND (`category_id` IN('36', '13', '14', '34', '15', '19', '67', '66')) GROUP BY `colour_code` ORDER BY find_in_set(category_id,'36,13,14,34,15,19,67,66') ASC