select cttl.id, cttl.taxon, cttl.organism_key, cttl.taxon_meaning_id
from cache_taxa_taxon_lists cttl
where 
taxon_list_id = 15 AND
preferred=true AND
organism_key in
(
'NBNORG0000008568',
'NBNORG0000008059',
'NBNORG0000007886',
'NBNORG0000007394',
'NBNORG0000008427',
'NBNORG0000007889',
'NBNORG0000007115',
'NBNORG0000007180',
'NBNORG0000053047',
'NBNORG0000007408',
'NBNORG0000053053',
'NBNORG0000007390',
'NBNORG0000008215',
'NBNORG0000008214',
'NBNORG0000007431',
'NBNORG0000008065',
'NBNORG0000053122',
'NBNORG0000008565',
'NBNORG0000007413',
'NBNORG0000008018',
'NBNORG0000007805',
'NBNORG0000008037',
'NBNORG0000008040',
'NBNORG0000007558',
'NBNORG0000053162',
'NBNORG0000053166',
'NBNORG0000053186',
'NBNORG0000007254',
'NBNORG0000007088',
'NBNORG0000007087',
'NBNORG0000008547',
'NBNORG0000053255',
'NBNORG0000007708',
'NBNORG0000007108',
'NBNORG0000008562',
'NBNORG0000053339',
'NBNORG0000007698',
'NBNORG0000116335',
'NBNORG0000008496',
'NBNORG0000053355',
'NBNORG0000007079',
'NBNORG0000006865',
'NBNORG0000007361',
'NBNORG0000053411',
'NBNORG0000008692',
'NBNORG0000053434',
'NBNORG0000007121',
'NBNORG0000008185',
'NBNORG0000007424',
'NBNORG0000047367',
'NBNORG0000008441',
'NBNORG0000008437',
'NBNORG0000008442',
'NBNORG0000008438',
'NBNORG0000053464',
'NBNORG0000007547',
'NBNORG0000008592',
'NBNORG0000052188',
'NBNORG0000053481',
'NBNORG0000007323',
'NBNORG0000053492',
'NBNORG0000007297',
'NBNORG0000007313',
'NBNORG0000007318',
'NBNORG0000007295',
'NBNORG0000007316',
'NBNORG0000053501',
'NBNORG0000007329',
'NBNORG0000007324',
'NBNORG0000007288',
'NBNORG0000053506',
'NBNORG0000008587',
'NBNORG0000053516',
'NBNORG0000008605',
'NBNORG0000008489',
'NBNORG0000007642',
'NBNORG0000007646',
'NBNORG0000007647',
'NBNORG0000053590',
'NBNORG0000107933',
'NBNORG0000008289',
'NBNORG0000008016',
'NBNORG0000053643',
'NBNORG0000007959',
'NBNORG0000007991',
'NBNORG0000008599',
'NBNORG0000008597',
'NBNORG0000008601',
'NBNORG0000008600',
'NBNORG0000008596',
'NBNORG0000008595',
'NBNORG0000007434',
'NBNORG0000008387',
'NBNORG0000053719',
'NBNORG0000053995',
'NBNORG0000007170',
'NBNORG0000116336',
'NBNORG0000008050',
'NBNORG0000008004',
'NBNORG0000008144',
'NBNORG0000007511',
'NBNORG0000008678',
'NBNORG0000007919',
'NBNORG0000008651',
'NBNORG0000008054',
'NBNORG0000008457',
'NBNORG0000053904',
'NBNORG0000008263',
'NBNORG0000008234',
'NBNORG0000007359',
'NBNORG0000007093',
'NBNORG0000007772',
'NBNORG0000053979',
'NBNORG0000053987',
'NBNORG0000053991',
'NBNORG0000007973',
'NBNORG0000013309',
'NBNORG0000054034',
'NBNORG0000007387',
'NBNORG0000008307',
'NBNORG0000007060',
'NBNORG0000107960',
'NBNORG0000026830',
'NBNORG0000007968',
'NBNORG0000007967',
'NBNORG0000054150',
'NBNORG0000116337',
'NBNORG0000054178',
'NBNORG0000008665',
'NBNORG0000007976',
'NBNORG0000007070',
'NBNORG0000007066',
'NBNORG0000007067',
'NBNORG0000008189',
'NBNORG0000008186',
'NBNORG0000007263',
'NBNORG0000007265',
'NBNORG0000007759',
'NBNORG0000008096',
'NBNORG0000008091',
'NBNORG0000008089',
'NBNORG0000054402',
'NBNORG0000007855',
'NBNORG0000007854',
'NBNORG0000007881',
'NBNORG0000054424',
'NBNORG0000008468',
'NBNORG0000008459',
'NBNORG0000008460',
'NBNORG0000008458',
'NBNORG0000008464',
'NBNORG0000008462',
'NBNORG0000008463',
'NBNORG0000008461',
'NBNORG0000007767',
'NBNORG0000007766',
'NBNORG0000054483',
'NBNORG0000007740',
'NBNORG0000007732',
'NBNORG0000007728',
'NBNORG0000007882',
'NBNORG0000007484',
'NBNORG0000105205',
'NBNORG0000091596',
'NBNORG0000008418',
'NBNORG0000054519',
'NBNORG0000054541',
'NBNORG0000007102',
'NBNORG0000008008',
'NBNORG0000054578',
'NBNORG0000007384',
'NBNORG0000008071',
'NBNORG0000008070',
'NBNORG0000007824',
'NBNORG0000007996',
'NBNORG0000007385',
'NBNORG0000007665',
'NBNORG0000054842',
'NBNORG0000008205',
'NBNORG0000054854',
'NBNORG0000007168',
'NBNORG0000007122',
'NBNORG0000008011',
'NBNORG0000007607',
'NBNORG0000054897',
'NBNORG0000008619',
'NBNORG0000007758',
'NBNORG0000007754',
'NBNORG0000008529',
'NBNORG0000007225',
'NBNORG0000008451',
'NBNORG0000007186',
'NBNORG0000116338',
'NBNORG0000007183',
'NBNORG0000008676',
'NBNORG0000008292',
'NBNORG0000008291',
'NBNORG0000054976',
'NBNORG0000008631',
'NBNORG0000055006',
'NBNORG0000008406',
'NBNORG0000055041',
'NBNORG0000007844',
'NBNORG0000007257',
'NBNORG0000007255',
'NBNORG0000008577',
'NBNORG0000008064',
'NBNORG0000055121',
'NBNORG0000007725',
'NBNORG0000055166',
'NBNORG0000008436',
'NBNORG0000008453',
'NBNORG0000008480',
'NBNORG0000007807',
'NBNORG0000007808',
'NBNORG0000007210',
'NBNORG0000055207',
'NBNORG0000007059',
'NBNORG0000008379',
'NBNORG0000055222',
'NBNORG0000008207',
'NBNORG0000008209',
'NBNORG0000007970',
'NBNORG0000008575',
'NBNORG0000007779',
'NBNORG0000008336',
'NBNORG0000007364',
'NBNORG0000008376',
'NBNORG0000008231',
'NBNORG0000008079',
'NBNORG0000007412',
'NBNORG0000007661',
'NBNORG0000007666',
'NBNORG0000007331',
'NBNORG0000007675',
'NBNORG0000008635',
'NBNORG0000008009',
'NBNORG0000055377',
'NBNORG0000007420',
'NBNORG0000055395',
'NBNORG0000055167',
'NBNORG0000055473',
'NBNORG0000007473',
'NBNORG0000008353',
'NBNORG0000007111',
'NBNORG0000007250',
'NBNORG0000055594',
'NBNORG0000008380',
'NBNORG0000007821',
'NBNORG0000007072',
'NBNORG0000007741',
'NBNORG0000008107',
'NBNORG0000008069',
'NBNORG0000008331',
'NBNORG0000008332',
'NBNORG0000055702',
'NBNORG0000008100',
'NBNORG0000055708',
'NBNORG0000055716',
'NBNORG0000055721',
'NBNORG0000007415',
'NBNORG0000007080',
'NBNORG0000008625',
'NBNORG0000055584',
'NBNORG0000055751',
'NBNORG0000008366',
'NBNORG0000008368',
'NBNORG0000008434',
'NBNORG0000008432',
'NBNORG0000008433',
'NBNORG0000008431',
'NBNORG0000007241',
'NBNORG0000116339',
'NBNORG0000007142',
'NBNORG0000007134',
'NBNORG0000055851',
'NBNORG0000007871',
'NBNORG0000007877',
'NBNORG0000007868',
'NBNORG0000007878',
'NBNORG0000007869',
'NBNORG0000008763',
'NBNORG0000008203',
'NBNORG0000055871',
'NBNORG0000008395',
'NBNORG0000007909',
'NBNORG0000007075',
'NBNORG0000055908',
'NBNORG0000007438',
'NBNORG0000007440',
'NBNORG0000007439',
'NBNORG0000007449',
'NBNORG0000107166',
'NBNORG0000007583',
'NBNORG0000007582',
'NBNORG0000007761',
'NBNORG0000008333',
'NBNORG0000008176',
'NBNORG0000007278',
'NBNORG0000007561',
'NBNORG0000007563',
'NBNORG0000056025',
'NBNORG0000007856',
'NBNORG0000007865',
'NBNORG0000007857',
'NBNORG0000008109',
'NBNORG0000008108',
'NBNORG0000008118',
'NBNORG0000116340',
'NBNORG0000056292',
'NBNORG0000007158',
'NBNORG0000008684',
'NBNORG0000007660',
'NBNORG0000007118',
'NBNORG0000008166',
'NBNORG0000008393',
'NBNORG0000007900',
'NBNORG0000008012',
'NBNORG0000007957',
'NBNORG0000007951',
'NBNORG0000007956',
'NBNORG0000007958',
'NBNORG0000007944',
'NBNORG0000007950',
'NBNORG0000008491',
'NBNORG0000007272',
'NBNORG0000007276',
'NBNORG0000007269',
'NBNORG0000008420',
'NBNORG0000056411',
'NBNORG0000007936',
'NBNORG0000056416',
'NBNORG0000007931',
'NBNORG0000008504',
'NBNORG0000008505',
'NBNORG0000008503',
'NBNORG0000008616',
'NBNORG0000008454',
'NBNORG0000008061',
'NBNORG0000007628',
'NBNORG0000007631',
'NBNORG0000056485',
'NBNORG0000007617',
'NBNORG0000008268',
'NBNORG0000008543',
'NBNORG0000008637',
'NBNORG0000008639',
'NBNORG0000008638',
'NBNORG0000007923',
'NBNORG0000007258',
'NBNORG0000056575',
'NBNORG0000007673',
'NBNORG0000056582',
'NBNORG0000056584',
'NBNORG0000056606',
'NBNORG0000056615',
'NBNORG0000008402',
'NBNORG0000007657',
'NBNORG0000007656',
'NBNORG0000056621',
'NBNORG0000007710',
'NBNORG0000008493',
'NBNORG0000056650',
'NBNORG0000008238',
'NBNORG0000105189',
'NBNORG0000008426',
'NBNORG0000007466',
'NBNORG0000007468',
'NBNORG0000116341',
'NBNORG0000008023',
'NBNORG0000056901',
'NBNORG0000008213',
'NBNORG0000056909',
'NBNORG0000007802',
'NBNORG0000007799',
'NBNORG0000007784',
'NBNORG0000007798',
'NBNORG0000007790',
'NBNORG0000007127',
'NBNORG0000007126',
'NBNORG0000056939',
'NBNORG0000007425',
'NBNORG0000007261',
'NBNORG0000007770',
'NBNORG0000116342',
'NBNORG0000008131',
'NBNORG0000008194',
'NBNORG0000008196',
'NBNORG0000008193',
'NBNORG0000008488',
'NBNORG0000008486',
'NBNORG0000008483',
'NBNORG0000008323',
'NBNORG0000008309',
'NBNORG0000008314',
'NBNORG0000008313',
'NBNORG0000007828',
'NBNORG0000007826',
'NBNORG0000007593',
'NBNORG0000007587',
'NBNORG0000057068',
'NBNORG0000007590',
'NBNORG0000091471'
);