Angebote mit "" Aktion

Fehler bei Abfrage SELECT distinct p.field_brand_value AS brand, p.field_caption_value AS caption, p.nid, pa.packagesize AS packagesize, papool.caption AS packagecaption, u.caption AS unitcaption, u.basecaption AS baseunitcaption, tp.price AS price, t.tid AS tid, td.name AS term_data_name, round( 100 * ( ( tp.price - tp.maxprice) / tp.maxprice ) , 0 ) AS pricediffpercentage , round( ( ( tp.price / pa.packagesize ) / u.factor ) , 2 ) AS specificprice FROM dp_content_type_product p, dp_term_data td, dp_term_node t, package pa, packagepool papool, units u, aktion a, temp_price1 tp, prod_price pp WHERE a.aktionid = AND pp.validby >= '2017-12-14' AND pp.AKTION_AKTIONID = a.aktionid AND pp.nid = p.nid AND t.vid = p.vid AND td.tid = t.tid AND papool.packagepoolid = pa.packagepoolid AND u.unitid = pa.unitid AND pa.packageid = p.field_packageid_value AND tp.nid = p.nid ORDER BY term_data_name, price ASC
Array