Angebote bei - günstig einkaufen

Fehler bei Abfrage SELECT distinct p.field_brand_value AS brand, p.field_caption_value AS caption, p.nid, pp.price, t.tid, td.name, pa.packagesize AS packagesize, u.caption AS unitcaption, u.basecaption AS baseunitcaption, round(100*((pp.price - pp.BestPrice)/pp.BestPrice),0) AS pricediffpercentage, round( ( ( pp.price / pa.packagesize ) / u.factor ) , 2 ) AS specificprice, td.name AS term_data_name FROM dp_content_type_product p LEFT JOIN prod_price pp ON p.nid = pp.nid LEFT JOIN dp_term_node t ON p.nid = t.nid LEFT JOIN dp_term_data td ON t.tid = td.tid LEFT JOIN package pa ON p.field_packageid_value = pa.packageid LEFT JOIN packagepool papool ON pa.packagepoolid = papool.packagepoolid LEFT JOIN units u ON pa.unitid = u.unitid WHERE pp.validby >= '2017-12-15' AND pp.corporate_corporateid = ORDER BY pricediffpercentage ASC
Marke, BezeichnungBestpreisPreisvergleichSortiericonspezf. Preis
Fehler bei Abfrage SELECT distinct p.field_brand_value AS brand, p.field_caption_value AS caption, p.nid, pp.price, t.tid, td.name, pa.packagesize AS packagesize, u.caption AS unitcaption, u.basecaption AS baseunitcaption, round(100*((pp.price - pp.BestPrice)/pp.BestPrice),0) AS pricediffpercentage, round( ( ( pp.price / pa.packagesize ) / u.factor ) , 2 ) AS specificprice, td.name AS term_data_name FROM dp_content_type_product p LEFT JOIN prod_price pp ON p.nid = pp.nid LEFT JOIN dp_term_node t ON p.nid = t.nid LEFT JOIN dp_term_data td ON t.tid = td.tid LEFT JOIN package pa ON p.field_packageid_value = pa.packageid LEFT JOIN packagepool papool ON pa.packagepoolid = papool.packagepoolid LEFT JOIN units u ON pa.unitid = u.unitid WHERE pp.validby >= '2017-12-15' AND pp.corporate_corporateid = ORDER BY pricediffpercentage ASC