SELECT images.thumb, images.title images_title, categories.ORDER, categories_lang.title, categories_lang.code item_code, 1 TYPE
        FROM `categories_lang`, `languages`, `categories`
        LEFT JOIN `images` ON images.id = categories.id_images_thumb
        WHERE categories.id = categories_lang.id_categories
        AND languages.code = categories_lang.id_languages
        AND categories_lang.id_languages = '.$DB->q($lang['code']).'
        AND categories.id_parent = '.$DB->q($id).'
        AND categories_lang.visible = 1
        UNION
        SELECT images.thumb, images.title images_title, catalogue.ORDER, catalogue_lang.title, catalogue_lang.code item_code, 2 TYPE
        FROM `catalogue`, `catalogue_lang`, `categories_2_catalogue`, `categories_lang`, `catalogue_images`
        LEFT JOIN `images` ON images.id = catalogue_images.id_images_catalogue
        WHERE catalogue.id = catalogue_lang.id_catalogue
        AND catalogue_lang.id_languages = '.$DB->q($lang['code']).'
        AND categories_2_catalogue.id_catalogue = catalogue.id
        AND categories_2_catalogue.id_categories = '.$DB->q($id).'
        AND categories_2_catalogue.id_categories = categories_lang.id_categories
        AND categories_lang.id_languages = '.$DB->q($lang['code']).'
        AND catalogue.id_catalogue_images = catalogue_images.id
        AND catalogue.is_document = 0
        AND catalogue.active = 1
        AND catalogue_lang.visible = 1
        UNION
        SELECT d.thumb, cl.title images_title, c.ORDER, cl.title, d.src item_code, 3 TYPE
        FROM `catalogue` c, `catalogue_lang` cl, `categories_2_catalogue` c2c, `categories_lang` ctl, `document` d
        WHERE c.id = cl.id_catalogue
            AND c2c.id_catalogue = c.id
            AND d.id_catalogue = c.id
            AND c2c.id_categories = ctl.id_categories
            AND cl.id_languages = ctl.id_languages
            AND d.id_languages = cl.id_languages
            AND cl.id_languages = '.$DB->q($lang['code']).'
            AND ctl.id_languages = '.$DB->q($lang['code']).'
            AND d.id_languages = '.$DB->q($lang['code']).'
            AND c2c.id_categories = '.$DB->q($id).'
            AND d.src IS NOT NULL
        AND c.active = 1
        ORDER BY `order`, `title`