SELECT TOP 1 pam_pages.*, pam_documenttypes.doctype_select_fields, pam_templates.template_folder, pam_templates.template_id AS template_id, pam_templates.template_background_2, pam_stylesheets.style_stylesheet, pam_stylesheets.style_random_key, lng_code AS seo_language, lng_locale, lng_currency_symbol_place, doctype_caching FROM pam_pages INNER JOIN pam_documenttypes ON pam_pages.page_doctype_id = pam_documenttypes.doctype_id INNER JOIN pam_templates ON pam_documenttypes.doctype_template_id=pam_templates.template_id INNER JOIN pam_stylesheets ON pam_templates.template_style_id=pam_stylesheets.style_id INNER JOIN pam_sections ON pam_sections.section_id=pam_pages.page_section_id AND pam_sections.section_division_id=pam_pages.page_division_id INNER JOIN pam_sections_profiles ON pam_sections_profiles.secpro_section_id=pam_sections.section_id CROSS JOIN man_languages WHERE doctype_element NOT IN(SELECT topmenu_element_name FROM man_topmenus WHERE topmenu_hide_content='1') AND man_languages.lng_id = '2' AND pam_pages.page_id=?1481
Product | GEDORE Automotive
