Headphones

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','1000583','1000584','1144','1146','1152','1154','1001238','1002043','1001135','1001491','1196','1002130','1000750','1000751','1001770','1001147','1001146','1001145','1000713','1001744','1001973','1001553','1001548','1001209','1001536','1001467','1465','1001791','2431','2432','1002336','1002320','1002337','2642','2643','2644','2645','1001987','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