phpMyFAQ Codename Pandora

            SELECT
                config_name, config_value
            FROM
                faqconfig

            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
                ( fg.group_id IN (-1)
            OR
                (fu.user_id = -1 AND fg.group_id IN (-1)))
            AND
                fc.lang = 'en'
            GROUP BY
                fc.id, fc.lang, fc.parent_id, fc.name, fc.description, fc.user_id
            ORDER BY
                fc.id

            SELECT
                COUNT(record_id) AS n
            FROM
                faqdata_tags

                    SELECT
                        count(sid) AS anonymous_users
                    FROM
                        faqsessions
                    WHERE
                            user_id = -1
                        AND time > 1220900378

                    SELECT
                        count(session_id) AS registered_users
                    FROM
                        faquser
                    WHERE
                        session_timestamp > 1220900378