Microphones

SELECT DISTINCT(B.ID) as ID_BLOKE, B.ORDEN FROM TAGS_BLOQUES B, TAGS T, TAGS_PRODUCTO TP WHERE TP.ID_REF in ('299','300','301','302','303','304','305','306','307','308','310','311','312','313','315','316','317','1001652','1001064','320','323','1000580','1000657','3354','778','779','801','1002096','1000632','807','808','809','813','1001569','819','3583','1002093','834','1001980','905','1001591','1002125','959','960','1021','1002094','1001496','1001645','1105','1284','1285','1286','1001681','1000219','1001606','1000218','1000969','1001401','1292','1001581','1295','1001646','1002110','1298','1002910','1299','1300','1001677','1301','1001595','1001678','3480','1001597','1001247','1001978','1001679','1001835','1002126','1305','1001680','1002135','1001990','1313','1315','1001857','1001640','1001865','1319','1320','1322','1001648','1001525','1001620','1002912','1002950','1000576','1001075','1001856','1002079','1002085','1336','1001682','1337','1338','1339','1001683','1340','1341','1342','1001379','1343','1344','1345','1001671','1346','1347','1348','1001675','1349','1350','1351','1001684','1352','1353','1354','1001674','1000575','1000577','1000578','1001670','1356','1357','1001672','1001540','1001686','1000573','1000709','1000710','1001510','1386','1001091','1001092','1001157','1395','1403','1404','1001676','1001086','1001188','1001087','1001618','1002098','1000395','1002127','1001976','1409','1001260','1001149','1413','1001975','1001596','1001586','1710','1711','1712','1727','1728','1729','1000610','1000611','1842','1844','1845','1846','1001200','1002310','1001409','1000587','1000588','1001666','1001774','1001626','1001627','1001310','1001665','3501','1001837','3387','1001796','1001795','1001706','1002218','1002219','1001707','1001962','1001709','1002221','1002220','1001708','1001963','1001719','1002223','1002222','1001718','1001964','1001711','1002225','1002224','1001710','1001965','1001713','1002227','1002226','1001712','1001966','1002239','1002238','1001714','1001971','1001717','1002241','1002240','1001716','1001972','1001721','1002229','1002228','1001720','1001967','1002235','1002234','1001750','1001970','1001974','1001725','1002231','1002230','1001724','1001968','1002119','1002120','1002097','1895','1896','1897','1002149','2024','2025','2026','2027','1001495','2029','1000894','1002314','2105','1000544','2110','2111','2112','2113','1001234','1001600','1001989','2117','1002001','1001619','2121','2122','2125','2127','2132','2133','2144','2146','2147','2148','2149','2150','1001233','2154','2155','1001245','2158','1000440','1001213','1001212','1001215','1001647','1002355','1001859','1001255','1000392','1000442','1002366','3142','3144','3146','3147','3148','1000840','3150','3152','3155','3156','3157','3158','3159','1001863','1001584','1001585','1001588','1001589','3165','3166','3167','3168','1001812','3170','3171','3172','3173','3174','3175') AND TP.ID_TAG = T.ID AND T.ID_BLOQUE = B.ID ORDER BY B.ORDEN