Temafloor P300

Array
(
    [0] => 19
    [1] => 14
    [2] => 20
    [3] => 26
    [4] => 27
    [5] => 28
    [6] => 29
)
SELECT `main_table`.* FROM `srp_paintcolour_colour_management` AS `main_table` WHERE (`colour_status` = '1') AND (`category_id` IN('19', '14', '20', '26', '27', '28', '29')) GROUP BY `colour_code` ORDER BY find_in_set(category_id,'19,14,20,26,27,28,29') ASC