SELECT * FROM tas_products AS a
INNER JOIN info_product_kind AS b ON a.kind = b.id
WHERE code NOT LIKE "AT%" AND b.id = 1
AND max_age >= "35"
AND sum_rrv >= 5000
AND mnh IS NULL
AND art = 2
AND a.state = 1
AND partner_acc >= 01
AND a.date_start <= Cast("2025-09-02" as Datetime)
AND (a.date_end IS NULL OR a.date_end > Cast("2025-09-02" as Datetime))
ORDER BY price
LIMIT 1;SELECT * FROM tas_products AS a
INNER JOIN info_product_kind AS b ON a.kind = b.id
WHERE code NOT LIKE "AT%" AND b.id = 1
AND max_age >= "35"
AND sum_rrv >= 5000
AND mnh IS NOT NULL
AND art = 2
AND a.state = 1
AND partner_acc >= 01
AND a.date_start <= Cast("2025-09-02" as Datetime)
AND (a.date_end IS NULL OR a.date_end > Cast("2025-09-02" as Datetime))
ORDER BY price
LIMIT 1;SELECT * FROM tas_products AS a
INNER JOIN info_product_kind AS b ON a.kind = b.id
WHERE code NOT LIKE "AT%" AND b.id = 1
AND max_age >= "35"
AND sum_rrv >= 5000
AND mnh IS NULL
AND (art = 1 OR art = 3)
AND a.state = 1
AND partner_acc >= 01
AND a.date_start <= Cast("2025-09-02" as Datetime)
AND (a.date_end IS NULL OR a.date_end > Cast("2025-09-02" as Datetime))
ORDER BY price
LIMIT 1;SELECT * FROM tas_products AS a
INNER JOIN info_product_kind AS b ON a.kind = b.id
WHERE code NOT LIKE "AT%" AND b.id = 1
AND max_age >= "35"
AND sum_rrv >= 5000
AND mnh IS NOT NULL
AND (art = 1 OR art = 3)
AND a.state = 1
AND partner_acc >= 01
AND a.date_start <= Cast("2025-09-02" as Datetime)
AND (a.date_end IS NULL OR a.date_end > Cast("2025-09-02" as Datetime))
ORDER BY price
LIMIT 1;
Reiseversicherung – Kostenlos online vergleichen & buchen
