Preisliste

Fehler bei Abfrage SELECT distinct p.field_brand_value AS brand, p.field_ean_0_value AS ean, 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 , round( 6378.135 * acos(sin(g.lat*pi()/180)*sin(47.609521*pi()/180) + cos(g.lat*pi()/180)*cos(47.609521*pi()/180)*cos((g.lon - 13.783373)*pi()/180)) , 0) as distance FROM dp_content_type_product p INNER JOIN package pa ON (p.field_packageid_value = pa.packageid) INNER JOIN prod_price pp ON (p.nid = pp.nid) INNER JOIN packagepool papool ON (papool.packagepoolid = pa.packagepoolid) INNER JOIN temp_price1 tp ON (p.nid = tp.nid) INNER JOIN units u ON (u.unitid = pa.unitid) INNER JOIN dp_term_node t ON (t.vid = p.vid) INNER JOIN dp_term_data td ON (td.tid = t.tid) LEFT JOIN geo g ON (p.PLZ = g.plz) WHERE pp.VALIDBY >= CURDATE() AND (t.tid = OR t.tid = )
Marke, BezeichnungBestpreisPreisvergleichspezf. PreisEntfernung ca. zu PLZ 8990
Fehler bei Abfrage SELECT distinct p.field_brand_value AS brand, p.field_ean_0_value AS ean, 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 , round( 6378.135 * acos(sin(g.lat*pi()/180)*sin(47.609521*pi()/180) + cos(g.lat*pi()/180)*cos(47.609521*pi()/180)*cos((g.lon - 13.783373)*pi()/180)) , 0) as distance FROM dp_content_type_product p INNER JOIN package pa ON (p.field_packageid_value = pa.packageid) INNER JOIN prod_price pp ON (p.nid = pp.nid) INNER JOIN packagepool papool ON (papool.packagepoolid = pa.packagepoolid) INNER JOIN temp_price1 tp ON (p.nid = tp.nid) INNER JOIN units u ON (u.unitid = pa.unitid) INNER JOIN dp_term_node t ON (t.vid = p.vid) INNER JOIN dp_term_data td ON (td.tid = t.tid) LEFT JOIN geo g ON (p.PLZ = g.plz) WHERE pp.VALIDBY >= CURDATE() AND (t.tid = OR t.tid = )