1 . SELECT * FROM store_master WHERE status = '1' AND (store_name = 'proprintingny' OR url = 'proprintingny.dev.radixweb.net' OR url = 'rintingny.dev.radixweb.net') 0.0005 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 103 -> require_once ↳plugins/multistore/multistore_custom_function.php : 12 -> require_once ↳plugins/multistore/multistore_domain_checking.php : 32 -> StoreMaster::getStore ↳model/StoreMaster.php : 84 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
2 . SELECT setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('STORE_LANGUAGE', 'STORE_FAQ', 'STORE_BANNER', 'STORE_TESTIMONIAl', 'STORE_PAYMENT_METHOD', 'STORE_SHIPPING_METHOD', 'STORE_CURRENCY', 'STORE_COUNTRY', 'STORE_PRODUCT_INFO_LAYOUT', 'STORE_FB_LOGIN', 'STORE_FB_APP_ID', 'STORE_FB_APP_SECRET', 'STORE_FB_SHARE', 'STORE_FB_ENABLE', 'STORE_GOOGLE_LOGIN_ENABLE', 'STORE_GOOGLE_LOGIN_CLIENT_ID', 'STORE_GOOGLE_LOGIN_CLIENT_SECRET', 'STORE_BANNER_IMAGE_SETTINGS') AND store_id = 2 0.0005 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 103 -> require_once ↳plugins/multistore/multistore_custom_function.php : 12 -> require_once ↳plugins/multistore/multistore_domain_checking.php : 67 -> get_store_settings ↳plugins/multistore/multistore_custom_function.php : 117 -> StoreSettingsMaster::getStoreSettings ↳model/StoreSettingsMaster.php : 72 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
3 . SELECT section_id, status FROM admin_section WHERE section_id IN (SELECT section_id FROM admin_section_description where site_language_id = '1' AND LOWER(section_heading) = LOWER('Templates')) 0.0004 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 518 -> AdminSectionMaster::getAdminSectionDetail ↳model/AdminSectionMaster.php : 129 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
4 . SELECT (CASE WHEN (store_configuration_master.configuration_id IS NOT NULL AND store_configuration_master.configuration_id != '') THEN store_configuration_master.set_value ELSE configuration_master.set_value END) AS set_value, configuration_master.configuration_id, configuration_master.constant_name FROM configuration_master LEFT JOIN store_configuration_master ON store_configuration_master.constant_name = configuration_master.constant_name AND store_configuration_master.store_id= 2 ORDER BY configuration_master.sort_order ASC, configuration_master.configuration_id ASC 0.0004 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 608 -> ConfigurationMaster::getConfiguration ↳model/ConfigurationMaster.php : 117 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
5 . SELECT theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'proprintingny' 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 629 -> SiteThemeMaster::getSiteTheme ↳model/SiteThemeMaster.php : 79 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
6 . SELECT setting_constant_name, setting_value FROM store_settings WHERE setting_constant_name IN ('STORE_FB_LOGIN', 'STORE_FB_APP_ID', 'STORE_FB_APP_SECRET', 'STORE_FB_SHARE', 'STORE_FB_ENABLE', 'STORE_GOOGLE_LOGIN_ENABLE', 'STORE_GOOGLE_LOGIN_CLIENT_ID', 'STORE_GOOGLE_LOGIN_CLIENT_SECRET') AND store_id = 2 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 707 -> require_once ↳plugins/multistore/multistore_social_constant.php : 6 -> get_store_settings ↳plugins/multistore/multistore_custom_function.php : 117 -> StoreSettingsMaster::getStoreSettings ↳model/StoreSettingsMaster.php : 72 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
7 . SELECT * FROM external_services WHERE status = '1' 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 709 -> ExternalServiceMaster::getExternalService ↳model/ExternalServiceMaster.php : 54 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
8 . SELECT * FROM store_external_services WHERE store_id = 2 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 714 -> GetStoreExternalServicesSetting ↳plugins/multistore/multistore_custom_function.php : 450 -> StoreExternalServicesMaster::getStoreExternalService ↳model/StoreExternalServicesMaster.php : 103 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
9 . SELECT * FROM store_external_services WHERE store_id = 2 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 714 -> GetStoreExternalServicesSetting ↳plugins/multistore/multistore_custom_function.php : 450 -> StoreExternalServicesMaster::getStoreExternalService ↳model/StoreExternalServicesMaster.php : 103 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
10 . SELECT * FROM store_external_services WHERE store_id = 2 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 714 -> GetStoreExternalServicesSetting ↳plugins/multistore/multistore_custom_function.php : 450 -> StoreExternalServicesMaster::getStoreExternalService ↳model/StoreExternalServicesMaster.php : 103 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
11 . SELECT * FROM store_external_services WHERE store_id = 2 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 714 -> GetStoreExternalServicesSetting ↳plugins/multistore/multistore_custom_function.php : 450 -> StoreExternalServicesMaster::getStoreExternalService ↳model/StoreExternalServicesMaster.php : 103 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
12 . SELECT * FROM store_external_services WHERE store_id = 2 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 104 -> require_once ↳lib/siteconstants.php : 714 -> GetStoreExternalServicesSetting ↳plugins/multistore/multistore_custom_function.php : 450 -> StoreExternalServicesMaster::getStoreExternalService ↳model/StoreExternalServicesMaster.php : 103 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
13 . SELECT * FROM site_language WHERE (site_language_id = '1' OR shortname = '1') 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 151 -> require_once ↳lib/config_language.php : 96 -> create_language_session ↳lib/dbfunctions.php : 3806 -> SiteLanguageMaster::getSiteLanguage ↳model/SiteLanguageMaster.php : 52 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
14 . SELECT * FROM site_currency WHERE currency_id = '1' 0.0002 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 151 -> require_once ↳lib/config_language.php : 110 -> create_currency_session ↳lib/dbfunctions.php : 3872 -> CurrencyMaster::getCurrency ↳model/CurrencyMaster.php : 81 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
15 . SELECT count(*) as active_langs FROM site_language where status = '1' 0.0002 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 242 -> require_once ↳lib/seo.php : 250 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
16 . SELECT shortname, site_language_id FROM site_language 0.0002 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 242 -> require_once ↳lib/seo.php : 257 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
17 . select TC.category_id, TCD.category_name from site_template_category as TC Left Join site_template_category_description AS TCD ON TCD.category_id = TC.category_id and TCD.site_language_id = '1' 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 242 -> require_once ↳lib/seo.php : 274 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
18 . SELECT product_category.category_id, product_category_description.category_url as caturl, product_category_description.description, product_category_description.site_language_id FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category.status = '1' 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 242 -> require_once ↳lib/seo.php : 285 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
19 . select p.products_id, pd.product_url as producturl,pd.products_title as productname, pd.site_language_id from products as p Left Join products_description as pd on pd.products_id = p.products_id 0.0072 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 242 -> require_once ↳lib/seo.php : 297 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
20 . SELECT site_seo_description.seo_page_title, site_seo_description.seo_page_keywords,site_seo_description.seo_page_description FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE site_seo_description.site_language_id = 1 AND (site_seo.store_id = 2 OR site_seo.store_id = 0) AND (site_seo.page_name = 'cms.php' OR site_seo.page_name = 'cms') ORDER BY site_seo.page_id desc, site_seo.store_id DESC 0.0098 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 243 -> require_once ↳lib/metatag.php : 50 -> seoPageMaster::getSeoPageDetails ↳model/seoPageMaster.php : 147 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
21 . SELECT * FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE (site_seo.page_name = 'Default') AND (site_seo.store_id = '2' OR site_seo.store_id = 0) 0.0004 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 243 -> require_once ↳lib/metatag.php : 56 -> seoPageMaster::getSeoPageDetails ↳model/seoPageMaster.php : 147 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
22 . SELECT SQL_CALC_FOUND_ROWS cms_pages_description.site_language_id, cms_pages_description.seo_page_title, cms_pages_description.seo_page_keywords,cms_pages_description.seo_page_description,cms_pages_description.page_heading,cms_pages_description.canonical_id,(IF(cms_pages_description.canonical_id > 0 ,(select page_name from cms_pages where page_id = cms_pages_description.canonical_id),'')) as canonical_page FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND (cms_pages.page_name = 'design-services' OR cms_pages.page_name = 'design services') AND cms_pages.status = '1' AND cms_pages.store_id IN (2, 0) ORDER BY store_id DESC,corporate_id DESC, corporate_id DESC 0.0006 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 243 -> require_once ↳lib/metatag.php : 77 -> CmsPagesMaster::getCmsPagesDetails ↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
23 . SELECT site_general_metatag.name, site_general_metatag.content FROM site_general_metatag LEFT JOIN site_front_pages on site_front_pages.front_pages_id = site_general_metatag.page_id AND site_front_pages.seo_status = '1' WHERE site_general_metatag.store_id IN (0, 2) AND (site_front_pages.front_pages_name = 'cms.php' OR site_front_pages.front_pages_name = 'cms') OR ( site_general_metatag.page_id = 0 AND site_general_metatag.store_id IN (0, 2) ) ORDER BY site_general_metatag.store_id desc,site_front_pages.front_pages_id desc 0.0088 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 243 -> require_once ↳lib/metatag.php : 290 -> SiteGeneralMetatagMaster::getMetatagDetails ↳model/SiteGeneralMetatagMaster.php : 90 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
24 . SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'cms' 0.0006 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 253 -> SiteFrontPagesMaster::getSiteFrontPages ↳model/SiteFrontPagesMaster.php : 80 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
25 . SELECT SQL_CALC_FOUND_ROWS site_constants.constant_name, site_constants_description.constant_value FROM site_constants LEFT JOIN site_constants_description ON site_constants_description.constant_id = site_constants.constant_id AND site_constants_description.site_language_id=1 LEFT JOIN site_front_page_group ON site_constants.front_group_id = site_front_page_group.front_group_id WHERE site_constants.front_group_id IN (1, 5) 0.0262 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 260 -> SiteConstantMaster::getSiteConstantDetails ↳model/SiteConstantMaster.php : 139 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
26 . SELECT * FROM (SELECT menu_link.*, menu_link_description.menu_title,menu_link_description.menu_image,menu_link_description.site_language_id FROM menu_link LEFT JOIN menu_link_description ON menu_link_description.menu_id = menu_link.menu_id WHERE menu_link_description.site_language_id = 1 AND menu_link.status = '1' AND corporate_id = 0 AND (link_display = '2' OR link_display = '0') AND menu_link.store_id IN ('2', '0') ORDER BY menu_link.store_id DESC LIMIT 18446744073709551615) AS temp_table GROUP BY menu_title,menu_position HAVING status = '1' ORDER BY sort_order ASC 0.0006 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 283 -> all_menu_data ↳lib/dbfunctions.php : 2403 -> MenuLinkMaster::getMenuLinkDescriptionWithCorporate ↳model/MenuLinkMaster.php : 256 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
27 . SELECT * FROM product_info_layout WHERE product_info_layout.store_id IN (0, 2) ORDER BY layout_id ASC, product_info_layout.store_id DESC 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 308 -> require_once ↳templates/include/site_variables.php : 118 -> ProductDescriptionLayoutMaster::getProductDescriptionLayout ↳model/ProductDescriptionLayoutMaster.php : 89 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
28 . SELECT * FROM sidebar_management WHERE store_id IN (2, 0) AND section_pages LIKE '%|cms.php|%' OR (corporate_id = 0 AND section_name = 'Default' AND store_id IN (2, 0) ) ORDER BY sidebar_id DESC LIMIT 1 OFFSET 0 0.0004 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 310 -> require_once ↳lib/twig.php : 58 -> get_sidebox_details ↳lib/dbfunctions.php : 622 -> SidebarManagementMaster::getSidebarManagement ↳model/SidebarManagementMaster.php : 89 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
29 . SELECT * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND corporate_id = 0 AND side_menu_id NOT IN ('4', '3', '14', '6') AND side_menu_id NOT IN ( SELECT `master_side_menu_id` FROM side_menu_link WHERE `side_menu_id` IN ('4', '3', '14', '6') ) AND side_menu_link.store_id IN ('2', '0') ORDER BY sortorder ASC, status ASC, menu_title ASC, store_id DESC LIMIT 18446744073709551615 ) AS temp_table GROUP BY menu_title HAVING status = '1' AND menu_display IN ('0', '1') ORDER BY sortorder ASC, status ASC, menu_title ASC, store_id DESC 0.0005 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 310 -> require_once ↳lib/twig.php : 58 -> get_sidebox_details ↳lib/dbfunctions.php : 645 -> SideMenuLinkMaster::getSideMenuLinkDescriptionWithCorporate ↳model/SideMenuLinkMaster.php : 150 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
30 . SELECT leftbox, rightbox FROM sidebar_management WHERE store_id IN (2, 0) AND section_pages LIKE '%|cms.php|%' OR (corporate_id = 0 AND section_name = 'Default' AND store_id IN (2, 0) ) ORDER BY store_id DESC, sidebar_id DESC LIMIT 1 OFFSET 0 0.0003 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 310 -> require_once ↳lib/twig.php : 100 -> SidebarManagementMaster::getSidebarManagement ↳model/SidebarManagementMaster.php : 89 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
31 . SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages_description.page_heading, cms_pages_description.page_content, cms_pages.corporate_id FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND cms_pages.page_name IN ('cms_header', 'cms_middle_footer', 'cms_footer', 'contact_us_box', 'sidebar_content_left', 'sidebar_content_right', 'related_product_section_help', 'cms_social_media_links', 'about_us_bottom_banner', 'download_templates') AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 AND cms_pages.store_id IN (2, 0) ORDER BY store_id ASC, store_id DESC,corporate_id DESC, corporate_id DESC 0.0004 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 310 -> require_once ↳lib/twig.php : 172 -> CmsPagesMaster::getCmsPagesDetails ↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
Render > testimonials_scroll.block 32 . SELECT * FROM testimonial INNER JOIN testimonial_description ON (testimonial.testimonial_id = testimonial_description.testimonial_id) WHERE testimonial.store_id IN (0, 2) AND testimonial.status = '1' AND testimonial_description.site_language_id = 1 ORDER BY RAND() LIMIT 2 OFFSET 0 0.0009 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 310 -> require_once ↳lib/twig.php : 177 -> render_cms ↳templates/include/html_helper.php : 1654 -> preg_replace_callback ↳ : -> {closure} ↳templates/include/html_helper.php : 1652 -> Twig_Environment::render (testimonials_scroll.block ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_3530bb05395bebfe58d3c2b95d25622f73ae43e87ec08b1229db4552be2ff0ce::doDisplay ↳cache/35/30/bb05395bebfe58d3c2b95d25622f73ae43e87ec08b1229db4552be2ff0ce.php : 30 -> get_testimonials ↳templates/include/html_helper.php : 506 -> TestimonialMaster::getTestimonialdata ↳model/TestimonialMaster.php : 156 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
Render > subscriber.block 33 . SELECT payment_method_id, status FROM payment_method WHERE directory = 'authorize_cim' 0.0002 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 310 -> require_once ↳lib/twig.php : 274 -> PaymentMethodMaster::getPaymentMethod ↳model/PaymentMethodMaster.php : 67 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
34 . SELECT * FROM store_master 0.0002 sec
↳cms.php : 15 -> require_once ↳lib/common.php : 318 -> require_once ↳plugins/multistore/site_variables.php : 14 -> StoreMaster::getStore ↳model/StoreMaster.php : 84 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
*******************************COMMON END*********************************
35 . SELECT * FROM url_redirection_manage WHERE (old_url = 'http://proprintingny.dev.radixweb.net/design-services.html' OR old_url = 'http://proprintingny.dev.radixweb.net/design-services.html' OR old_url = 'http://proprintingny.dev.radixweb.net/design-services.html') ORDER BY url_redirection_id ASC 0.0003 sec
↳cms.php : 23 -> manage_url_redirection ↳templates/include/twig_functions.php : 781 -> UrlRedirectionManageMaster::getUrlRedirectionManage ↳model/UrlRedirectionManageMaster.php : 81 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
36 . SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND (cms_pages.page_name = 'design-services' OR cms_pages.page_name = 'design services') AND cms_pages.status = '1' AND cms_pages.store_id IN (2, 0) GROUP BY cms_pages.page_id ORDER BY store_id desc,corporate_id ASC, store_id DESC,corporate_id DESC, corporate_id DESC 0.0087 sec
↳cms.php : 74 -> CmsPagesMaster::getCmsPagesDetails ↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
Array
(
[twd] => Array
(
[titletag] =>Design Services
[metatag] =>
[layout_style] => Array
(
[l1] => Array
(
[1] => Array
(
[7] => Array
(
[0] => image-gallery
[tab-content] => Array
(
[tabs] => Array
(
[PRODUCT_INFO_DESCRIPTION] => product-description
[COMMON_PRICE_DETAILS] => price-list
[PRODUCT_TEMPLETES] => help-template
)
)
)
[5] => Array
(
[0] => price-calculator
)
)
[2] => Array
(
[12a] => Array
(
[action-buttons] => Array
(
[type] => horizontal-icon
)
)
)
[3] => Array
(
[12a] => Array
(
[0] => product-extra-message
)
[12b] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[RELATED_PRODUCTS] => product-related
[COMBO_DISCOUNT_PRODUCTS] => product-combo
)
)
)
[12c] => Array
(
[0] => product-review
)
)
)
[l2] => Array
(
[1] => Array
(
[7] => Array
(
[0] => image-gallery
[1] => product-description
)
[5] => Array
(
[0] => price-calculator
)
)
[2] => Array
(
[7] => Array
(
[0] => price-list
)
[5] => Array
(
[action-buttons] => Array
(
[type] => vertical-button
)
)
)
[3] => Array
(
[7] => Array
(
[0] => help-template
)
[5] => Array
(
[0] => product-extra-message
)
)
[4] => Array
(
[12a] => Array
(
[0] => product-related
)
[12b] => Array
(
[0] => product-combo
)
[12c] => Array
(
[0] => product-review
)
)
)
[l3] => Array
(
[1] => Array
(
[12] => Array
(
[0] => product-extra-message
)
)
[2] => Array
(
[5] => Array
(
[0] => price-calculator
)
[7] => Array
(
[0] => image-gallery
[tab-content] => Array
(
[tabs] => Array
(
[PRODUCT_INFO_DESCRIPTION] => product-description
[COMMON_PRICE_DETAILS] => price-list
[PRODUCT_TEMPLETES] => help-template
)
)
)
)
[3] => Array
(
[12a] => Array
(
[action-buttons] => Array
(
[type] => horizontal-icon
)
)
[12b] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[RELATED_PRODUCTS] => product-related
[COMBO_DISCOUNT_PRODUCTS] => product-combo
)
)
)
[12c] => Array
(
[0] => product-review
)
)
)
[l4] => Array
(
[1] => Array
(
[6a] => Array
(
[0] => image-gallery
[1] => product-description
)
[6b] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[PRICE_CALCULATOR] => price-calculator
[COMMON_PRICE_DETAILS] => price-list
[PRODUCT_TEMPLETES] => help-template
)
)
)
)
[2] => Array
(
[12] => Array
(
[action-buttons] => Array
(
[type] => horizontal-button
)
)
)
[3] => Array
(
[12a] => Array
(
[0] => product-extra-message
)
[12b] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[RELATED_PRODUCTS] => product-related
[COMBO_DISCOUNT_PRODUCTS] => product-combo
)
)
)
[12c] => Array
(
[0] => product-review
)
)
)
[l5] => Array
(
[1] => Array
(
[12] => Array
(
[0] => image-gallery
)
)
[2] => Array
(
[6a] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[PRODUCT_INFO_DESCRIPTION] => product-description
[COMMON_PRICE_DETAILS] => price-list
[PRODUCT_TEMPLETES] => help-template
)
)
)
[6b] => Array
(
[0] => price-calculator
)
)
[3] => Array
(
[12] => Array
(
[action-buttons] => Array
(
[type] => horizontal-icon
)
)
)
[4] => Array
(
[12a] => Array
(
[0] => product-extra-message
)
[12b] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[RELATED_PRODUCTS] => product-related
[COMBO_DISCOUNT_PRODUCTS] => product-combo
)
)
)
[12c] => Array
(
[0] => product-review
)
)
)
[l6] => Array
(
[1] => Array
(
[12] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[Gallery] => image-gallery
[PRODUCT_INFO_DESCRIPTION] => product-description
[PRICE_CALCULATOR] => price-calculator
[COMMON_PRICE_DETAILS] => price-list
[PRODUCT_TEMPLETES] => help-template
[PRODUCT EXTRA MESSAGE] => product-extra-message
)
)
)
)
[2] => Array
(
[12a] => Array
(
[action-buttons] => Array
(
[type] => horizontal-icon
)
)
[12b] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[RELATED_PRODUCTS] => product-related
[COMBO_DISCOUNT_PRODUCTS] => product-combo
)
)
)
[12c] => Array
(
[0] => product-review
)
)
)
[l7] => Array
(
[1] => Array
(
[12] => Array
(
[0] => product-description
)
)
[2] => Array
(
[6a] => Array
(
[0] => price-calculator
)
[6b] => Array
(
[action-buttons] => Array
(
[type] => vertical-icon
)
)
)
[3] => Array
(
[12a] => Array
(
[0] => product-extra-message
)
[12b] => Array
(
[tab-content] => Array
(
[tabs] => Array
(
[RELATED_PRODUCTS] => product-related
[COMBO_DISCOUNT_PRODUCTS] => product-combo
)
)
)
[12c] => Array
(
[0] => product-review
)
)
)
[PrintNY] => Array
(
[1] => Array
(
[7y] => Array
(
[0] => image-gallery
[tab-content] => Array
(
[tabs] => Array
(
[PRODUCT_INFO_DESCRIPTION] => product-description
)
)
)
[5z] => Array
(
[0] => price-calculator
[action-buttons] => Array
(
[type] => vertical-button
)
)
)
[2] => Array
(
[12j] => Array
(
[0] => product-extra-message
)
)
[3] => Array
(
[12a] => Array
(
[0] => product-related
)
)
[4] => Array
(
[12c] => Array
(
[0] => product-review
)
)
)
[predefined] => Array
(
[1] => Array
(
[6s] => Array
(
[0] => image-gallery
[1] => product-description
)
[6r] => Array
(
[0] => price-calculator
)
)
[2] => Array
(
[12f] => Array
(
[0] => login-form
)
)
[3] => Array
(
[12a] => Array
(
[0] => product-extra-message
)
)
[4] => Array
(
[12h] => Array
(
[0] => product-related
)
)
[5] => Array
(
[12w] => Array
(
[0] => product-review
)
)
[6] => Array
(
[12r] => Array
(
[0] => product-combo
)
)
)
[kitproduct] => Array
(
[0] => Array
(
[12] => Array
(
[0] => image-gallery
[1] => product-description
[2] => price-calculator
)
)
)
)
[arr_side_boxes] => Array
(
[rightbox] => Array
(
[0] => Array
(
[function_name] => get_sidebar_content_right
)
[1] => Array
(
[function_name] => contact_us_sidemenu_box
)
[2] => Array
(
[function_name] => get_header_sidebar
)
)
[leftbox] => Array
(
[0] => Array
(
[function_name] => get_product_listing
)
)
)
[arr_header_main_css] => Array
(
[0] => http://proprintingny.dev.radixweb.net/thirdparty/bootstrap/css/bootstrap.css
[1] => http://proprintingny.dev.radixweb.net/thirdparty/bootstrap/css/bootstrap-plugins.css
[2] => http://proprintingny.dev.radixweb.net/thirdparty/css/font-awesome.css
[3] => http://proprintingny.dev.radixweb.net/thirdparty/fancybox/css/jquery.fancybox.css
[4] => http://proprintingny.dev.radixweb.net/thirdparty/fancybox/helpers/jquery.fancybox-thumbs.css
[5] => http://proprintingny.dev.radixweb.net/thirdparty/css/icomoon.css
[6] => http://proprintingny.dev.radixweb.net/templates/css/loader.css
[7] => http://proprintingny.dev.radixweb.net/templates/css/common.css
[8] => http://proprintingny.dev.radixweb.net/templates/css/badge.css
[9] => http://proprintingny.dev.radixweb.net/templates/css/breadcrumbs.min.css
[10] => http://proprintingny.dev.radixweb.net/themes/proprintingny/css/theme.css
)
[arr_main_css] => Array
(
)
[arr_main_js] => Array
(
[0] => common_js.php
[1] => http://proprintingny.dev.radixweb.net/thirdparty/js/jquery.js
[2] => http://proprintingny.dev.radixweb.net/thirdparty/js/jquery-ui.js
[3] => http://proprintingny.dev.radixweb.net/thirdparty/bootstrap/js/bootstrap.js
[4] => http://proprintingny.dev.radixweb.net/thirdparty/bootstrap/js/bootstrap-plugins.js
[5] => http://proprintingny.dev.radixweb.net/thirdparty/js/jquery.validate.js
[6] => http://proprintingny.dev.radixweb.net/thirdparty/js/jquery.validate.methods.js
[7] => http://proprintingny.dev.radixweb.net/thirdparty/js/jquery.bootstrap-growl.js
[8] => http://proprintingny.dev.radixweb.net/thirdparty/js/handlebars.js
[9] => http://proprintingny.dev.radixweb.net/thirdparty/js/typeahead.js
[10] => http://proprintingny.dev.radixweb.net/thirdparty/js/holder.js
[11] => http://proprintingny.dev.radixweb.net/thirdparty/js/jquery.touchSwipe.min.js
[12] => http://proprintingny.dev.radixweb.net/thirdparty/fancybox/js/jquery.fancybox.js
[13] => http://proprintingny.dev.radixweb.net/thirdparty/fancybox/helpers/jquery.fancybox-thumbs.js
[14] => http://proprintingny.dev.radixweb.net/thirdparty/js/jquery.cookie.js
[15] => http://proprintingny.dev.radixweb.net/thirdparty/js/fileuploader.js
[16] => http://proprintingny.dev.radixweb.net/templates/js/jquery.validate.bootstrap.js
[17] => http://proprintingny.dev.radixweb.net/templates/js/common.js
)
[show_leftbox] => false
[show_rightbox] => false
[show_left_panel] =>
[show_right_panel] =>
[col] => Array
(
[left] => Array
(
[0] => 12
[1] => 4
[2] => 3
[3] => 3
)
[middle] => Array
(
[0] => 12
[1] => 12
[2] => 12
[3] => 12
)
[right] => Array
(
[0] => 12
[1] => 12
[2] => 3
[3] => 3
)
)
[class] => Array
(
[left] => col-xs-12 col-sm-4 col-md-3 col-lg-3
[middle] => col-xs-12 col-sm-12 col-md-12 col-lg-12
[right] => col-xs-12 col-sm-12 col-md-3 col-lg-3
[right_box] => col-xs-12 col-sm-6 col-md-12 col-lg-12
)
[cms] => Array
(
[contact_us_box] =>PrintPalace.com Main address : 2961 Ely Avenue Bronx, NY 10469
Tel:888
) 655-1166
E-mail:
Sales@PrintPalace.com
[related_product_section_help] =>You might also like to see our other products...
[cms_middle_footer] =>
[cms_footer] =>© 2016 ProPrintingNY.com
All Rights Reserved.
Made in New York
[cms_header] =>We Are your printing team We’re a print and design company, which firmly believes that: great design and high-quality products can make a big difference to your customer.
[download_templates] =>Layout guidelines are downloadable files that provide information on product dimensions, layout, bleed, safety zone, border requirements and any folding or mailing guidelines. Our layout guidelines are free, and they are so simple to use. You just download the layout guideline that meets your needs, open it in your design program, create your artwork, submit and approve final artwork, and you’re done. It’s that easy.
)
[auth_cim_payment_method_id] => 25
[SITE_VAR_PRODUCT_NO_IMAGE] =>
[SITE_VAR_DISPLAY_PRODUCT_CATEGORY_SUBOPTION] => %s - %s
[SITE_VAR_CART_AGREE_CHECKBOX] => product_add_info
[cmsData] => RDataRecord Object
(
[_Data:protected] => Array
(
[page_id] => 106
[store_id] => 2
[page_name] => design-services
[type] => M
[status] => 1
[allow_delete] => 1
[corporate_id] => 0
[page_heading] => Design Services
[page_content] =>
“Everything is designed. Few things are designed well”. Brian Reed
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Get Design! It’s not enough to say: we are unique, trust us or be part of the team! Is it? So let the facts speak…
What we know? • All comes from an idea… that will be yours!
• All needs an Art Director… who are we!
• All is better in teams… what are “all of us”
A truth! • A picture is worth a thousand words
• The point is: how to say it!
• Design is a silent ambassador!
Conclusion? It’s not about what you looks and feels… is how it works saying what you need to say and we? We are the answer!
)
[_IteratorKeys:protected] => Array
(
[0] => page_id
[1] => store_id
[2] => page_name
[3] => type
[4] => status
[5] => allow_delete
[6] => corporate_id
[7] => page_heading
[8] => page_content
)
)
[CmsPageName] => design-services
[successMsg] =>
[DataCmsMaster] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = :site_language_id AND (cms_pages.page_name = :cms_pages_page_name OR cms_pages.page_name = :cms_pages_decode_str_page_name) AND cms_pages.status = :cms_pages_status AND cms_pages.store_id IN (:input_0, :input_1) GROUP BY cms_pages.page_id ORDER BY store_id desc,corporate_id ASC, store_id DESC,corporate_id DESC, corporate_id DESC
)
[AffectedRows:RDataRecordSet:private] => 1
[RecordCount] => 1
[foundRows] => 1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[page_id] => 106
[store_id] => 2
[page_name] => design-services
[type] => M
[status] => 1
[allow_delete] => 1
[corporate_id] => 0
[page_heading] => Design Services
[page_content] =>
“Everything is designed. Few things are designed well”. Brian Reed
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Product Description
Lorem Ipsum
Get Design! It’s not enough to say: we are unique, trust us or be part of the team! Is it? So let the facts speak…
What we know? • All comes from an idea… that will be yours!
• All needs an Art Director… who are we!
• All is better in teams… what are “all of us”
A truth! • A picture is worth a thousand words
• The point is: how to say it!
• Design is a silent ambassador!
Conclusion? It’s not about what you looks and feels… is how it works saying what you need to say and we? We are the answer!
)
[_IteratorKeys:protected] => Array
(
[0] => page_id
[1] => store_id
[2] => page_name
[3] => type
[4] => status
[5] => allow_delete
[6] => corporate_id
[7] => page_heading
[8] => page_content
)
)
)
[IteratorCount:RDataRecordSet:private] => 0
[last_query] => SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND (cms_pages.page_name = 'design-services' OR cms_pages.page_name = 'design services') AND cms_pages.status = '1' AND cms_pages.store_id IN (2, 0) GROUP BY cms_pages.page_id ORDER BY store_id desc,corporate_id ASC, store_id DESC,corporate_id DESC, corporate_id DESC
)
[own_mail] =>
[err] =>
[form] => Array
(
)
[referrer_page] =>
)
)
*******************************Render TPL Start*********************************
37 . SELECT SQL_CALC_FOUND_ROWS * FROM product_kit LEFT JOIN product_kit_description ON product_kit_description.kit_id = product_kit.kit_id AND product_kit_description.site_language_id = 1 WHERE (product_kit.user_type_id = '1' OR product_kit.user_type_id = '0') AND product_kit.status = 1 AND product_kit.store_id = 2 ORDER BY product_kit.sort_order ASC, product_kit.kit_id ASC 0.0004 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 57 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_536c6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc::doDisplay ↳cache/53/6c/6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc.php : 43 -> get_menu_links ↳templates/include/html_helper.php : 47 -> get_kit_products ↳templates/include/html_helper.php : 391 -> KitMaster::getKitsData ↳model/KitMaster.php : 143 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
Render > header_toplinks.block Array
(
[twd] => Array
(
[cnt] => 0
[menus] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 9
[store_id] => 2
[menu_link] => user_login.php
[menu_target] => _self
[menu_position] => topheader
[link_display] => 0
[menu_option] => 0
[status] => 1
[sort_order] => 2
[menu_link_category] => 2
[link_type_id] => 79
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => LOGIN
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 60
[store_id] => 2
[menu_link] => express_checkout_payment.php
[menu_target] => _self
[menu_position] => topheader
[link_display] => 2
[menu_option] => 2
[status] => 1
[sort_order] => 3
[menu_link_category] => 0
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => CART
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
)
[arr_myaccount_menu_link] => Array
(
[0] => user_account.php
[1] => user_order.php
[2] => user_portfolio.php
[3] => quote.php
[4] => user_order_inventory.php
[5] => user_account_history.php
[7] => user_images.php
[8] => user_qrcode_list.php
[9] => user_address.php
[10] => user_profile.php
[11] => user_store_profile.php
[12] => sales_order_report.php
[13] => user_changepassword.php
[14] => saved_card.php
)
[kit_data] => Array
(
[0] => Array
(
[imagename] =>
[description] =>
[title] => test_kit
[id] => 1
[url] => http://proprintingny.dev.radixweb.net/product_kit_info.php?kid=1
)
)
[form] => Array
(
[fb_button] =>
)
)
)
38 . SELECT SQL_CALC_FOUND_ROWS * FROM product_kit LEFT JOIN product_kit_description ON product_kit_description.kit_id = product_kit.kit_id AND product_kit_description.site_language_id = 1 WHERE (product_kit.user_type_id = '1' OR product_kit.user_type_id = '0') AND product_kit.status = 1 AND product_kit.store_id = 2 ORDER BY product_kit.sort_order ASC, product_kit.kit_id ASC 0.0004 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 57 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_536c6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc::doDisplay ↳cache/53/6c/6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc.php : 115 -> get_menu_links ↳templates/include/html_helper.php : 47 -> get_kit_products ↳templates/include/html_helper.php : 391 -> KitMaster::getKitsData ↳model/KitMaster.php : 143 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
39 . SELECT product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value, (SELECT product_category_description.category_name FROM product_category_description LEFT JOIN product_category p ON p.parent_id=product_category_description.category_id INNER JOIN product_category pp ON pp.category_id = p.parent_id AND pp.status = '1'WHERE product_category_description.category_id=product_category.parent_id AND product_category_description.site_language_id = 1 GROUP BY products.products_id ORDER BY product_category.sort_order ASC) AS group_name FROM products LEFT JOIN product_store ON product_store.product_id = products.products_id LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND product_store.store_id = 2 ORDER BY product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC, products.products_id ASC 0.0006 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 57 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_536c6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc::doDisplay ↳cache/53/6c/6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc.php : 115 -> get_menu_links ↳templates/include/html_helper.php : 98 -> ProductCategoryMaster::get_group_category_list ↳model/ProductCategoryMaster.php : 206 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
Render > header_menu.block Array
(
[twd] => Array
(
[cnt] => 0
[menus] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 2
[store_id] => 0
[menu_link] => product-menu
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 1
[menu_link_category] => 9
[link_type_id] => 119
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Our Products
[menu_image] => fa-list
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 62
[store_id] => 2
[menu_link] => quote_create.php
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 2
[menu_link_category] => 0
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => CUSTOM QUOTE
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 74
[store_id] => 2
[menu_link] => product_category_info.php
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 2
[status] => 1
[sort_order] => 2
[menu_link_category] => 5
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Categories
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
[3] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 3
[store_id] => 0
[menu_link] => product_prices.php
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 3
[menu_link_category] => 2
[link_type_id] => 25
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Pricing
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
[4] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 66
[store_id] => 2
[menu_link] => cms.php?page=design-services
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 3
[menu_link_category] => 1
[link_type_id] => 106
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Design Services
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
[5] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 65
[store_id] => 2
[menu_link] => contact_us.php
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 2
[status] => 1
[sort_order] => 4
[menu_link_category] => 0
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Contact Us
[menu_image] => fa-envelope-o
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
[6] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 73
[store_id] => 2
[menu_link] => cms.php?page=support
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 1
[status] => 1
[sort_order] => 5
[menu_link_category] => 1
[link_type_id] => 121
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Support
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => store_id
[2] => menu_link
[3] => menu_target
[4] => menu_position
[5] => link_display
[6] => menu_option
[7] => status
[8] => sort_order
[9] => menu_link_category
[10] => link_type_id
[11] => master_menu_id
[12] => corporate_id
[13] => menu_title
[14] => menu_image
[15] => site_language_id
)
)
)
[arr_myaccount_menu_link] => Array
(
[0] => user_account.php
[1] => user_order.php
[2] => user_portfolio.php
[3] => quote.php
[4] => user_order_inventory.php
[5] => user_account_history.php
[7] => user_images.php
[8] => user_qrcode_list.php
[9] => user_address.php
[10] => user_profile.php
[11] => user_store_profile.php
[12] => sales_order_report.php
[13] => user_changepassword.php
[14] => saved_card.php
)
[kit_data] => Array
(
[0] => Array
(
[imagename] =>
[description] =>
[title] => test_kit
[id] => 1
[url] => http://proprintingny.dev.radixweb.net/product_kit_info.php?kid=1
)
)
[form] => Array
(
[fb_button] =>
)
[group_category] => Array
(
[23] => Array
(
[group_name] => Signs and Banners
[groups] => Array
(
[66] => Array
(
[category_name] => Event Tent
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[211] => Array
(
[pname] => Event Tent - (full color)
[pro_enable] =>
[pro_title] =>
)
[212] => Array
(
[pname] => Tent Half Wall (Full Color)
[pro_enable] =>
[pro_title] =>
)
[213] => Array
(
[pname] => Tent Full Wall - (full Color)
[pro_enable] =>
[pro_title] =>
)
[214] => Array
(
[pname] => Tent Flag
[pro_enable] =>
[pro_title] =>
)
)
)
[89] => Array
(
[category_name] => Canvas & Photo Prints
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[196] => Array
(
[pname] => Acrylic Prints
[pro_enable] =>
[pro_title] =>
)
[154] => Array
(
[pname] => Square Canvas
[pro_enable] => no
[pro_title] =>
)
[151] => Array
(
[pname] => Standard Canvas
[pro_enable] =>
[pro_title] =>
)
[153] => Array
(
[pname] => Panoramic Canvas
[pro_enable] =>
[pro_title] =>
)
[192] => Array
(
[pname] => Framed Prints
[pro_enable] =>
[pro_title] =>
)
[193] => Array
(
[pname] => Floating Frame
[pro_enable] =>
[pro_title] =>
)
)
)
[65] => Array
(
[category_name] => Trade Show Products-Straight
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[208] => Array
(
[pname] => Tension Fabric Display - (straight)
[pro_enable] =>
[pro_title] =>
)
[210] => Array
(
[pname] => Velcro Pop Up Display - (straight)
[pro_enable] =>
[pro_title] =>
)
)
)
[58] => Array
(
[category_name] => Standard Banner Stands
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[175] => Array
(
[pname] => X-Stand
[pro_enable] =>
[pro_title] =>
)
[172] => Array
(
[pname] => Standard Retractable
[pro_enable] => no
[pro_title] =>
)
)
)
[50] => Array
(
[category_name] => Deluxe Banner Stands
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[176] => Array
(
[pname] => L Stand
[pro_enable] =>
[pro_title] =>
)
[171] => Array
(
[pname] => Deluxe Retractable
[pro_enable] =>
[pro_title] =>
)
[173] => Array
(
[pname] => SD Retractable - (silver)
[pro_enable] =>
[pro_title] =>
)
)
)
[54] => Array
(
[category_name] => Advertising Flags
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[183] => Array
(
[pname] => Econo Feather Flag
[pro_enable] =>
[pro_title] =>
)
[187] => Array
(
[pname] => Rectangular Flag
[pro_enable] =>
[pro_title] =>
)
[186] => Array
(
[pname] => Feather Angled Flag
[pro_enable] =>
[pro_title] =>
)
[184] => Array
(
[pname] => Teardrop Flag
[pro_enable] =>
[pro_title] =>
)
)
)
[59] => Array
(
[category_name] => Significade A-Frame
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[194] => Array
(
[pname] => Signicade A-frame
[pro_enable] =>
[pro_title] =>
)
[195] => Array
(
[pname] => Signicade Deluxe A-Frame
[pro_enable] =>
[pro_title] =>
)
)
)
[55] => Array
(
[category_name] => Table Throw
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[190] => Array
(
[pname] => 6' Ft Table Cover
[pro_enable] =>
[pro_title] =>
)
[191] => Array
(
[pname] => 8' Ft Table Cover
[pro_enable] =>
[pro_title] =>
)
)
)
[51] => Array
(
[category_name] => Step and Repeat Banners
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[177] => Array
(
[pname] => Step & Repeat Banner
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[25] => Array
(
[group_name] => Standard Printing Products
[groups] => Array
(
[1] => Array
(
[category_name] => Business Cards
[cat_enable] => 1
[cat_pro_text] =>
[products] => Array
(
[1] => Array
(
[pname] => Standard Business Cards
[pro_enable] => no
[pro_title] =>
)
[116] => Array
(
[pname] => Rounded Business Cards
[pro_enable] => no
[pro_title] =>
)
)
)
[82] => Array
(
[category_name] => Stationery
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[101] => Array
(
[pname] => Letterhead
[pro_enable] => no
[pro_title] =>
)
[140] => Array
(
[pname] => Envelopes Full Color
[pro_enable] =>
[pro_title] =>
)
[141] => Array
(
[pname] => Envelopes One Color
[pro_enable] =>
[pro_title] =>
)
[100] => Array
(
[pname] => Notepads
[pro_enable] => no
[pro_title] =>
)
[107] => Array
(
[pname] => Presentation Folders
[pro_enable] => no
[pro_title] =>
)
[150] => Array
(
[pname] => Carbonless Books 25
[pro_enable] =>
[pro_title] =>
)
[152] => Array
(
[pname] => Carbonless Books 50
[pro_enable] =>
[pro_title] =>
)
[149] => Array
(
[pname] => Carbonless Sets
[pro_enable] =>
[pro_title] =>
)
[160] => Array
(
[pname] => Folded Stationery
[pro_enable] =>
[pro_title] =>
)
)
)
[83] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[106] => Array
(
[pname] => Postcards
[pro_enable] => no
[pro_title] =>
)
[95] => Array
(
[pname] => Brochures
[pro_enable] => no
[pro_title] =>
)
[102] => Array
(
[pname] => Sale Sheets - (text stock)
[pro_enable] => no
[pro_title] =>
)
[119] => Array
(
[pname] => Sale Sheets - (cardstock)
[pro_enable] => no
[pro_title] =>
)
[94] => Array
(
[pname] => Rack Cards
[pro_enable] => no
[pro_title] =>
)
[115] => Array
(
[pname] => Door Hangers
[pro_enable] => no
[pro_title] =>
)
[148] => Array
(
[pname] => Bookmarks
[pro_enable] =>
[pro_title] =>
)
[143] => Array
(
[pname] => Flyers - (text stock)
[pro_enable] =>
[pro_title] =>
)
[144] => Array
(
[pname] => Flyers - (cardstock)
[pro_enable] =>
[pro_title] =>
)
[147] => Array
(
[pname] => Posters - (text stock)
[pro_enable] =>
[pro_title] =>
)
[146] => Array
(
[pname] => Posters - (cardstock)
[pro_enable] =>
[pro_title] =>
)
[170] => Array
(
[pname] => Tickets
[pro_enable] =>
[pro_title] =>
)
[138] => Array
(
[pname] => Calendars
[pro_enable] =>
[pro_title] =>
)
[133] => Array
(
[pname] => Booklets & Catalogs
[pro_enable] =>
[pro_title] =>
)
)
)
[84] => Array
(
[category_name] => Stickers & Hang Tags
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[163] => Array
(
[pname] => Square Hang Tags
[pro_enable] =>
[pro_title] =>
)
[165] => Array
(
[pname] => Circular Hang Tags
[pro_enable] =>
[pro_title] =>
)
[145] => Array
(
[pname] => Name Tags
[pro_enable] =>
[pro_title] =>
)
[158] => Array
(
[pname] => Square Stickers
[pro_enable] =>
[pro_title] =>
)
[169] => Array
(
[pname] => Round Stickers
[pro_enable] =>
[pro_title] =>
)
)
)
[85] => Array
(
[category_name] => Restaurants
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[118] => Array
(
[pname] => Take Out Menu
[pro_enable] => no
[pro_title] =>
)
[142] => Array
(
[pname] => Table Tents
[pro_enable] =>
[pro_title] =>
)
)
)
[86] => Array
(
[category_name] => CD & DVD Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[156] => Array
(
[pname] => CD & DVD Covers
[pro_enable] =>
[pro_title] =>
)
[157] => Array
(
[pname] => DVD Booklets
[pro_enable] =>
[pro_title] =>
)
)
)
[87] => Array
(
[category_name] => Invitations
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[139] => Array
(
[pname] => Invitations
[pro_enable] =>
[pro_title] =>
)
[137] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[88] => Array
(
[group_name] => Premium Series
[groups] => Array
(
[75] => Array
(
[category_name] => Premium Series
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[217] => Array
(
[pname] => Tritic Cards
[pro_enable] =>
[pro_title] =>
)
[218] => Array
(
[pname] => Natural Cards
[pro_enable] =>
[pro_title] =>
)
[219] => Array
(
[pname] => Suede Cards
[pro_enable] =>
[pro_title] =>
)
[221] => Array
(
[pname] => Foil Matte Cards
[pro_enable] =>
[pro_title] =>
)
[222] => Array
(
[pname] => Foil and Silk Cards
[pro_enable] =>
[pro_title] =>
)
[223] => Array
(
[pname] => Foil, Spot UV and Silk Cards
[pro_enable] =>
[pro_title] =>
)
[224] => Array
(
[pname] => Silk with Colored Edge
[pro_enable] =>
[pro_title] =>
)
[225] => Array
(
[pname] => Kraft Cards
[pro_enable] =>
[pro_title] =>
)
[226] => Array
(
[pname] => Linen Cards
[pro_enable] =>
[pro_title] =>
)
[227] => Array
(
[pname] => Natural White Cards
[pro_enable] =>
[pro_title] =>
)
[228] => Array
(
[pname] => Weevi Cards
[pro_enable] =>
[pro_title] =>
)
[229] => Array
(
[pname] => Sparkli Cards
[pro_enable] =>
[pro_title] =>
)
[230] => Array
(
[pname] => Wrinkli Cards
[pro_enable] =>
[pro_title] =>
)
[231] => Array
(
[pname] => Smoothi Cards
[pro_enable] =>
[pro_title] =>
)
[232] => Array
(
[pname] => Softi Cards
[pro_enable] =>
[pro_title] =>
)
[240] => Array
(
[pname] => Woodi Eastern Red Cards
[pro_enable] =>
[pro_title] =>
)
[241] => Array
(
[pname] => Woodi Birdseye Maple Cards
[pro_enable] =>
[pro_title] =>
)
[242] => Array
(
[pname] => Woodi Curly Maple Cards
[pro_enable] =>
[pro_title] =>
)
[243] => Array
(
[pname] => Silk Laminated Cards
[pro_enable] =>
[pro_title] =>
)
[244] => Array
(
[pname] => Silk and Spot UV Cards
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[28] => Array
(
[group_name] => Design Services
[groups] => Array
(
[8] => Array
(
[category_name] => Design Services
[cat_enable] => 1
[cat_pro_text] =>
[products] => Array
(
[91] => Array
(
[pname] => Design Services
[pro_enable] => yes
[pro_title] =>
)
)
)
)
)
)
)
)
40 . SELECT SQL_CALC_FOUND_ROWS cms_pages.*, cms_pages_description.page_heading , cms_pages_description.page_content FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'product-menu') AND cms_pages.store_id IN (2, 0) ORDER BY store_id DESC,corporate_id DESC, corporate_id DESC LIMIT 1 OFFSET 0 0.0003 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 57 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_536c6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc::doDisplay ↳cache/53/6c/6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc.php : 115 -> get_menu_links ↳templates/include/html_helper.php : 120 -> Twig_Environment::render (header_menu.block ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_a29224279e68072801148f86236fb0fcd82eb7c40cca336934c6d31dc410696a::doDisplay ↳cache/a2/92/24279e68072801148f86236fb0fcd82eb7c40cca336934c6d31dc410696a.php : 49 -> get_cms_content ↳templates/include/html_helper.php : 1640 -> CmsPagesMaster::getCmsPagesDetails ↳model/CmsPagesMaster.php : 160 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
41 . SELECT product_category.category_id, product_category.category_pro_enable, product_category_description.category_name, product_category_description.category_promotional_text, products.products_id, products.category_id as cat_id, products.predefined_product_type, products_description.products_title, products_description.product_promotional_text, product_settings.setting_constant_name, product_settings.setting_value FROM products LEFT JOIN product_store ON product_store.product_id = products.products_id LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND product_store.store_id = 2 ORDER BY product_category.sort_order ASC, product_category.category_id ASC, products.sort_order ASC, products.products_id ASC 0.0004 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 57 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_536c6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc::doDisplay ↳cache/53/6c/6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc.php : 115 -> get_menu_links ↳templates/include/html_helper.php : 120 -> Twig_Environment::render (header_menu.block ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_a29224279e68072801148f86236fb0fcd82eb7c40cca336934c6d31dc410696a::doDisplay ↳cache/a2/92/24279e68072801148f86236fb0fcd82eb7c40cca336934c6d31dc410696a.php : 317 -> get_product_listing ↳templates/include/html_helper.php : 178 -> ProductCategoryMaster::get_category_product_list ↳model/ProductCategoryMaster.php : 150 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
42 . SELECT (SELECT pp.sort_order FROM product_category p LEFT JOIN product_category_description ON p.parent_id=product_category_description.category_id INNER JOIN product_category pp ON pp.category_id = p.parent_id AND pp.status = '1' WHERE product_category_description.category_id=product_category.parent_id AND product_category_description.site_language_id = 1 GROUP BY products.products_id ORDER BY product_category.sort_order ASC) AS group_srt, product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value, (SELECT product_category_description.category_name FROM product_category_description LEFT JOIN product_category p ON p.parent_id=product_category_description.category_id INNER JOIN product_category pp ON pp.category_id = p.parent_id AND pp.status = '1'WHERE product_category_description.category_id=product_category.parent_id AND product_category_description.site_language_id = 1 GROUP BY products.products_id ORDER BY product_category.sort_order ASC) AS group_name FROM products LEFT JOIN product_store ON product_store.product_id = products.products_id LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND product_store.store_id = 2 ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC, products.products_id ASC 0.0006 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 57 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_536c6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc::doDisplay ↳cache/53/6c/6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc.php : 115 -> get_menu_links ↳templates/include/html_helper.php : 120 -> Twig_Environment::render (header_menu.block ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_a29224279e68072801148f86236fb0fcd82eb7c40cca336934c6d31dc410696a::doDisplay ↳cache/a2/92/24279e68072801148f86236fb0fcd82eb7c40cca336934c6d31dc410696a.php : 317 -> get_product_listing ↳templates/include/html_helper.php : 223 -> ProductCategoryMaster::get_group_category_list ↳model/ProductCategoryMaster.php : 206 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
43 . SELECT product_category.category_id,product_category.category_pro_enable,product_category.category_pro_pattern,product_category_description.category_promotional_text FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id WHERE product_category.status = '1' AND product_category.parent_id = '0' AND product_category_description.site_language_id = 1 0.0003 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 57 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_536c6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc::doDisplay ↳cache/53/6c/6ca6b10d27024688d774346c7caa195bd5012a0c9cf2d3597ae97a5a9dfc.php : 115 -> get_menu_links ↳templates/include/html_helper.php : 120 -> Twig_Environment::render (header_menu.block ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_a29224279e68072801148f86236fb0fcd82eb7c40cca336934c6d31dc410696a::doDisplay ↳cache/a2/92/24279e68072801148f86236fb0fcd82eb7c40cca336934c6d31dc410696a.php : 317 -> get_product_listing ↳templates/include/html_helper.php : 236 -> ProductCategoryMaster::get_group_list ↳model/ProductCategoryMaster.php : 220 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
Render > product_category_group.block Array
(
[twd] => Array
(
[product_count] => 83
[FArray] => Array
(
[0] => product_info.php
[1] => product_design_upload.php
[2] => product_designs.php
[3] => corporate_products.php
)
[productCategoryDetails] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT product_category.category_id, product_category.category_pro_enable, product_category_description.category_name, product_category_description.category_promotional_text, products.products_id, products.category_id as cat_id, products.predefined_product_type, products_description.products_title, products_description.product_promotional_text, product_settings.setting_constant_name, product_settings.setting_value FROM products LEFT JOIN product_store ON product_store.product_id = products.products_id LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :product_category_description_site_language_id) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = :products_description_site_language_id) WHERE product_category.status = :product_category_status AND products.visible = :products_visible_2 AND products.products_id != :products_id_quote AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) AND product_store.store_id = :store_id ORDER BY product_category.sort_order ASC, product_category.category_id ASC, products.sort_order ASC, products.products_id ASC
)
[AffectedRows:RDataRecordSet:private] => 83
[RecordCount] => 83
[foundRows] => -1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 1
[category_pro_enable] => 1
[category_name] => Business Cards
[category_promotional_text] =>
[products_id] => 1
[cat_id] => 1
[predefined_product_type] => 0
[products_title] => Standard Business Cards
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 1
[category_pro_enable] => 1
[category_name] => Business Cards
[category_promotional_text] =>
[products_id] => 116
[cat_id] => 1
[predefined_product_type] => 0
[products_title] => Rounded Business Cards
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 66
[category_pro_enable] => 0
[category_name] => Event Tent
[category_promotional_text] =>
[products_id] => 211
[cat_id] => 66
[predefined_product_type] => 0
[products_title] => Event Tent - (full color)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[3] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 66
[category_pro_enable] => 0
[category_name] => Event Tent
[category_promotional_text] =>
[products_id] => 212
[cat_id] => 66
[predefined_product_type] => 0
[products_title] => Tent Half Wall (Full Color)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[4] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 66
[category_pro_enable] => 0
[category_name] => Event Tent
[category_promotional_text] =>
[products_id] => 213
[cat_id] => 66
[predefined_product_type] => 0
[products_title] => Tent Full Wall - (full Color)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[5] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 66
[category_pro_enable] => 0
[category_name] => Event Tent
[category_promotional_text] =>
[products_id] => 214
[cat_id] => 66
[predefined_product_type] => 0
[products_title] => Tent Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[6] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 217
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Tritic Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[7] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 218
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Natural Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[8] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 219
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Suede Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[9] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 221
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Foil Matte Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[10] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 222
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Foil and Silk Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[11] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 223
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Foil, Spot UV and Silk Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[12] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 224
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Silk with Colored Edge
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[13] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 225
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Kraft Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[14] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 226
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Linen Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[15] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 227
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Natural White Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[16] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 228
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Weevi Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[17] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 229
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Sparkli Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[18] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 230
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Wrinkli Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[19] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 231
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Smoothi Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[20] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 232
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Softi Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[21] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 240
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Woodi Eastern Red Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[22] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 241
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Woodi Birdseye Maple Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[23] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 242
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Woodi Curly Maple Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[24] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 243
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Silk Laminated Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[25] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 75
[category_pro_enable] => 0
[category_name] => Premium Series
[category_promotional_text] =>
[products_id] => 244
[cat_id] => 75
[predefined_product_type] => 0
[products_title] => Silk and Spot UV Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[26] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 101
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Letterhead
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[27] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 140
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Envelopes Full Color
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[28] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 141
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Envelopes One Color
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[29] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 100
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Notepads
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[30] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 107
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Presentation Folders
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[31] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 150
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Carbonless Books 25
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[32] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 152
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Carbonless Books 50
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[33] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 149
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Carbonless Sets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[34] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 82
[category_pro_enable] => 0
[category_name] => Stationery
[category_promotional_text] =>
[products_id] => 160
[cat_id] => 82
[predefined_product_type] => 0
[products_title] => Folded Stationery
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[35] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 106
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Postcards
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[36] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 95
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Brochures
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[37] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 102
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Sale Sheets - (text stock)
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[38] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 119
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Sale Sheets - (cardstock)
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[39] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 94
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Rack Cards
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[40] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 115
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Door Hangers
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[41] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 148
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Bookmarks
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[42] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 143
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Flyers - (text stock)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[43] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 144
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Flyers - (cardstock)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[44] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 147
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Posters - (text stock)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[45] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 146
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Posters - (cardstock)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[46] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 170
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Tickets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[47] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 138
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Calendars
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[48] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 83
[category_pro_enable] => 0
[category_name] => Marketing Materials
[category_promotional_text] =>
[products_id] => 133
[cat_id] => 83
[predefined_product_type] => 0
[products_title] => Booklets & Catalogs
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[49] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 84
[category_pro_enable] => 0
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[products_id] => 163
[cat_id] => 84
[predefined_product_type] => 0
[products_title] => Square Hang Tags
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[50] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 84
[category_pro_enable] => 0
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[products_id] => 165
[cat_id] => 84
[predefined_product_type] => 0
[products_title] => Circular Hang Tags
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[51] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 84
[category_pro_enable] => 0
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[products_id] => 145
[cat_id] => 84
[predefined_product_type] => 0
[products_title] => Name Tags
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[52] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 84
[category_pro_enable] => 0
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[products_id] => 158
[cat_id] => 84
[predefined_product_type] => 0
[products_title] => Square Stickers
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[53] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 84
[category_pro_enable] => 0
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[products_id] => 169
[cat_id] => 84
[predefined_product_type] => 0
[products_title] => Round Stickers
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[54] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 85
[category_pro_enable] => 0
[category_name] => Restaurants
[category_promotional_text] =>
[products_id] => 118
[cat_id] => 85
[predefined_product_type] => 0
[products_title] => Take Out Menu
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[55] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 85
[category_pro_enable] => 0
[category_name] => Restaurants
[category_promotional_text] =>
[products_id] => 142
[cat_id] => 85
[predefined_product_type] => 0
[products_title] => Table Tents
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[56] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 86
[category_pro_enable] => 0
[category_name] => CD & DVD Products
[category_promotional_text] =>
[products_id] => 156
[cat_id] => 86
[predefined_product_type] => 0
[products_title] => CD & DVD Covers
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[57] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 86
[category_pro_enable] => 0
[category_name] => CD & DVD Products
[category_promotional_text] =>
[products_id] => 157
[cat_id] => 86
[predefined_product_type] => 0
[products_title] => DVD Booklets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[58] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 87
[category_pro_enable] => 0
[category_name] => Invitations
[category_promotional_text] =>
[products_id] => 139
[cat_id] => 87
[predefined_product_type] => 0
[products_title] => Invitations
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[59] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 87
[category_pro_enable] => 0
[category_name] => Invitations
[category_promotional_text] =>
[products_id] => 137
[cat_id] => 87
[predefined_product_type] => 0
[products_title] => Greeting Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[60] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 89
[category_pro_enable] => 0
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[products_id] => 196
[cat_id] => 89
[predefined_product_type] => 0
[products_title] => Acrylic Prints
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[61] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 89
[category_pro_enable] => 0
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[products_id] => 154
[cat_id] => 89
[predefined_product_type] => 0
[products_title] => Square Canvas
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[62] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 89
[category_pro_enable] => 0
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[products_id] => 151
[cat_id] => 89
[predefined_product_type] => 0
[products_title] => Standard Canvas
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[63] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 89
[category_pro_enable] => 0
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[products_id] => 153
[cat_id] => 89
[predefined_product_type] => 0
[products_title] => Panoramic Canvas
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[64] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 89
[category_pro_enable] => 0
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[products_id] => 192
[cat_id] => 89
[predefined_product_type] => 0
[products_title] => Framed Prints
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[65] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 89
[category_pro_enable] => 0
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[products_id] => 193
[cat_id] => 89
[predefined_product_type] => 0
[products_title] => Floating Frame
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[66] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 65
[category_pro_enable] => 0
[category_name] => Trade Show Products-Straight
[category_promotional_text] =>
[products_id] => 208
[cat_id] => 65
[predefined_product_type] => 0
[products_title] => Tension Fabric Display - (straight)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[67] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 65
[category_pro_enable] => 0
[category_name] => Trade Show Products-Straight
[category_promotional_text] =>
[products_id] => 210
[cat_id] => 65
[predefined_product_type] => 0
[products_title] => Velcro Pop Up Display - (straight)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[68] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 58
[category_pro_enable] => 0
[category_name] => Standard Banner Stands
[category_promotional_text] =>
[products_id] => 175
[cat_id] => 58
[predefined_product_type] => 0
[products_title] => X-Stand
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[69] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 58
[category_pro_enable] => 0
[category_name] => Standard Banner Stands
[category_promotional_text] =>
[products_id] => 172
[cat_id] => 58
[predefined_product_type] => 0
[products_title] => Standard Retractable
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[70] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 50
[category_pro_enable] => 0
[category_name] => Deluxe Banner Stands
[category_promotional_text] =>
[products_id] => 176
[cat_id] => 50
[predefined_product_type] => 0
[products_title] => L Stand
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[71] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 50
[category_pro_enable] => 0
[category_name] => Deluxe Banner Stands
[category_promotional_text] =>
[products_id] => 171
[cat_id] => 50
[predefined_product_type] => 0
[products_title] => Deluxe Retractable
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[72] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 50
[category_pro_enable] => 0
[category_name] => Deluxe Banner Stands
[category_promotional_text] =>
[products_id] => 173
[cat_id] => 50
[predefined_product_type] => 0
[products_title] => SD Retractable - (silver)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[73] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 54
[category_pro_enable] => 0
[category_name] => Advertising Flags
[category_promotional_text] =>
[products_id] => 183
[cat_id] => 54
[predefined_product_type] => 0
[products_title] => Econo Feather Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[74] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 54
[category_pro_enable] => 0
[category_name] => Advertising Flags
[category_promotional_text] =>
[products_id] => 187
[cat_id] => 54
[predefined_product_type] => 0
[products_title] => Rectangular Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[75] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 54
[category_pro_enable] => 0
[category_name] => Advertising Flags
[category_promotional_text] =>
[products_id] => 186
[cat_id] => 54
[predefined_product_type] => 0
[products_title] => Feather Angled Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[76] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 54
[category_pro_enable] => 0
[category_name] => Advertising Flags
[category_promotional_text] =>
[products_id] => 184
[cat_id] => 54
[predefined_product_type] => 0
[products_title] => Teardrop Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[77] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 59
[category_pro_enable] => 0
[category_name] => Significade A-Frame
[category_promotional_text] =>
[products_id] => 194
[cat_id] => 59
[predefined_product_type] => 0
[products_title] => Signicade A-frame
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[78] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 59
[category_pro_enable] => 0
[category_name] => Significade A-Frame
[category_promotional_text] =>
[products_id] => 195
[cat_id] => 59
[predefined_product_type] => 0
[products_title] => Signicade Deluxe A-Frame
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[79] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 55
[category_pro_enable] => 0
[category_name] => Table Throw
[category_promotional_text] =>
[products_id] => 190
[cat_id] => 55
[predefined_product_type] => 0
[products_title] => 6' Ft Table Cover
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[80] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 55
[category_pro_enable] => 0
[category_name] => Table Throw
[category_promotional_text] =>
[products_id] => 191
[cat_id] => 55
[predefined_product_type] => 0
[products_title] => 8' Ft Table Cover
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[81] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 8
[category_pro_enable] => 1
[category_name] => Design Services
[category_promotional_text] =>
[products_id] => 91
[cat_id] => 8
[predefined_product_type] => 1
[products_title] => Design Services
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => yes
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
[82] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_id] => 51
[category_pro_enable] => 0
[category_name] => Step and Repeat Banners
[category_promotional_text] =>
[products_id] => 177
[cat_id] => 51
[predefined_product_type] => 0
[products_title] => Step & Repeat Banner
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
)
[_IteratorKeys:protected] => Array
(
[0] => category_id
[1] => category_pro_enable
[2] => category_name
[3] => category_promotional_text
[4] => products_id
[5] => cat_id
[6] => predefined_product_type
[7] => products_title
[8] => product_promotional_text
[9] => setting_constant_name
[10] => setting_value
)
)
)
[IteratorCount:RDataRecordSet:private] => 83
[last_query] => SELECT product_category.category_id, product_category.category_pro_enable, product_category_description.category_name, product_category_description.category_promotional_text, products.products_id, products.category_id as cat_id, products.predefined_product_type, products_description.products_title, products_description.product_promotional_text, product_settings.setting_constant_name, product_settings.setting_value FROM products LEFT JOIN product_store ON product_store.product_id = products.products_id LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND product_store.store_id = 2 ORDER BY product_category.sort_order ASC, product_category.category_id ASC, products.sort_order ASC, products.products_id ASC
)
[CATEGORY_LAYOUT_ENABLED] => toggle
[category_product] => Array
(
[1] => Array
(
[category_name] => Business Cards
[cat_enable] => 1
[cat_pro_text] =>
[products] => Array
(
[1] => Array
(
[pname] => Standard Business Cards
[pro_enable] => no
[pro_title] =>
[cat_id] => 1
)
[116] => Array
(
[pname] => Rounded Business Cards
[pro_enable] => no
[pro_title] =>
[cat_id] => 1
)
)
)
[66] => Array
(
[category_name] => Event Tent
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[211] => Array
(
[pname] => Event Tent - (full color)
[pro_enable] =>
[pro_title] =>
[cat_id] => 66
)
[212] => Array
(
[pname] => Tent Half Wall (Full Color)
[pro_enable] =>
[pro_title] =>
[cat_id] => 66
)
[213] => Array
(
[pname] => Tent Full Wall - (full Color)
[pro_enable] =>
[pro_title] =>
[cat_id] => 66
)
[214] => Array
(
[pname] => Tent Flag
[pro_enable] =>
[pro_title] =>
[cat_id] => 66
)
)
)
[75] => Array
(
[category_name] => Premium Series
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[217] => Array
(
[pname] => Tritic Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[218] => Array
(
[pname] => Natural Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[219] => Array
(
[pname] => Suede Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[221] => Array
(
[pname] => Foil Matte Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[222] => Array
(
[pname] => Foil and Silk Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[223] => Array
(
[pname] => Foil, Spot UV and Silk Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[224] => Array
(
[pname] => Silk with Colored Edge
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[225] => Array
(
[pname] => Kraft Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[226] => Array
(
[pname] => Linen Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[227] => Array
(
[pname] => Natural White Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[228] => Array
(
[pname] => Weevi Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[229] => Array
(
[pname] => Sparkli Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[230] => Array
(
[pname] => Wrinkli Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[231] => Array
(
[pname] => Smoothi Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[232] => Array
(
[pname] => Softi Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[240] => Array
(
[pname] => Woodi Eastern Red Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[241] => Array
(
[pname] => Woodi Birdseye Maple Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[242] => Array
(
[pname] => Woodi Curly Maple Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[243] => Array
(
[pname] => Silk Laminated Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
[244] => Array
(
[pname] => Silk and Spot UV Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 75
)
)
)
[82] => Array
(
[category_name] => Stationery
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[101] => Array
(
[pname] => Letterhead
[pro_enable] => no
[pro_title] =>
[cat_id] => 82
)
[140] => Array
(
[pname] => Envelopes Full Color
[pro_enable] =>
[pro_title] =>
[cat_id] => 82
)
[141] => Array
(
[pname] => Envelopes One Color
[pro_enable] =>
[pro_title] =>
[cat_id] => 82
)
[100] => Array
(
[pname] => Notepads
[pro_enable] => no
[pro_title] =>
[cat_id] => 82
)
[107] => Array
(
[pname] => Presentation Folders
[pro_enable] => no
[pro_title] =>
[cat_id] => 82
)
[150] => Array
(
[pname] => Carbonless Books 25
[pro_enable] =>
[pro_title] =>
[cat_id] => 82
)
[152] => Array
(
[pname] => Carbonless Books 50
[pro_enable] =>
[pro_title] =>
[cat_id] => 82
)
[149] => Array
(
[pname] => Carbonless Sets
[pro_enable] =>
[pro_title] =>
[cat_id] => 82
)
[160] => Array
(
[pname] => Folded Stationery
[pro_enable] =>
[pro_title] =>
[cat_id] => 82
)
)
)
[83] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[106] => Array
(
[pname] => Postcards
[pro_enable] => no
[pro_title] =>
[cat_id] => 83
)
[95] => Array
(
[pname] => Brochures
[pro_enable] => no
[pro_title] =>
[cat_id] => 83
)
[102] => Array
(
[pname] => Sale Sheets - (text stock)
[pro_enable] => no
[pro_title] =>
[cat_id] => 83
)
[119] => Array
(
[pname] => Sale Sheets - (cardstock)
[pro_enable] => no
[pro_title] =>
[cat_id] => 83
)
[94] => Array
(
[pname] => Rack Cards
[pro_enable] => no
[pro_title] =>
[cat_id] => 83
)
[115] => Array
(
[pname] => Door Hangers
[pro_enable] => no
[pro_title] =>
[cat_id] => 83
)
[148] => Array
(
[pname] => Bookmarks
[pro_enable] =>
[pro_title] =>
[cat_id] => 83
)
[143] => Array
(
[pname] => Flyers - (text stock)
[pro_enable] =>
[pro_title] =>
[cat_id] => 83
)
[144] => Array
(
[pname] => Flyers - (cardstock)
[pro_enable] =>
[pro_title] =>
[cat_id] => 83
)
[147] => Array
(
[pname] => Posters - (text stock)
[pro_enable] =>
[pro_title] =>
[cat_id] => 83
)
[146] => Array
(
[pname] => Posters - (cardstock)
[pro_enable] =>
[pro_title] =>
[cat_id] => 83
)
[170] => Array
(
[pname] => Tickets
[pro_enable] =>
[pro_title] =>
[cat_id] => 83
)
[138] => Array
(
[pname] => Calendars
[pro_enable] =>
[pro_title] =>
[cat_id] => 83
)
[133] => Array
(
[pname] => Booklets & Catalogs
[pro_enable] =>
[pro_title] =>
[cat_id] => 83
)
)
)
[84] => Array
(
[category_name] => Stickers & Hang Tags
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[163] => Array
(
[pname] => Square Hang Tags
[pro_enable] =>
[pro_title] =>
[cat_id] => 84
)
[165] => Array
(
[pname] => Circular Hang Tags
[pro_enable] =>
[pro_title] =>
[cat_id] => 84
)
[145] => Array
(
[pname] => Name Tags
[pro_enable] =>
[pro_title] =>
[cat_id] => 84
)
[158] => Array
(
[pname] => Square Stickers
[pro_enable] =>
[pro_title] =>
[cat_id] => 84
)
[169] => Array
(
[pname] => Round Stickers
[pro_enable] =>
[pro_title] =>
[cat_id] => 84
)
)
)
[85] => Array
(
[category_name] => Restaurants
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[118] => Array
(
[pname] => Take Out Menu
[pro_enable] => no
[pro_title] =>
[cat_id] => 85
)
[142] => Array
(
[pname] => Table Tents
[pro_enable] =>
[pro_title] =>
[cat_id] => 85
)
)
)
[86] => Array
(
[category_name] => CD & DVD Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[156] => Array
(
[pname] => CD & DVD Covers
[pro_enable] =>
[pro_title] =>
[cat_id] => 86
)
[157] => Array
(
[pname] => DVD Booklets
[pro_enable] =>
[pro_title] =>
[cat_id] => 86
)
)
)
[87] => Array
(
[category_name] => Invitations
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[139] => Array
(
[pname] => Invitations
[pro_enable] =>
[pro_title] =>
[cat_id] => 87
)
[137] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 87
)
)
)
[89] => Array
(
[category_name] => Canvas & Photo Prints
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[196] => Array
(
[pname] => Acrylic Prints
[pro_enable] =>
[pro_title] =>
[cat_id] => 89
)
[154] => Array
(
[pname] => Square Canvas
[pro_enable] => no
[pro_title] =>
[cat_id] => 89
)
[151] => Array
(
[pname] => Standard Canvas
[pro_enable] =>
[pro_title] =>
[cat_id] => 89
)
[153] => Array
(
[pname] => Panoramic Canvas
[pro_enable] =>
[pro_title] =>
[cat_id] => 89
)
[192] => Array
(
[pname] => Framed Prints
[pro_enable] =>
[pro_title] =>
[cat_id] => 89
)
[193] => Array
(
[pname] => Floating Frame
[pro_enable] =>
[pro_title] =>
[cat_id] => 89
)
)
)
[65] => Array
(
[category_name] => Trade Show Products-Straight
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[208] => Array
(
[pname] => Tension Fabric Display - (straight)
[pro_enable] =>
[pro_title] =>
[cat_id] => 65
)
[210] => Array
(
[pname] => Velcro Pop Up Display - (straight)
[pro_enable] =>
[pro_title] =>
[cat_id] => 65
)
)
)
[58] => Array
(
[category_name] => Standard Banner Stands
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[175] => Array
(
[pname] => X-Stand
[pro_enable] =>
[pro_title] =>
[cat_id] => 58
)
[172] => Array
(
[pname] => Standard Retractable
[pro_enable] => no
[pro_title] =>
[cat_id] => 58
)
)
)
[50] => Array
(
[category_name] => Deluxe Banner Stands
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[176] => Array
(
[pname] => L Stand
[pro_enable] =>
[pro_title] =>
[cat_id] => 50
)
[171] => Array
(
[pname] => Deluxe Retractable
[pro_enable] =>
[pro_title] =>
[cat_id] => 50
)
[173] => Array
(
[pname] => SD Retractable - (silver)
[pro_enable] =>
[pro_title] =>
[cat_id] => 50
)
)
)
[54] => Array
(
[category_name] => Advertising Flags
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[183] => Array
(
[pname] => Econo Feather Flag
[pro_enable] =>
[pro_title] =>
[cat_id] => 54
)
[187] => Array
(
[pname] => Rectangular Flag
[pro_enable] =>
[pro_title] =>
[cat_id] => 54
)
[186] => Array
(
[pname] => Feather Angled Flag
[pro_enable] =>
[pro_title] =>
[cat_id] => 54
)
[184] => Array
(
[pname] => Teardrop Flag
[pro_enable] =>
[pro_title] =>
[cat_id] => 54
)
)
)
[59] => Array
(
[category_name] => Significade A-Frame
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[194] => Array
(
[pname] => Signicade A-frame
[pro_enable] =>
[pro_title] =>
[cat_id] => 59
)
[195] => Array
(
[pname] => Signicade Deluxe A-Frame
[pro_enable] =>
[pro_title] =>
[cat_id] => 59
)
)
)
[55] => Array
(
[category_name] => Table Throw
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[190] => Array
(
[pname] => 6' Ft Table Cover
[pro_enable] =>
[pro_title] =>
[cat_id] => 55
)
[191] => Array
(
[pname] => 8' Ft Table Cover
[pro_enable] =>
[pro_title] =>
[cat_id] => 55
)
)
)
[8] => Array
(
[category_name] => Design Services
[cat_enable] => 1
[cat_pro_text] =>
[products] => Array
(
[91] => Array
(
[pname] => Design Services
[pro_enable] => yes
[pro_title] =>
[cat_id] => 8
)
)
)
[51] => Array
(
[category_name] => Step and Repeat Banners
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[177] => Array
(
[pname] => Step & Repeat Banner
[pro_enable] =>
[pro_title] =>
[cat_id] => 51
)
)
)
)
[selected_category] =>
[allgroupcategorys] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT (SELECT pp.sort_order FROM product_category p LEFT JOIN product_category_description ON p.parent_id=product_category_description.category_id INNER JOIN product_category pp ON pp.category_id = p.parent_id AND pp.status = '1' WHERE product_category_description.category_id=product_category.parent_id AND product_category_description.site_language_id = 1 GROUP BY products.products_id ORDER BY product_category.sort_order ASC) AS group_srt, product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value, (SELECT product_category_description.category_name FROM product_category_description
LEFT JOIN product_category p ON p.parent_id=product_category_description.category_id
INNER JOIN product_category pp ON pp.category_id = p.parent_id AND pp.status = '1'
WHERE product_category_description.category_id=product_category.parent_id AND product_category_description.site_language_id = :product_category_description_site_language_id GROUP BY products.products_id ORDER BY product_category.sort_order ASC) AS group_name FROM products LEFT JOIN product_store ON product_store.product_id = products.products_id LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :pcd_site_language_id) LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = :products_description_site_language_id) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = :product_category_status AND products.visible = :products_visible_2 AND products.products_id != :products_id_quote AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) AND product_store.store_id = :store_id ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC, products.products_id ASC
)
[AffectedRows:RDataRecordSet:private] => 83
[RecordCount] => 83
[foundRows] => -1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 1
[category_pro_enable] => 1
[multiple_category] =>
[category_name] => Business Cards
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 1
[predefined_product_type] => 0
[products_title] => Standard Business Cards
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 1
[category_pro_enable] => 1
[multiple_category] =>
[category_name] => Business Cards
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 116
[predefined_product_type] => 0
[products_title] => Rounded Business Cards
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 101
[predefined_product_type] => 0
[products_title] => Letterhead
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[3] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 140
[predefined_product_type] => 0
[products_title] => Envelopes Full Color
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[4] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 141
[predefined_product_type] => 0
[products_title] => Envelopes One Color
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[5] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 100
[predefined_product_type] => 0
[products_title] => Notepads
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[6] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 107
[predefined_product_type] => 0
[products_title] => Presentation Folders
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[7] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 150
[predefined_product_type] => 0
[products_title] => Carbonless Books 25
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[8] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 152
[predefined_product_type] => 0
[products_title] => Carbonless Books 50
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[9] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 149
[predefined_product_type] => 0
[products_title] => Carbonless Sets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[10] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 82
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stationery
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 160
[predefined_product_type] => 0
[products_title] => Folded Stationery
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[11] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 106
[predefined_product_type] => 0
[products_title] => Postcards
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[12] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 95
[predefined_product_type] => 0
[products_title] => Brochures
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[13] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 102
[predefined_product_type] => 0
[products_title] => Sale Sheets - (text stock)
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[14] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 119
[predefined_product_type] => 0
[products_title] => Sale Sheets - (cardstock)
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[15] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 94
[predefined_product_type] => 0
[products_title] => Rack Cards
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[16] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 115
[predefined_product_type] => 0
[products_title] => Door Hangers
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[17] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 148
[predefined_product_type] => 0
[products_title] => Bookmarks
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[18] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 143
[predefined_product_type] => 0
[products_title] => Flyers - (text stock)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[19] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 144
[predefined_product_type] => 0
[products_title] => Flyers - (cardstock)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[20] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 147
[predefined_product_type] => 0
[products_title] => Posters - (text stock)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[21] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 146
[predefined_product_type] => 0
[products_title] => Posters - (cardstock)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[22] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 170
[predefined_product_type] => 0
[products_title] => Tickets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[23] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 138
[predefined_product_type] => 0
[products_title] => Calendars
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[24] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 83
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 133
[predefined_product_type] => 0
[products_title] => Booklets & Catalogs
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[25] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 84
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 163
[predefined_product_type] => 0
[products_title] => Square Hang Tags
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[26] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 84
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 165
[predefined_product_type] => 0
[products_title] => Circular Hang Tags
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[27] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 84
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 145
[predefined_product_type] => 0
[products_title] => Name Tags
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[28] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 84
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 158
[predefined_product_type] => 0
[products_title] => Square Stickers
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[29] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 84
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Stickers & Hang Tags
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 169
[predefined_product_type] => 0
[products_title] => Round Stickers
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[30] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 85
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Restaurants
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 118
[predefined_product_type] => 0
[products_title] => Take Out Menu
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[31] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 85
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Restaurants
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 142
[predefined_product_type] => 0
[products_title] => Table Tents
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[32] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 86
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => CD & DVD Products
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 156
[predefined_product_type] => 0
[products_title] => CD & DVD Covers
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[33] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 86
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => CD & DVD Products
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 157
[predefined_product_type] => 0
[products_title] => DVD Booklets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[34] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 87
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Invitations
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 139
[predefined_product_type] => 0
[products_title] => Invitations
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[35] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 87
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Invitations
[category_promotional_text] =>
[parent_id] => 25
[products_id] => 137
[predefined_product_type] => 0
[products_title] => Greeting Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Standard Printing Products
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[36] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 217
[predefined_product_type] => 0
[products_title] => Tritic Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[37] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 218
[predefined_product_type] => 0
[products_title] => Natural Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[38] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 219
[predefined_product_type] => 0
[products_title] => Suede Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[39] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 221
[predefined_product_type] => 0
[products_title] => Foil Matte Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[40] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 222
[predefined_product_type] => 0
[products_title] => Foil and Silk Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[41] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 223
[predefined_product_type] => 0
[products_title] => Foil, Spot UV and Silk Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[42] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 224
[predefined_product_type] => 0
[products_title] => Silk with Colored Edge
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[43] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 225
[predefined_product_type] => 0
[products_title] => Kraft Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[44] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 226
[predefined_product_type] => 0
[products_title] => Linen Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[45] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 227
[predefined_product_type] => 0
[products_title] => Natural White Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[46] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 228
[predefined_product_type] => 0
[products_title] => Weevi Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[47] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 229
[predefined_product_type] => 0
[products_title] => Sparkli Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[48] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 230
[predefined_product_type] => 0
[products_title] => Wrinkli Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[49] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 231
[predefined_product_type] => 0
[products_title] => Smoothi Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[50] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 232
[predefined_product_type] => 0
[products_title] => Softi Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[51] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 240
[predefined_product_type] => 0
[products_title] => Woodi Eastern Red Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[52] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 241
[predefined_product_type] => 0
[products_title] => Woodi Birdseye Maple Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[53] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 242
[predefined_product_type] => 0
[products_title] => Woodi Curly Maple Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[54] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 243
[predefined_product_type] => 0
[products_title] => Silk Laminated Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[55] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 0
[category_id] => 75
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Premium Series
[category_promotional_text] =>
[parent_id] => 88
[products_id] => 244
[predefined_product_type] => 0
[products_title] => Silk and Spot UV Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Premium Series
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[56] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 66
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Event Tent
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 211
[predefined_product_type] => 0
[products_title] => Event Tent - (full color)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[57] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 66
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Event Tent
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 212
[predefined_product_type] => 0
[products_title] => Tent Half Wall (Full Color)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[58] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 66
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Event Tent
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 213
[predefined_product_type] => 0
[products_title] => Tent Full Wall - (full Color)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[59] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 66
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Event Tent
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 214
[predefined_product_type] => 0
[products_title] => Tent Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[60] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 89
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 196
[predefined_product_type] => 0
[products_title] => Acrylic Prints
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[61] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 89
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 154
[predefined_product_type] => 0
[products_title] => Square Canvas
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[62] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 89
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 151
[predefined_product_type] => 0
[products_title] => Standard Canvas
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[63] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 89
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 153
[predefined_product_type] => 0
[products_title] => Panoramic Canvas
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[64] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 89
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 192
[predefined_product_type] => 0
[products_title] => Framed Prints
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[65] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 89
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Canvas & Photo Prints
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 193
[predefined_product_type] => 0
[products_title] => Floating Frame
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[66] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 65
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Trade Show Products-Straight
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 208
[predefined_product_type] => 0
[products_title] => Tension Fabric Display - (straight)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[67] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 65
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Trade Show Products-Straight
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 210
[predefined_product_type] => 0
[products_title] => Velcro Pop Up Display - (straight)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[68] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 58
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Standard Banner Stands
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 175
[predefined_product_type] => 0
[products_title] => X-Stand
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[69] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 58
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Standard Banner Stands
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 172
[predefined_product_type] => 0
[products_title] => Standard Retractable
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[70] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 50
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Deluxe Banner Stands
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 176
[predefined_product_type] => 0
[products_title] => L Stand
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[71] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 50
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Deluxe Banner Stands
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 171
[predefined_product_type] => 0
[products_title] => Deluxe Retractable
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[72] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 50
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Deluxe Banner Stands
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 173
[predefined_product_type] => 0
[products_title] => SD Retractable - (silver)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[73] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 54
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Advertising Flags
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 183
[predefined_product_type] => 0
[products_title] => Econo Feather Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[74] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 54
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Advertising Flags
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 187
[predefined_product_type] => 0
[products_title] => Rectangular Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[75] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 54
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Advertising Flags
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 186
[predefined_product_type] => 0
[products_title] => Feather Angled Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[76] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 54
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Advertising Flags
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 184
[predefined_product_type] => 0
[products_title] => Teardrop Flag
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[77] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 59
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Significade A-Frame
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 194
[predefined_product_type] => 0
[products_title] => Signicade A-frame
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[78] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 59
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Significade A-Frame
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 195
[predefined_product_type] => 0
[products_title] => Signicade Deluxe A-Frame
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[79] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 55
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Table Throw
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 190
[predefined_product_type] => 0
[products_title] => 6' Ft Table Cover
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[80] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 55
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Table Throw
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 191
[predefined_product_type] => 0
[products_title] => 8' Ft Table Cover
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[81] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 7
[category_id] => 51
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Step and Repeat Banners
[category_promotional_text] =>
[parent_id] => 23
[products_id] => 177
[predefined_product_type] => 0
[products_title] => Step & Repeat Banner
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] => Signs and Banners
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
[82] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] => 8
[category_id] => 8
[category_pro_enable] => 1
[multiple_category] =>
[category_name] => Design Services
[category_promotional_text] =>
[parent_id] => 28
[products_id] => 91
[predefined_product_type] => 1
[products_title] => Design Services
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => yes
[group_name] => Design Services
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => category_id
[2] => category_pro_enable
[3] => multiple_category
[4] => category_name
[5] => category_promotional_text
[6] => parent_id
[7] => products_id
[8] => predefined_product_type
[9] => products_title
[10] => product_promotional_text
[11] => setting_constant_name
[12] => setting_value
[13] => group_name
)
)
)
[IteratorCount:RDataRecordSet:private] => 83
[last_query] => SELECT (SELECT pp.sort_order FROM product_category p LEFT JOIN product_category_description ON p.parent_id=product_category_description.category_id INNER JOIN product_category pp ON pp.category_id = p.parent_id AND pp.status = '1' WHERE product_category_description.category_id=product_category.parent_id AND product_category_description.site_language_id = 1 GROUP BY products.products_id ORDER BY product_category.sort_order ASC) AS group_srt, product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value, (SELECT product_category_description.category_name FROM product_category_description
LEFT JOIN product_category p ON p.parent_id=product_category_description.category_id
INNER JOIN product_category pp ON pp.category_id = p.parent_id AND pp.status = '1'
WHERE product_category_description.category_id=product_category.parent_id AND product_category_description.site_language_id = 1 GROUP BY products.products_id ORDER BY product_category.sort_order ASC) AS group_name FROM products LEFT JOIN product_store ON product_store.product_id = products.products_id LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND product_store.store_id = 2 ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC, products.products_id ASC
)
[group_categorys] => Array
(
[25] => Array
(
[group_name] => Standard Printing Products
[group_enable] => 0
[group_pro_text] =>
[groups] => Array
(
[1] => Array
(
[category_name] => Business Cards
[cat_enable] => 1
[cat_pro_text] =>
[products] => Array
(
[1] => Array
(
[pname] => Standard Business Cards
[pro_enable] => no
[pro_title] =>
)
[116] => Array
(
[pname] => Rounded Business Cards
[pro_enable] => no
[pro_title] =>
)
)
)
[82] => Array
(
[category_name] => Stationery
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[101] => Array
(
[pname] => Letterhead
[pro_enable] => no
[pro_title] =>
)
[140] => Array
(
[pname] => Envelopes Full Color
[pro_enable] =>
[pro_title] =>
)
[141] => Array
(
[pname] => Envelopes One Color
[pro_enable] =>
[pro_title] =>
)
[100] => Array
(
[pname] => Notepads
[pro_enable] => no
[pro_title] =>
)
[107] => Array
(
[pname] => Presentation Folders
[pro_enable] => no
[pro_title] =>
)
[150] => Array
(
[pname] => Carbonless Books 25
[pro_enable] =>
[pro_title] =>
)
[152] => Array
(
[pname] => Carbonless Books 50
[pro_enable] =>
[pro_title] =>
)
[149] => Array
(
[pname] => Carbonless Sets
[pro_enable] =>
[pro_title] =>
)
[160] => Array
(
[pname] => Folded Stationery
[pro_enable] =>
[pro_title] =>
)
)
)
[83] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[106] => Array
(
[pname] => Postcards
[pro_enable] => no
[pro_title] =>
)
[95] => Array
(
[pname] => Brochures
[pro_enable] => no
[pro_title] =>
)
[102] => Array
(
[pname] => Sale Sheets - (text stock)
[pro_enable] => no
[pro_title] =>
)
[119] => Array
(
[pname] => Sale Sheets - (cardstock)
[pro_enable] => no
[pro_title] =>
)
[94] => Array
(
[pname] => Rack Cards
[pro_enable] => no
[pro_title] =>
)
[115] => Array
(
[pname] => Door Hangers
[pro_enable] => no
[pro_title] =>
)
[148] => Array
(
[pname] => Bookmarks
[pro_enable] =>
[pro_title] =>
)
[143] => Array
(
[pname] => Flyers - (text stock)
[pro_enable] =>
[pro_title] =>
)
[144] => Array
(
[pname] => Flyers - (cardstock)
[pro_enable] =>
[pro_title] =>
)
[147] => Array
(
[pname] => Posters - (text stock)
[pro_enable] =>
[pro_title] =>
)
[146] => Array
(
[pname] => Posters - (cardstock)
[pro_enable] =>
[pro_title] =>
)
[170] => Array
(
[pname] => Tickets
[pro_enable] =>
[pro_title] =>
)
[138] => Array
(
[pname] => Calendars
[pro_enable] =>
[pro_title] =>
)
[133] => Array
(
[pname] => Booklets & Catalogs
[pro_enable] =>
[pro_title] =>
)
)
)
[84] => Array
(
[category_name] => Stickers & Hang Tags
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[163] => Array
(
[pname] => Square Hang Tags
[pro_enable] =>
[pro_title] =>
)
[165] => Array
(
[pname] => Circular Hang Tags
[pro_enable] =>
[pro_title] =>
)
[145] => Array
(
[pname] => Name Tags
[pro_enable] =>
[pro_title] =>
)
[158] => Array
(
[pname] => Square Stickers
[pro_enable] =>
[pro_title] =>
)
[169] => Array
(
[pname] => Round Stickers
[pro_enable] =>
[pro_title] =>
)
)
)
[85] => Array
(
[category_name] => Restaurants
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[118] => Array
(
[pname] => Take Out Menu
[pro_enable] => no
[pro_title] =>
)
[142] => Array
(
[pname] => Table Tents
[pro_enable] =>
[pro_title] =>
)
)
)
[86] => Array
(
[category_name] => CD & DVD Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[156] => Array
(
[pname] => CD & DVD Covers
[pro_enable] =>
[pro_title] =>
)
[157] => Array
(
[pname] => DVD Booklets
[pro_enable] =>
[pro_title] =>
)
)
)
[87] => Array
(
[category_name] => Invitations
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[139] => Array
(
[pname] => Invitations
[pro_enable] =>
[pro_title] =>
)
[137] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[88] => Array
(
[group_name] => Premium Series
[group_enable] => 0
[group_pro_text] =>
[groups] => Array
(
[75] => Array
(
[category_name] => Premium Series
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[217] => Array
(
[pname] => Tritic Cards
[pro_enable] =>
[pro_title] =>
)
[218] => Array
(
[pname] => Natural Cards
[pro_enable] =>
[pro_title] =>
)
[219] => Array
(
[pname] => Suede Cards
[pro_enable] =>
[pro_title] =>
)
[221] => Array
(
[pname] => Foil Matte Cards
[pro_enable] =>
[pro_title] =>
)
[222] => Array
(
[pname] => Foil and Silk Cards
[pro_enable] =>
[pro_title] =>
)
[223] => Array
(
[pname] => Foil, Spot UV and Silk Cards
[pro_enable] =>
[pro_title] =>
)
[224] => Array
(
[pname] => Silk with Colored Edge
[pro_enable] =>
[pro_title] =>
)
[225] => Array
(
[pname] => Kraft Cards
[pro_enable] =>
[pro_title] =>
)
[226] => Array
(
[pname] => Linen Cards
[pro_enable] =>
[pro_title] =>
)
[227] => Array
(
[pname] => Natural White Cards
[pro_enable] =>
[pro_title] =>
)
[228] => Array
(
[pname] => Weevi Cards
[pro_enable] =>
[pro_title] =>
)
[229] => Array
(
[pname] => Sparkli Cards
[pro_enable] =>
[pro_title] =>
)
[230] => Array
(
[pname] => Wrinkli Cards
[pro_enable] =>
[pro_title] =>
)
[231] => Array
(
[pname] => Smoothi Cards
[pro_enable] =>
[pro_title] =>
)
[232] => Array
(
[pname] => Softi Cards
[pro_enable] =>
[pro_title] =>
)
[240] => Array
(
[pname] => Woodi Eastern Red Cards
[pro_enable] =>
[pro_title] =>
)
[241] => Array
(
[pname] => Woodi Birdseye Maple Cards
[pro_enable] =>
[pro_title] =>
)
[242] => Array
(
[pname] => Woodi Curly Maple Cards
[pro_enable] =>
[pro_title] =>
)
[243] => Array
(
[pname] => Silk Laminated Cards
[pro_enable] =>
[pro_title] =>
)
[244] => Array
(
[pname] => Silk and Spot UV Cards
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[23] => Array
(
[group_name] => Signs and Banners
[group_enable] => 0
[group_pro_text] =>
[groups] => Array
(
[66] => Array
(
[category_name] => Event Tent
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[211] => Array
(
[pname] => Event Tent - (full color)
[pro_enable] =>
[pro_title] =>
)
[212] => Array
(
[pname] => Tent Half Wall (Full Color)
[pro_enable] =>
[pro_title] =>
)
[213] => Array
(
[pname] => Tent Full Wall - (full Color)
[pro_enable] =>
[pro_title] =>
)
[214] => Array
(
[pname] => Tent Flag
[pro_enable] =>
[pro_title] =>
)
)
)
[89] => Array
(
[category_name] => Canvas & Photo Prints
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[196] => Array
(
[pname] => Acrylic Prints
[pro_enable] =>
[pro_title] =>
)
[154] => Array
(
[pname] => Square Canvas
[pro_enable] => no
[pro_title] =>
)
[151] => Array
(
[pname] => Standard Canvas
[pro_enable] =>
[pro_title] =>
)
[153] => Array
(
[pname] => Panoramic Canvas
[pro_enable] =>
[pro_title] =>
)
[192] => Array
(
[pname] => Framed Prints
[pro_enable] =>
[pro_title] =>
)
[193] => Array
(
[pname] => Floating Frame
[pro_enable] =>
[pro_title] =>
)
)
)
[65] => Array
(
[category_name] => Trade Show Products-Straight
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[208] => Array
(
[pname] => Tension Fabric Display - (straight)
[pro_enable] =>
[pro_title] =>
)
[210] => Array
(
[pname] => Velcro Pop Up Display - (straight)
[pro_enable] =>
[pro_title] =>
)
)
)
[58] => Array
(
[category_name] => Standard Banner Stands
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[175] => Array
(
[pname] => X-Stand
[pro_enable] =>
[pro_title] =>
)
[172] => Array
(
[pname] => Standard Retractable
[pro_enable] => no
[pro_title] =>
)
)
)
[50] => Array
(
[category_name] => Deluxe Banner Stands
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[176] => Array
(
[pname] => L Stand
[pro_enable] =>
[pro_title] =>
)
[171] => Array
(
[pname] => Deluxe Retractable
[pro_enable] =>
[pro_title] =>
)
[173] => Array
(
[pname] => SD Retractable - (silver)
[pro_enable] =>
[pro_title] =>
)
)
)
[54] => Array
(
[category_name] => Advertising Flags
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[183] => Array
(
[pname] => Econo Feather Flag
[pro_enable] =>
[pro_title] =>
)
[187] => Array
(
[pname] => Rectangular Flag
[pro_enable] =>
[pro_title] =>
)
[186] => Array
(
[pname] => Feather Angled Flag
[pro_enable] =>
[pro_title] =>
)
[184] => Array
(
[pname] => Teardrop Flag
[pro_enable] =>
[pro_title] =>
)
)
)
[59] => Array
(
[category_name] => Significade A-Frame
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[194] => Array
(
[pname] => Signicade A-frame
[pro_enable] =>
[pro_title] =>
)
[195] => Array
(
[pname] => Signicade Deluxe A-Frame
[pro_enable] =>
[pro_title] =>
)
)
)
[55] => Array
(
[category_name] => Table Throw
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[190] => Array
(
[pname] => 6' Ft Table Cover
[pro_enable] =>
[pro_title] =>
)
[191] => Array
(
[pname] => 8' Ft Table Cover
[pro_enable] =>
[pro_title] =>
)
)
)
[51] => Array
(
[category_name] => Step and Repeat Banners
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[177] => Array
(
[pname] => Step & Repeat Banner
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[28] => Array
(
[group_name] => Design Services
[group_enable] => 0
[group_pro_text] =>
[groups] => Array
(
[8] => Array
(
[category_name] => Design Services
[cat_enable] => 1
[cat_pro_text] =>
[products] => Array
(
[91] => Array
(
[pname] => Design Services
[pro_enable] => yes
[pro_title] =>
)
)
)
)
)
)
[category_with_group] => Array
(
[25] => Array
(
[group_name] => Standard Printing Products
[group_enable] => 0
[group_pro_text] =>
[groups] => Array
(
[1] => Array
(
[category_name] => Business Cards
[cat_enable] => 1
[cat_pro_text] =>
[products] => Array
(
[1] => Array
(
[pname] => Standard Business Cards
[pro_enable] => no
[pro_title] =>
)
[116] => Array
(
[pname] => Rounded Business Cards
[pro_enable] => no
[pro_title] =>
)
)
)
[82] => Array
(
[category_name] => Stationery
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[101] => Array
(
[pname] => Letterhead
[pro_enable] => no
[pro_title] =>
)
[140] => Array
(
[pname] => Envelopes Full Color
[pro_enable] =>
[pro_title] =>
)
[141] => Array
(
[pname] => Envelopes One Color
[pro_enable] =>
[pro_title] =>
)
[100] => Array
(
[pname] => Notepads
[pro_enable] => no
[pro_title] =>
)
[107] => Array
(
[pname] => Presentation Folders
[pro_enable] => no
[pro_title] =>
)
[150] => Array
(
[pname] => Carbonless Books 25
[pro_enable] =>
[pro_title] =>
)
[152] => Array
(
[pname] => Carbonless Books 50
[pro_enable] =>
[pro_title] =>
)
[149] => Array
(
[pname] => Carbonless Sets
[pro_enable] =>
[pro_title] =>
)
[160] => Array
(
[pname] => Folded Stationery
[pro_enable] =>
[pro_title] =>
)
)
)
[83] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[106] => Array
(
[pname] => Postcards
[pro_enable] => no
[pro_title] =>
)
[95] => Array
(
[pname] => Brochures
[pro_enable] => no
[pro_title] =>
)
[102] => Array
(
[pname] => Sale Sheets - (text stock)
[pro_enable] => no
[pro_title] =>
)
[119] => Array
(
[pname] => Sale Sheets - (cardstock)
[pro_enable] => no
[pro_title] =>
)
[94] => Array
(
[pname] => Rack Cards
[pro_enable] => no
[pro_title] =>
)
[115] => Array
(
[pname] => Door Hangers
[pro_enable] => no
[pro_title] =>
)
[148] => Array
(
[pname] => Bookmarks
[pro_enable] =>
[pro_title] =>
)
[143] => Array
(
[pname] => Flyers - (text stock)
[pro_enable] =>
[pro_title] =>
)
[144] => Array
(
[pname] => Flyers - (cardstock)
[pro_enable] =>
[pro_title] =>
)
[147] => Array
(
[pname] => Posters - (text stock)
[pro_enable] =>
[pro_title] =>
)
[146] => Array
(
[pname] => Posters - (cardstock)
[pro_enable] =>
[pro_title] =>
)
[170] => Array
(
[pname] => Tickets
[pro_enable] =>
[pro_title] =>
)
[138] => Array
(
[pname] => Calendars
[pro_enable] =>
[pro_title] =>
)
[133] => Array
(
[pname] => Booklets & Catalogs
[pro_enable] =>
[pro_title] =>
)
)
)
[84] => Array
(
[category_name] => Stickers & Hang Tags
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[163] => Array
(
[pname] => Square Hang Tags
[pro_enable] =>
[pro_title] =>
)
[165] => Array
(
[pname] => Circular Hang Tags
[pro_enable] =>
[pro_title] =>
)
[145] => Array
(
[pname] => Name Tags
[pro_enable] =>
[pro_title] =>
)
[158] => Array
(
[pname] => Square Stickers
[pro_enable] =>
[pro_title] =>
)
[169] => Array
(
[pname] => Round Stickers
[pro_enable] =>
[pro_title] =>
)
)
)
[85] => Array
(
[category_name] => Restaurants
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[118] => Array
(
[pname] => Take Out Menu
[pro_enable] => no
[pro_title] =>
)
[142] => Array
(
[pname] => Table Tents
[pro_enable] =>
[pro_title] =>
)
)
)
[86] => Array
(
[category_name] => CD & DVD Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[156] => Array
(
[pname] => CD & DVD Covers
[pro_enable] =>
[pro_title] =>
)
[157] => Array
(
[pname] => DVD Booklets
[pro_enable] =>
[pro_title] =>
)
)
)
[87] => Array
(
[category_name] => Invitations
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[139] => Array
(
[pname] => Invitations
[pro_enable] =>
[pro_title] =>
)
[137] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[88] => Array
(
[group_name] => Premium Series
[group_enable] => 0
[group_pro_text] =>
[groups] => Array
(
[75] => Array
(
[category_name] => Premium Series
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[217] => Array
(
[pname] => Tritic Cards
[pro_enable] =>
[pro_title] =>
)
[218] => Array
(
[pname] => Natural Cards
[pro_enable] =>
[pro_title] =>
)
[219] => Array
(
[pname] => Suede Cards
[pro_enable] =>
[pro_title] =>
)
[221] => Array
(
[pname] => Foil Matte Cards
[pro_enable] =>
[pro_title] =>
)
[222] => Array
(
[pname] => Foil and Silk Cards
[pro_enable] =>
[pro_title] =>
)
[223] => Array
(
[pname] => Foil, Spot UV and Silk Cards
[pro_enable] =>
[pro_title] =>
)
[224] => Array
(
[pname] => Silk with Colored Edge
[pro_enable] =>
[pro_title] =>
)
[225] => Array
(
[pname] => Kraft Cards
[pro_enable] =>
[pro_title] =>
)
[226] => Array
(
[pname] => Linen Cards
[pro_enable] =>
[pro_title] =>
)
[227] => Array
(
[pname] => Natural White Cards
[pro_enable] =>
[pro_title] =>
)
[228] => Array
(
[pname] => Weevi Cards
[pro_enable] =>
[pro_title] =>
)
[229] => Array
(
[pname] => Sparkli Cards
[pro_enable] =>
[pro_title] =>
)
[230] => Array
(
[pname] => Wrinkli Cards
[pro_enable] =>
[pro_title] =>
)
[231] => Array
(
[pname] => Smoothi Cards
[pro_enable] =>
[pro_title] =>
)
[232] => Array
(
[pname] => Softi Cards
[pro_enable] =>
[pro_title] =>
)
[240] => Array
(
[pname] => Woodi Eastern Red Cards
[pro_enable] =>
[pro_title] =>
)
[241] => Array
(
[pname] => Woodi Birdseye Maple Cards
[pro_enable] =>
[pro_title] =>
)
[242] => Array
(
[pname] => Woodi Curly Maple Cards
[pro_enable] =>
[pro_title] =>
)
[243] => Array
(
[pname] => Silk Laminated Cards
[pro_enable] =>
[pro_title] =>
)
[244] => Array
(
[pname] => Silk and Spot UV Cards
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[23] => Array
(
[group_name] => Signs and Banners
[group_enable] => 0
[group_pro_text] =>
[groups] => Array
(
[66] => Array
(
[category_name] => Event Tent
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[211] => Array
(
[pname] => Event Tent - (full color)
[pro_enable] =>
[pro_title] =>
)
[212] => Array
(
[pname] => Tent Half Wall (Full Color)
[pro_enable] =>
[pro_title] =>
)
[213] => Array
(
[pname] => Tent Full Wall - (full Color)
[pro_enable] =>
[pro_title] =>
)
[214] => Array
(
[pname] => Tent Flag
[pro_enable] =>
[pro_title] =>
)
)
)
[89] => Array
(
[category_name] => Canvas & Photo Prints
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[196] => Array
(
[pname] => Acrylic Prints
[pro_enable] =>
[pro_title] =>
)
[154] => Array
(
[pname] => Square Canvas
[pro_enable] => no
[pro_title] =>
)
[151] => Array
(
[pname] => Standard Canvas
[pro_enable] =>
[pro_title] =>
)
[153] => Array
(
[pname] => Panoramic Canvas
[pro_enable] =>
[pro_title] =>
)
[192] => Array
(
[pname] => Framed Prints
[pro_enable] =>
[pro_title] =>
)
[193] => Array
(
[pname] => Floating Frame
[pro_enable] =>
[pro_title] =>
)
)
)
[65] => Array
(
[category_name] => Trade Show Products-Straight
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[208] => Array
(
[pname] => Tension Fabric Display - (straight)
[pro_enable] =>
[pro_title] =>
)
[210] => Array
(
[pname] => Velcro Pop Up Display - (straight)
[pro_enable] =>
[pro_title] =>
)
)
)
[58] => Array
(
[category_name] => Standard Banner Stands
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[175] => Array
(
[pname] => X-Stand
[pro_enable] =>
[pro_title] =>
)
[172] => Array
(
[pname] => Standard Retractable
[pro_enable] => no
[pro_title] =>
)
)
)
[50] => Array
(
[category_name] => Deluxe Banner Stands
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[176] => Array
(
[pname] => L Stand
[pro_enable] =>
[pro_title] =>
)
[171] => Array
(
[pname] => Deluxe Retractable
[pro_enable] =>
[pro_title] =>
)
[173] => Array
(
[pname] => SD Retractable - (silver)
[pro_enable] =>
[pro_title] =>
)
)
)
[54] => Array
(
[category_name] => Advertising Flags
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[183] => Array
(
[pname] => Econo Feather Flag
[pro_enable] =>
[pro_title] =>
)
[187] => Array
(
[pname] => Rectangular Flag
[pro_enable] =>
[pro_title] =>
)
[186] => Array
(
[pname] => Feather Angled Flag
[pro_enable] =>
[pro_title] =>
)
[184] => Array
(
[pname] => Teardrop Flag
[pro_enable] =>
[pro_title] =>
)
)
)
[59] => Array
(
[category_name] => Significade A-Frame
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[194] => Array
(
[pname] => Signicade A-frame
[pro_enable] =>
[pro_title] =>
)
[195] => Array
(
[pname] => Signicade Deluxe A-Frame
[pro_enable] =>
[pro_title] =>
)
)
)
[55] => Array
(
[category_name] => Table Throw
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[190] => Array
(
[pname] => 6' Ft Table Cover
[pro_enable] =>
[pro_title] =>
)
[191] => Array
(
[pname] => 8' Ft Table Cover
[pro_enable] =>
[pro_title] =>
)
)
)
[51] => Array
(
[category_name] => Step and Repeat Banners
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[177] => Array
(
[pname] => Step & Repeat Banner
[pro_enable] =>
[pro_title] =>
)
)
)
)
)
[28] => Array
(
[group_name] => Design Services
[group_enable] => 0
[group_pro_text] =>
[groups] => Array
(
[8] => Array
(
[category_name] => Design Services
[cat_enable] => 1
[cat_pro_text] =>
[products] => Array
(
[91] => Array
(
[pname] => Design Services
[pro_enable] => yes
[pro_title] =>
)
)
)
)
)
)
[category_without_group_name] => Array
(
)
[select_group] =>
[select_category_product] =>
)
)
44 . SELECT SQL_CALC_FOUND_ROWS banner_image.* FROM banner_image LEFT JOIN site_language ON site_language.site_language_id = banner_image.banner_language WHERE banner_image.corporate_id = 0 AND banner_image.banner_language IN ('1', '0') AND banner_image.status = '1' AND banner_image.page_url = 'cms.php?page=design-services' AND banner_image.store_id IN (0, 2) ORDER BY sort_order ASC 0.0003 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 62 -> top_banner ↳templates/include/html_helper.php : 814 -> BannerImageMaster::getBannerImage ↳model/BannerImageMaster.php : 121 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger
Array
(
[twd] => Array
(
[section] => top
[index_top_section_details] => 1
[banner_settings] => Array
(
[Submit] => Save
[bannerWidth] => auto
[bannerHeight] => auto
[autoStart] => 0
[timeout] => 8000
[showPrevNextLinks] => 0
[showPagerLinks] => 1
[bannerDescLeftPosition] => auto
[bannerDescTopPosition] => auto
[bannerEffect] => slide
)
[res_banner] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[banner_image_id] => 22
[store_id] => 0
[banner_image_name] => dsba30.jpg
[banner_link] =>
[open_target] => _blank
[banner_display] => 2
[sort_order] => 0
[status] => 1
[title] => Design Services
[banner_language] => 0
[corporate_id] => 0
[banner_text] =>
[page_url] => cms.php?page=design-services
[embed_code] =>
[menu_link_category] =>
[link_type_id] => 0
)
[_IteratorKeys:protected] => Array
(
[0] => banner_image_id
[1] => store_id
[2] => banner_image_name
[3] => banner_link
[4] => open_target
[5] => banner_display
[6] => sort_order
[7] => status
[8] => title
[9] => banner_language
[10] => corporate_id
[11] => banner_text
[12] => page_url
[13] => embed_code
[14] => menu_link_category
[15] => link_type_id
)
)
)
)
)
45 . SELECT site_seo_description.seo_page_description FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE site_seo_description.site_language_id = 1 AND site_seo.page_name = 'index.php' ORDER BY site_seo.page_id desc 0.0004 sec
↳cms.php : 116 -> Twig_Environment::render (mainpage.tpl ) ↳lib/Twig/lib/Twig/Environment.php : 299 -> Twig_Template::render ↳lib/Twig/lib/Twig/Template.php : 261 -> Twig_Template::display ↳lib/Twig/lib/Twig/Template.php : 250 -> Twig_Template::displayWithErrorHandling ↳lib/Twig/lib/Twig/Template.php : 276 -> __TwigTemplate_1143ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba::doDisplay ↳cache/11/43/ff883468921b3cc85c7a81a9bc2cefb590edcb3e845c625fb9eb637777ba.php : 208 -> addJS ↳templates/include/js.php : 263 -> require_once ↳templates/js/common_js.php : 66 -> get_home_page_meta_description ↳templates/include/twig_functions.php : 443 -> seoPageMaster::getSeoPageDetails ↳model/seoPageMaster.php : 147 -> RMasterModel::exec_query ↳lib/Classes/Models/RMasterModel.php : 81 -> RMasterModel::query_debugger