Query constructed:
SELECT l.title, l.name, l.first_name, l.last_name, l.tx_billitonadvfieldskemper_position, l.tx_billitonadvfieldskemper_position_en, l.phone, l.mobile, l.fax, l.email, l.image, l.description, l.address, l.building, l.room, l.zip, l.city, l.country, l.company, l.www FROM tt_address AS l LEFT JOIN tt_address_tx_billitonplzranges_zipranges_mm AS m ON l.uid = m.uid_local LEFT JOIN tx_billitonplzranges_zip AS t ON t.uid = m.uid_foreign LEFT JOIN tt_address_tx_billitonadvfieldskemper_gbereiche_auswahl_mm AS y ON l.uid = y.uid_local LEFT JOIN tx_billitonadvfieldskemper_geschaeftsbereiche AS z ON z.uid = y.uid_foreign LEFT JOIN tt_address_group_mm AS h ON l.uid = h.uid_local LEFT JOIN tt_address_group AS g ON g.uid = h.uid_foreign WHERE '' BETWEEN t.plzvon AND t.plzbis AND z.geschaeftsbereiche LIKE 'Gebäudetechnik' AND l.deleted = 0 ORDER BY g.sorting ASC;
Execution time:0.0028929710388184 sec

No Data