Professionele IP-camera's Productshop

Professionele IP-camera's Toepassingen & Oplossingen

Professionele IP-camera's Live Viewing Software

Installatie & Ondersteuning


HOMEPAGE SiteCam Webcam Hosting Persoonlijk Advies Rent-A-Cam Support Inloggen Wederverkopers Contact
Produkten
 Axis Companion Line


 Beweegbare Camera's 


 Vaste binnencamera's


 Vaste buitencamera's


 Speciale Camera's


 Toegangscontrole


 Speciale Producten


 Audio / Camera's


 Thermal Camera's


 Behuizingen en masten 


 Complete oplossingen


 Software 


 SpyCam


 Videoservers


 Opslag / NAS


 Draadloos 


 GPRS/UMTS/HSDPA


 Bekabeling + toebehoren


 Switches / PoE


 Verlichting


 Overige Produkten


 Accessoires 


 Diensten


 NetcamViewer Live Webcam Hosting


 Weergave beelden netwerkcamera


 Opruiming


 Discontinued Products 
Achtergrond informatie
 Technische informatie
 Toepassingen
 Overig
Informatie
 Contact
 Disclaimer en copyright
 Algemene voorwaarden
 Neem contact op
 Bestellen
 Verzendwijze
 Betalen
 Levering
 Service & Support
producten Online
1055 - Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'webc_main.s.status' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select pd.products_name, m.manufacturers_name, p.products_image, p.products_id, p.products_eol, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '4' and p2c.categories_id = '18' group by p.products_id order by pd.products_name

[TEP STOP]