Ultra Classic

Array
(
    [0] => 37
    [1] => 11
    [2] => 4
    [3] => 5
    [4] => 6
    [5] => 7
    [6] => 8
    [7] => 9
    [8] => 10
    [9] => 12
    [10] => 13
    [11] => 14
    [12] => 15
    [13] => 16
    [14] => 17
    [15] => 18
    [16] => 19
    [17] => 21
    [18] => 27
    [19] => 28
    [20] => 29
    [21] => 30
    [22] => 31
    [23] => 32
    [24] => 33
    [25] => 34
    [26] => 35
    [27] => 36
    [28] => 38
    [29] => 39
    [30] => 40
    [31] => 41
    [32] => 42
    [33] => 43
    [34] => 44
    [35] => 45
    [36] => 46
    [37] => 47
    [38] => 49
    [39] => 50
    [40] => 51
    [41] => 52
    [42] => 54
    [43] => 57
    [44] => 58
    [45] => 59
    [46] => 60
    [47] => 61
    [48] => 62
    [49] => 63
    [50] => 64
    [51] => 65
    [52] => 66
    [53] => 67
    [54] => 68
    [55] => 69
    [56] => 70
    [57] => 71
    [58] => 72
    [59] => 73
    [60] => 75
    [61] => 76
    [62] => 77
)
SELECT `main_table`.* FROM `srp_paintcolour_colour_management` AS `main_table` WHERE (`colour_status` = '1') AND (`category_id` IN('37', '11', '4', '5', '6', '7', '8', '9', '10', '12', '13', '14', '15', '16', '17', '18', '19', '21', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '49', '50', '51', '52', '54', '57', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '70', '71', '72', '73', '75', '76', '77')) GROUP BY `colour_code` ORDER BY find_in_set(category_id,'37,11,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,21,27,28,29,30,31,32,33,34,35,36,38,39,40,41,42,43,44,45,46,47,49,50,51,52,54,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,75,76,77') ASC