SELECT DISTINCT(B.ID) as ID_BLOKE, B.ORDEN FROM TAGS_BLOQUES B, TAGS T, TAGS_PRODUCTO TP WHERE TP.ID_REF in ('1002654','1002656','1002655','1002657','1002774','1001543','1000892','1001407','1001081','1000476','1001082','1001199','1001102','1001534','1000852','1002338','1002343','1001517','1001522','1002049') AND TP.ID_TAG = T.ID AND T.ID_BLOQUE = B.ID ORDER BY B.ORDEN
Area
Amplification systems
Connection
Audio source
No products found with the selected filters. Please browse or select different values.
