Drift & skötsel
<< TillbakaSELECT c.*, (CHAR_LENGTH(c.password) OR CHAR_LENGTH(g.file_archive_password)) AS password_protected, (SELECT rewrite FROM rewrite WHERE module_id = 3 AND category_id = c.categoryid) AS rewrite FROM fa_categories AS c INNER JOIN groups AS g ON g.groupid = c.groupid WHERE c.groupid = 2 AND c.parentid = 4 ORDER BY c.displayorder, c.name