SELECT c.id FROM bthsf_categories AS c WHERE c.access IN (1,4) AND c.published = 1 AND c.language in ('de-DE','*') AND c.extension = 'com_jevents' AND ((c.lft>=5 AND c.rgt<=30 ) OR (c.lft>=6 AND c.rgt<=7 ) OR (c.lft>=8 AND c.rgt<=9 ) OR (c.lft>=10 AND c.rgt<=11 ) OR (c.lft>=12 AND c.rgt<=13 ) OR (c.lft>=14 AND c.rgt<=15 ) OR (c.lft>=16 AND c.rgt<=17 ) OR (c.lft>=18 AND c.rgt<=19 ) OR (c.lft>=20 AND c.rgt<=21 ) OR (c.lft>=22 AND c.rgt<=23 ) OR (c.lft>=24 AND c.rgt<=25 ) OR (c.lft>=28 AND c.rgt<=29 ) OR (c.lft>=8 AND c.rgt<=9 ) OR (c.lft>=10 AND c.rgt<=11 ) OR (c.lft>=12 AND c.rgt<=13 ) OR (c.lft>=14 AND c.rgt<=15 ) OR (c.lft>=16 AND c.rgt<=17 ) OR (c.lft>=20 AND c.rgt<=21 ) OR (c.lft>=31 AND c.rgt<=32 ) OR (c.lft>=33 AND c.rgt<=34 ) OR (c.lft>=35 AND c.rgt<=36 ) OR (c.lft>=37 AND c.rgt<=38 ) OR (c.lft>=39 AND c.rgt<=48 ) OR (c.lft>=44 AND c.rgt<=45 ) OR (c.lft>=44 AND c.rgt<=45 ) OR (c.lft>=49 AND c.rgt<=60 ) OR (c.lft>=50 AND c.rgt<=51 ) OR (c.lft>=52 AND c.rgt<=53 ) OR (c.lft>=54 AND c.rgt<=55 ) OR (c.lft>=56 AND c.rgt<=57 ) OR (c.lft>=58 AND c.rgt<=59 ) OR (c.lft>=50 AND c.rgt<=51 ) OR (c.lft>=52 AND c.rgt<=53 ) OR (c.lft>=54 AND c.rgt<=55 ) OR (c.lft>=56 AND c.rgt<=57 ) OR (c.lft>=58 AND c.rgt<=59 ) OR (c.lft>=61 AND c.rgt<=72 ) OR (c.lft>=62 AND c.rgt<=63 ) OR (c.lft>=64 AND c.rgt<=65 ) OR (c.lft>=66 AND c.rgt<=67 ) OR (c.lft>=68 AND c.rgt<=69 ) OR (c.lft>=70 AND c.rgt<=71 ) OR (c.lft>=62 AND c.rgt<=63 ) OR (c.lft>=64 AND c.rgt<=65 ) OR (c.lft>=66 AND c.rgt<=67 ) OR (c.lft>=68 AND c.rgt<=69 ) OR (c.lft>=73 AND c.rgt<=74 ) OR (c.lft>=75 AND c.rgt<=76 )) ORDER BY c.lft asc

Terminkalender