SELECT DISTINCT(B.ID) as ID_BLOKE, B.ORDEN FROM TAGS_BLOQUES B, TAGS T, TAGS_PRODUCTO TP WHERE TP.ID_REF in ('1002545','1001807','1001165','1001124','1000557','3466','1001695','1001696','1001166','3471','3474','3473','1000609','1001164','797','800','1001501','3306','100012','1002200','1002201','1002199','1002654','1002656','1002655','1002657','1001792','915','1002075','1001494','1045','1001904','1002178','1001168','1001378','1001167','1001374','1001376','1001377','1001375','1000583','1000584','1144','1146','1152','1154','1001238','1002043','1001135','1001491','1196','1002130','1000750','1000751','1001770','1001147','1001146','1001145','1000713','1001744','1001973','1001553','1001919','1001920','1001921','1001918','1001548','1001209','1001536','1001467','1465','1001791','1001886','1486','1489','1002022','1002837','1002836','1002154','1000678','1001489','1001825','1000707','1000708','1002739','1002740','1002328','1002326','3536','1001800','1002177','1001309','1001017','1002266','1741','1001542','1000615','1001704','1000829','1000335','1000562','1000822','3347','1000826','1000346','1748','1000493','1000530','3329','3328','1000711','1000608','1001742','1000369','1000370','1000239','1001634','1001633','1002040','1002202','1002197','1002196','1002727','1002247','1001826','1002690','1002193','1002194','1001934','1001389','1002338','1002343','1000484','1001370','1000621','1001335','1001929','1002131','3537','1001488','2161','2431','2432','1001517','1001522','1002336','1002320','1002337','2642','2643','2644','2645','1001512','3535','1001446','1000747','1000686','1000895','1001688','1002066','1000642','1002451','1001987','1002769','1002770','1002771','1002772','1002773','1002776','1002778','1002777','1002775','1002049','1000665','1002349','1002693','1002811','1001575','1001577','1001788','1001573','1001574','1001576','1002922','1002921','1002923','1002924','1001993','1001994','1002214','1001988','1002926','1001391','1001392','1001393','1001394') AND TP.ID_TAG = T.ID AND T.ID_BLOQUE = B.ID ORDER BY B.ORDEN
