Table 'web7_db12.config' doesn't exist ::: SELECT shops_off FROM config LIMIT 1
Table 'web7_db12.gebiete' doesn't exist ::: SELECT COUNT(*) FROM gebiete, liefergebiete WHERE gebiet = 'Eischen' AND liefergebiete.gebiet_id=gebiete.gebiet_id
Table 'web7_db12.gebiete' doesn't exist ::: SELECT COUNT(*) FROM gebiete, liefergebiete WHERE gebiet = 'Eischen' AND liefergebiete.gebiet_id=gebiete.gebiet_id
Table 'web7_db12.gebiete' doesn't exist ::: SELECT COUNT(*) FROM gebiete, liefergebiete WHERE gebiet LIKE 'Eischen%' AND liefergebiete.gebiet_id=gebiete.gebiet_id
Table 'web7_db12.gebiete' doesn't exist ::: SELECT COUNT(*) FROM gebiete, liefergebiete WHERE gebiet LIKE 'Eischen%' AND liefergebiete.gebiet_id=gebiete.gebiet_id
Table 'web7_db12.FT2bland' doesn't exist ::: SELECT fid FROM FT2bland WHERE bland IN (SELECT bland FROM plz2bland WHERE PLZ=0) AND '2019-08-22' BETWEEN von AND bis
Table 'web7_db12.ofz_sp_cases' doesn't exist ::: SELECT * FROM ofz_sp_cases WHERE 20190822 BETWEEN `date_von` AND `date_bis`
Table 'web7_db12.shops' doesn't exist ::: SELECT * FROM ( SELECT s.shop_id, s.name, s.PLZ, s.ort, s.strasse_nr, s.verz, s.logo, s.spez, s.auswahl, s.qualitaet, s.lieferzeit, s.preis_leistung, s.durchschnitt, MIN(s.mindestbest) AS mindestbest, MIN(s.anfahrt) AS anfahrt, s.off, s.active, s.exklusiv, s.created, s.voted, von, bis, s.gebiet_id, s.weight, s.kitchen FROM ( SELECT shops.shop_id, shops.name, shops.PLZ, shops.ort, shops.strasse_nr, shops.verz, shops.logo, shops.spez, shops.auswahl, shops.qualitaet, shops.lieferzeit, shops.preis_leistung, shops.durchschnitt, shops.off, shops.active, shops.exklusiv, shops.created, shops.voted, liefergebiete.mindestbest, liefergebiete.anfahrt, liefergebiete.gebiet_id, shops.weight, shops.kitchen FROM shops INNER JOIN liefergebiete ON shops.shop_id = liefergebiete.shop_id WHERE gebiet_id IN (12345) ) as s LEFT JOIN (SELECT DISTINCT shop_id, von, bis FROM oeffnungszeiten WHERE '2243' BETWEEN von AND bis AND day='4' AND shop_id NOT IN (0) ) AS ofz ON ofz.shop_id = s.shop_id GROUP BY s.shop_id UNION SELECT 4611686018427387904, 'torten.de', 42119, 'Wuppertal', 'Lise-Meitner-Str. 1-9', '/srv/www/pizzeria.lu/lieferservice/wuppertal/torten.de', '../../../../images/lieferservice/tortenlogo.jpg', '<a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Fototorten\' href=\'//torten.de/Fototorten\'>Fototorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Motivtorten\' href=\'//torten.de/Motivtorten\'>Motivtorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Kindertorten\' href=\'//torten.de/Kindertorten\'>Kindertorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Hochzeitstorten\' href=\'//torten.de/Hochzeitstorten\'>Hochzeitstorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Werbetorten\' href=\'//torten.de/Werbetorten\'>Werbetorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Firmentorten\' href=\'//torten.de/Firmentorten\'>Firmentorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Geburtstagstorten\' href=\'//torten.de/Geburtstagstorten\'>Geburtstagstorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Cupcakes\' href=\'//torten.de/Cupcakes\'>Cupcakes</a>',4,4,5,5,4.5,30,0,0,1,0,NOW(),NOW(),'0000','2359',12345,10, 1023 ) AS a ORDER BY active DESC, CASE WHEN von IS NULL THEN 0 WHEN von='' THEN 0 WHEN von='0000' AND bis='0000' THEN 0 ELSE 1 END DESC, CASE WHEN voted='0000-00-00 00:00:00' AND DATEDIFF(NOW(),created) < 56 THEN 1 ELSE 0 END DESC, weight DESC, durchschnitt DESC, exklusiv DESC, mindestbest ASC, a.name ASC
Table 'web7_db12.FT2bland' doesn't exist ::: SELECT fid FROM FT2bland WHERE bland IN (SELECT bland FROM plz2bland WHERE PLZ=0) AND '2019-08-22' BETWEEN von AND bis
Table 'web7_db12.ofz_sp_cases' doesn't exist ::: SELECT * FROM ofz_sp_cases WHERE 20190822 BETWEEN `date_von` AND `date_bis`
Table 'web7_db12.shops' doesn't exist ::: SELECT * FROM ( SELECT s.shop_id, s.name, s.PLZ, s.ort, s.strasse_nr, s.verz, s.logo, s.spez, s.auswahl, s.qualitaet, s.lieferzeit, s.preis_leistung, s.durchschnitt, MIN(s.mindestbest) AS mindestbest, MIN(s.anfahrt) AS anfahrt, s.off, s.active, s.exklusiv, s.created, s.voted, von, bis, s.gebiet_id, s.weight, s.kitchen FROM ( SELECT shops.shop_id, shops.name, shops.PLZ, shops.ort, shops.strasse_nr, shops.verz, shops.logo, shops.spez, shops.auswahl, shops.qualitaet, shops.lieferzeit, shops.preis_leistung, shops.durchschnitt, shops.off, shops.active, shops.exklusiv, shops.created, shops.voted, liefergebiete.mindestbest, liefergebiete.anfahrt, liefergebiete.gebiet_id, shops.weight, shops.kitchen FROM shops INNER JOIN liefergebiete ON shops.shop_id = liefergebiete.shop_id WHERE gebiet_id IN (12345) ) as s LEFT JOIN (SELECT DISTINCT shop_id, von, bis FROM oeffnungszeiten WHERE '2243' BETWEEN von AND bis AND day='4' AND shop_id NOT IN (0) ) AS ofz ON ofz.shop_id = s.shop_id GROUP BY s.shop_id UNION SELECT 4611686018427387904, 'torten.de', 42119, 'Wuppertal', 'Lise-Meitner-Str. 1-9', '/srv/www/pizzeria.lu/lieferservice/wuppertal/torten.de', '../../../../images/lieferservice/tortenlogo.jpg', '<a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Fototorten\' href=\'//torten.de/Fototorten\'>Fototorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Motivtorten\' href=\'//torten.de/Motivtorten\'>Motivtorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Kindertorten\' href=\'//torten.de/Kindertorten\'>Kindertorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Hochzeitstorten\' href=\'//torten.de/Hochzeitstorten\'>Hochzeitstorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Werbetorten\' href=\'//torten.de/Werbetorten\'>Werbetorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Firmentorten\' href=\'//torten.de/Firmentorten\'>Firmentorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Geburtstagstorten\' href=\'//torten.de/Geburtstagstorten\'>Geburtstagstorten</a>, <a class=\'btn btn-link\' style=\'padding:0;text-align:left;\' target=\'_blank\' title=\'Cupcakes\' href=\'//torten.de/Cupcakes\'>Cupcakes</a>',4,4,5,5,4.5,30,0,0,1,0,NOW(),NOW(),'0000','2359',12345,10, 1023 ) AS a ORDER BY active DESC, CASE WHEN von IS NULL THEN 0 WHEN von='' THEN 0 WHEN von='0000' AND bis='0000' THEN 0 ELSE 1 END DESC, CASE WHEN voted='0000-00-00 00:00:00' AND DATEDIFF(NOW(),created) < 56 THEN 1 ELSE 0 END DESC, weight DESC, durchschnitt DESC, exklusiv DESC, mindestbest ASC, a.name ASC
