Filter, Pumpen Aquarium Turbelle® masterstream 6580

Currencies:

Manufacturers:

Shopping Cart now in your cart 0 items

Categories

Information

What's New?

Zubehör extra bestellen

CHF790.00

Tell A Friend

» Filter, Pumpen Aquarium » Turbelle® masterstream 6580 » Turbelle® masterstream 6580 [6580.000]

Turbelle® masterstream 6580 (6580.000) für Aquarien > 20.000L Strömungsleistung: 45.000 bis ca. 80.000l/h Strömungsgeschwindigkeit: 1,1 - 2,0m/s Energieverbrauch: 290-420W Netzteil: 100-240V / 50-60Hz / 24-30VDC Kabellänge: 10m Maße: L340 x B165 x H227mm Ausstoß: ø125mm Befestigung auf Rohr ø32mm Geliefert mit Wavecontroller 7092

CHF4,694.10

This product was added to our catalog on Sunday 29 December, 2013.

1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'usr_web13_1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '227' and opa.orders_id = opb.orders_id and opb.products_id != '227' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]