SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, GROUP_CONCAT(FIELD(pa.attribute_id, 14, 12, 13)) as attribute_order, (SELECT text FROM oc_product_attribute pa2 WHERE p2c.product_id = pa2.product_id AND attribute_id = 24) as stock_real FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_attribute pa ON (p.product_id = pa.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '64' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, GROUP_CONCAT(FIELD(pa.attribute_id, 14, 12, 13)) as attribute_order, (SELECT text FROM oc_product_attribute pa2 WHERE p2c.product_id = pa2.product_id AND attribute_id = 24) as stock_real FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_attribute pa ON (p.product_id = pa.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '62' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, GROUP_CONCAT(FIELD(pa.attribute_id, 14, 12, 13)) as attribute_order, (SELECT text FROM oc_product_attribute pa2 WHERE p2c.product_id = pa2.product_id AND attribute_id = 24) as stock_real FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_attribute pa ON (p.product_id = pa.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '61' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, GROUP_CONCAT(FIELD(pa.attribute_id, 14, 12, 13)) as attribute_order, (SELECT text FROM oc_product_attribute pa2 WHERE p2c.product_id = pa2.product_id AND attribute_id = 24) as stock_real FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_attribute pa ON (p.product_id = pa.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '63' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20 BimotorDJ - Material para espectáculos

destaques

Art System led cegadora

Art System led cegadora

Aquarius - 400w warm white Waterproof - like EK

REF: MOFFEYLED400WIP65

Disponibilidade imediata

599.00€840.00€

.

Hercules controlador

Hercules controlador

Dj control Starlight

REF: ISTARLIGHT

Disponibilidade imediata

74.50€99.00€

.

Art System led par 64

Art System led par 64

Par15w18 rgbwa - 18 leds de 15w, preto, short

REF: GC18X15RGBWA

Disponibilidade imediata

159.90€249.00€

.

Art System difusor  led de luz negra

Art System difusor led de luz negra

led uv 3w / 28 leds

REF: LYLEDUV3W28

Disponibilidade imediata

229.00€289.00€

.

White kit de limpeza

White kit de limpeza

Kit limpeza vinil MK1

REF: B0020101652

Disponibilidade imediata

99.90€119.00€

.

pioneer auricular

pioneer auricular

SE-C1T-P - rosa

REF: SEC1TP

disponível em 2-3 dias

13.99€

.

pioneer amplificador

pioneer amplificador

A-10 AE-s - cinza

REF: A10AES

disponível em 2-3 dias

219.00€229.99€

.

ortofon cabeça para gira-discos

ortofon cabeça para gira-discos

CONCORDE MKII SCRATCH - 1 celula c agulha

REF: CMKIISCRATCH

Disponibilidade imediata

105.00€108.35€

.

Hercules controlador

Hercules controlador

Control Inpulse 200

REF: CINPULSE200

Disponibilidade imediata

94.50€109.99€

.

Numark Controlador

Numark Controlador

Mixtrack IIi dj controller

REF: MIXTRACKIII

disponível em 2-3 dias

148.00€269.00€

.

Art System led moving head

Art System led moving head

Wash , 4x10w rgbwa + uv , 6 in 1

REF: GC4X10RGBWAU

Disponibilidade imediata

99.90€139.00€

.

neutrik interface dante

neutrik interface dante

NA2-IO-DLINE

REF: NA2-IO-DLINE

disponível em 2-3 dias

360.00€399.00€

.

Art System efeito de luzes

Art System efeito de luzes

Roller efffect light 308 com lampada

REF: LYLIGHT308

Disponibilidade imediata

24.90€

.

Art System moving head

Art System moving head

575 Spot - com memoria de posiçao, condensador e filtro, 14 canai

REF: LY575SMR

Disponibilidade imediata

399.00€709.99€

.

Art System led downlight

Art System led downlight

3 leds de 1w, 230v,branco frio 6400ºk, espelho cinza redondo

REF: LYD3X1WWRE

Disponibilidade imediata

5.06€

.

Art System laser moving head

Art System laser moving head

Mini rgy250 - 150mW Vermelho, 100mWverde, 250mW amarelo

REF: LYHEADLRGY250

Disponibilidade imediata

299.90€459.99€

.

ibiza extensao de corrente

ibiza extensao de corrente

lc606 sextupla

REF: LC606

Disponibilidade imediata

29.90€35.90€

.

Rcfsubwoofer activo

Rcfsubwoofer activo

ART 905-AS

REF: ART905AS

disponível em 2-3 dias

1,379.00€1,599.00€

.

sunlite hardware software

sunlite hardware software

SLESA-U6 - EASY STAND ALONE - USB - 60 canais

REF: SLESAU6

Disponibilidade imediata

99.00€306.48€

.

Art System scanner

Art System scanner

250 w SCANNER m

REF: LY250SCANNERM

Disponibilidade imediata

199.00€389.99€

.

led downlight 6W

led downlight 6W

REF: DOWNLIGHT6W

Disponibilidade imediata

15.00€29.90€

.

novation usb midi controller

novation usb midi controller

Teclado semi-pesado com 49 teclas / Oferta de Bass Station Plug-i

REF: REMOTE49

Disponibilidade imediata

199.00€563.75€

.

Art System led moving head

Art System led moving head

Mini spot15 - com led de 18 w rgb

REF: LYMINISPOT15

Disponibilidade imediata

179.90€199.90€

.

procab cabo de microfone

procab cabo de microfone

xlr macho-xlrfemea 0,5m

REF: CAB9010.5

Disponibilidade imediata

6.05€

.