{sql}SELECT PLAN_EINTRAEGE.*,PLAN_KATEGORIEN.NAME FROM PLAN_EINTRAEGE LEFT JOIN PLAN_KATEGORIEN ON PLAN_EINTRAEGE.KATEGORIE=PLAN_KATEGORIEN.ID WHERE LOWER(PLAN_EINTRAEGE.BEZEICHNUNG) LIKE '%{lower}{$liste}{/lower}%' OR LOWER(PLAN_EINTRAEGE.SYNONYME) LIKE '%{lower}{$liste}{/lower}%' OR PLAN_EINTRAEGE.KATEGORIE LIKE '{$kat_id}' ORDER BY ID|