faq.phpwcms-docu.de

SELECT max(sid) as current_id FROM faqsessions

            SELECT
                fc.id AS id,
                fc.lang AS lang,
                fc.parent_id AS parent_id,
                fc.name AS name,
                fc.description AS description,
                fc.user_id AS user_id
            FROM
                faqcategories fc
            LEFT JOIN
                faqcategory_group fg
            ON
                fc.id = fg.category_id
            LEFT JOIN
                faqcategory_user fu
            ON
                fc.id = fu.category_id
            WHERE
                ( fu.user_id = -1
            OR
                fg.group_id IN (-1) )
            AND
                lang = 'de'
            ORDER BY
                id

SELECT
                thema
            FROM
                faqdata
            WHERE
                id = 67 AND lang = 'de'

SELECT
                keywords
            FROM
                faqdata
            WHERE id = 67 AND lang = 'de'

            SELECT
                faqcategories.id AS id,
                faqcategories.lang AS lang,
                faqcategories.parent_id AS parent_id,
                faqcategories.name AS name,
                faqcategories.description AS description
            FROM
                faqcategoryrelations,
                faqcategories
            WHERE
                faqcategories.id = faqcategoryrelations.category_id
            AND
                faqcategoryrelations.record_id = 67
            AND
                faqcategoryrelations.category_lang = 'de'

SHOW TABLE STATUS