Überspringen
Press enter to begin your search
AGB & Datenschutz-Richtlinien gelesen & akzeptiert
Ich möchte gern Informationen über weitere Premium-Angebote erhalten

* Plichtfelder

Hallo, entdecke alle Deals deiner Stadt!

Exklusive CLASSY Deals...

Green Fee | 2 for 1
2 Spieler zahlen nur 1 Green Fee
Auf Domain-Reservierungen
& Hosting
Rabatt auf E-Bikes
Beim Kauf vor Ort im Shop Geld sparen!

Exklusive CLASSY GOLF DEALS...

Green Fee | 2 FOR 1
2 Spieler zahlen nur 1 Green Fee
Green Fee | 2 for 1
2 Spieler zahlen nur 1 Green Fee
Green Fee | 2 for 1
2 Spieler zahlen nur 1 Green Fee

DIE BESTEN DEALS IN MÜNCHEN...

After Work Special jeden Donnerstag
17:00-20:00 Uhr
Daily Dish
12:00-18:30 Uhr
Freier 1. Donnerstag!
18:00-22:00 Uhr

DIE BESTEN DEALS AM ACHENSEE...

WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND c2.categoryID in (173, 180, 169, ' at line 39]
SELECT ID, coalesce(nickname,name1) as name , ch.status, name2, street, streetNo, zip, city, classycardID, cc.status, cc.category as cat, ( 6371 * acos ( cos ( radians(47.4619634) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(11.7090438) ) + sin ( radians(47.4619634) ) * sin( radians( lat ) ) ) )AS distance, lat, lng FROM tbl_companies as comp INNER JOIN tbl_companies_qultus_check ch on ch.companyID = comp.ID INNER JOIN tbl_classycard cc on cc.companyID = comp.ID INNER JOIN tbl_companies_qultus_categories as c1 on c1.companyID = comp.ID INNER JOIN tbl_companies_qultus_categories as c2 on c2.companyID = comp.ID WHERE comp.isActive = "true" AND cc.isActive = "true" AND c1.categoryID in (77, 711, 78, 682, 2, 226, 27, 26, 28, 391, 365, 513, 511, 151, 150, 302, 3, 178, 34, 38, 32, 305, 304, 355, 39, 33, 694, 36, 174, 176, 675, 643, 700, 697, 699, 698, 328, 472, 473, 474, 471, 470, 296, 339, 294, 319, 341, 344, 432, 71, 72, 73, 74, 387,) AND c2.categoryID in (173, 180, 169, 171, 191, 207, 333, 569, 172, 308, 177, 645, 37, 385, 722, 724, 723, 362, 464, 701, 630, 718, 64, 626, 719, 475, 686, 406, 467, 528, 48, 299, 639, 429, 347, 635, 356, 1, 12, 532, 13, 14, 6, 70, 227, 69, 466) AND cc.category in ("classycard","angebot") group by classycardID HAVING distance < 100 ORDER BY cc.lastUpdate desc LIMIT 9