SELECT id, foto1, ENtitle AS titel, [Category] FROM watermolen_projects WHERE [category] = '1;' AND publish = 'Show' ORDER BY ProjectDatum ASC ; Watermolen