SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'es' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id AND cscart_seo_names.type = 'a' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'pages')WHERE 1 AND cscart_pages.id_path LIKE '9/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (use_avail_period = 'N' OR (use_avail_period = 'Y' AND avail_from_timestamp <= 1746803085 AND avail_till_timestamp >= 1746803085)) ORDER BY cscart_pages.parent_id asc, cscart_pages.position asc, cscart_page_descriptions.page asc
| File: | app/Tygh/Database.php |
| Line: | 333 |
| Function: | _error |
| File: | app/Tygh/Database.php |
| Line: | 136 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 42 |
| Function: | getHash |
| File: | app/functions/fn.cms.php |
| Line: | 280 |
| Function: | db_get_hash_array |
| File: | app/functions/fn.cms.php |
| Line: | 1032 |
| Function: | fn_get_pages |
| File: | app/functions/fn.cms.php |
| Line: | 997 |
| Function: | fn_top_menu_form |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 605 |
| Function: | fn_get_menu_items |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 496 |
| Function: | getValue |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 396 |
| Function: | renderBlockContent |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 333 |
| Function: | renderBlock |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 291 |
| Function: | renderBlocks |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 228 |
| Function: | _renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 287 |
| Function: | _renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 228 |
| Function: | _renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 179 |
| Function: | _renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 143 |
| Function: | _renderContainer |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 47 |
| Function: | render |
| File: | var/cache/templates/responsive/d2fb89e2b66b6f7ccabc2e5349561c5c333b5666.tygh.index.tpl.php |
| Line: | 116 |
| Function: | smarty_function_render_location |
| File: | app/lib/other/smarty/sysplugins/smarty_internal_templatebase.php |
| Line: | 182 |
| Function: | content_56785714c19508_54898248 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 70 |
| Function: | fetch |
| File: | app/lib/other/smarty/sysplugins/smarty_internal_templatebase.php |
| Line: | 377 |
| Function: | fetch |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 54 |
| Function: | display |
| File: | app/functions/fn.control.php |
| Line: | 520 |
| Function: | display |
| File: | index.php |
| Line: | 25 |
| Function: | fn_dispatch |