select `vendor` as fld from Message2001 as a where Catalogue_ID = '576' AND Checked = 1 AND Subdivision_ID IN (144073,195467,147771,147770,147742,198721,208313,148133,144109,195600,195597,144110,266690,167902,144112,208302,147743,147744,177219,147745,147746,173693,147749,149397,150049,147747,147748,149360,150935,147751,147766,149362,147767,173692,266178,173695,173696,147750,147752,147753,149361,149748,173697,150050,269053,269309,147754,173698,147755,173384,147756,147757,173699,147758,235964,147759,208303,173700,173703,147760,147761,276443,208305,173701,208306,173702,147762,147763,208307,147764,147765,173694,208304,147768,147769,234621,208318,208319,208320,208310,195452,147773,147774,147772,147790,147789,208311,147779,173704,147775,147776,176350,173705,208309,147778,147777,213784,147780,147781,213785,147782,147783,266689,149363,213786,147786,147787,147785,147784,147788,208308,147791,208827,147793,214913,147795,147794,208312,147796,147792,147797,206759,144069,208316,208317,208315) ORDER by `vendor`filters