AND c.customerNo IN ('KNR000020', 'KNR000110', 'KNR000220', 'KNR000410', 'KNR000610', 'KNR000810', 'KNR001020',
	                       'KNR001120', 'KNR001210', 'KNR001220', 'KNR001310', 'KNR001420', 'KNR001510', 'KNR001710',
						   'KNR001810', 'KNR002020', 'KNR002120', 'KNR002410', 'KNR002610', 'KNR002710', 'KNR003010',
						   'KNR003020', 'KNR003310', 'KNR003320', 'KNR003520', 'KNR003610', 'KNR003710', 'KNR003910',
						   'KNR004020', 'KNR004210', 'KNR004320')

ORDER BY c.customerNo;