2. 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.0002 sec
3. SELECT configuration_master.constant_name,configuration_master.set_value,configuration_master.default_value,configuration_master.setting_type FROM configuration_master ORDER BY configuration_master.sort_order ASC, configuration_master.configuration_id ASC 0.0003 sec
13. 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
14. 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.0002 sec
15. 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.001 sec
17. 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.page_name = 'product_pricelist_popup.php' OR site_seo.page_name = 'product_pricelist_popup' OR site_seo.page_name = 'Default') ORDER BY site_seo.page_id desc 0.0004 sec
18. 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_front_pages.front_pages_name = 'product_pricelist_popup.php' OR site_front_pages.front_pages_name = 'product_pricelist_popup') OR site_general_metatag.page_id = 0 ORDER BY site_front_pages.front_pages_id desc 0.0002 sec
20. SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants_description.constant_id, Concat(site_constants_description.constant_id, IF(site_constants_description.corporate_id = -1, 1, 0)) AS corporateid 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 1 AND site_constants.front_group_id IN ('1', '3') AND site_constants.available_to IN ('0', '11', '3', '12', '-2') AND site_constants_description.corporate_id = 0 GROUP BY corporateid ORDER BY corporateid DESC) AS site_constants_description GROUP BY site_constants_description.constant_id 0.0154 sec
21. 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') LIMIT 18446744073709551615) AS temp_table ORDER BY sort_order ASC 0.0003 sec
22. SELECT * FROM sidebar_management WHERE section_pages LIKE '%|product_pricelist_popup.php|%' AND corporate_id = 0 OR sidebar_id = '1' ORDER BY sidebar_id DESC LIMIT 1 OFFSET 0 0.0002 sec
23. SELECT * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND corporate_id = 0 GROUP BY menu_title HAVING status = '1' AND menu_display IN ('0', '1') ORDER BY sortorder ASC, status ASC, menu_title ASC LIMIT 18446744073709551615 ) AS temp_table ORDER BY sortorder ASC, status ASC, menu_title ASC 0.0002 sec
25. 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') AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 ORDER BY corporate_id DESC 0.0002 sec
26. SELECT product_category_description.category_name, products.products_id, products.size_visible, products_description.products_title, products.predefined_product_type, products.price_defining_method FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_category_description ON product_category_description.category_id = products.category_id AND product_category_description.site_language_id = products_description.site_language_id LEFT JOIN products_sizes ON products_sizes.products_id = products_description.products_id LEFT JOIN product_price ON product_price.products_id = products_description.products_id WHERE products.visible = 1 AND products_description.site_language_id = 1 AND product_price.visible = 1 AND (products.user_type_id = '1' OR products.user_type_id = '0') AND products_sizes.visible = 1 AND products.products_id = 4 GROUP BY products.products_id ORDER BY products.sort_order ASC, products_sizes.sort_order ASC, products.products_id ASC 0.0233 sec
27. SELECT products.products_id, products_sizes.size_id, products_sizes.size_title, product_price.price, product_price.qty, product_price.qty_to, product_price.corporate_id, product_price.user_type_id, products.predefined_product_type, products.price_defining_method, products.enable_sheet_calculation, product_price.color_page_price, products.enable_color_pages, product_price.extra_page_price, product_price.product_price_id, vendor_price.vendor_price,vendor_price.vendor_color_price,vendor_price.vendor_price_extra_page FROM products LEFT JOIN `product_price` ON `product_price`.`products_id` = `products`.`products_id` AND `product_price`.`visible` = '1' AND (`product_price`.`user_type_id` = '1') LEFT JOIN vendor_price ON vendor_price.price_id = product_price.product_price_id AND vendor_price.price_type='P' AND (products.user_type_id = '1' OR products.user_type_id = '0') RIGHT JOIN `products_sizes` ON `products_sizes`.`products_id` = `products`.`products_id` AND `products_sizes`.`size_id` = `product_price`.`size_id` AND `products_sizes`.`site_language_id` = 1 AND `products_sizes`.`visible`='1' WHERE `products`.`products_id` IN (4) AND IF ( `products`.`price_defining_method` IN ('1', '2', '3'), `product_price`.`qty_to` != 0, 1) AND products.predefined_product_type IN ('0', '11', '1', '3', '12') ORDER BY `products_sizes`.`sort_order` ASC, `product_price`.`corporate_id` DESC, `products`.`sort_order` ASC, `product_price`.`products_id` ASC, `product_price`.`qty` ASC 0.0005 sec
39. SELECT coupon.*, IF (coupon.product_id != 'all',1,2) AS OrderBY FROM coupon WHERE coupon.type = 'discount' AND coupon.coupon_type = 'product' AND '2025-04-12 15:31:06' BETWEEN coupon.coupon_start_date AND coupon.coupon_end_date AND coupon.coupon_status = '1' ORDER BY OrderBY, user_discount_group_id DESC, coupon_start_date DESC , coupon_id DESC 0.0002 sec
Create a one-of-a-kind notebook
with limitless potential!
Menus
100/$45
Satisfy everyone’s taste buds
at just a glance.
DryErase Wall
2x3 for $34.85
Dry erase film applies
directly to your wall.
Postcards
$20.00
Premium Quality Postcards
at affordable rates.
New! Create your own Photobooks
Customize a Photo Book & Share Your Memories. Our easy to use online designer makes it simple to create lasting memories!
Weddings
Family Albums
Look Books
Portfolios
Sign up for savings, join our eNewsletter
Subscribe here
Testimonials
Thank you so much for your best Printing Services, all the amazing work you did with our programs and flyers last week. The quality was exceptional, and your flexibility and speediness has always been appreciated.
CM, Sterling, VA
Customer service is great - they communicate quickly and easily and are open to flexibility. The products received are high quality and conveniently delivered. I must say they are best photo developing company.
TN, New York, NY
You guys are AWESOME!!! They look terrific. Thank you so much and please thank everyone involved.The President of our company was very happy with the sample yesterday!!” Best Photo Printing services !!
KP, Seattle, WA
First off, AMAZING JOB. I’ve been so impressed by the quality of best photo printer and speed of this work. I’m so grateful to you for everything. Thank you.
LS, Las Vegas, NV
Watch Online Design Tool Video
[related_product_section_help] =>
You might also like to view our other products...
)
[SITE_VAR_PRODUCT_NO_IMAGE] =>
[SITE_VAR_DISPLAY_PRODUCT_CATEGORY_SUBOPTION] => %s (%s)
[SITE_VAR_CART_AGREE_CHECKBOX] => product_add_info
[SITE_VAR_PREDEFINED_PRODUCT_CHECKBOX] =>
[payonMethodIDs] => [22]
[SITE_VAR_PRODUCT_DISCOUNT_PATTERN] =>
[product_discount] =>
[ProductData] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT product_category_description.category_name, products.products_id, products.size_visible, products_description.products_title, products.predefined_product_type, products.price_defining_method FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_category_description ON product_category_description.category_id = products.category_id AND product_category_description.site_language_id = products_description.site_language_id LEFT JOIN products_sizes ON products_sizes.products_id = products_description.products_id LEFT JOIN product_price ON product_price.products_id = products_description.products_id WHERE products.visible = :visible AND products_description.site_language_id = :site_language_id AND product_price.visible = :product_price_visible AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) AND products_sizes.visible = :products_sizes_visible AND products.products_id = :products_id GROUP BY products.products_id ORDER BY products.sort_order ASC, products_sizes.sort_order ASC, products.products_id ASC
)
[AffectedRows:RDataRecordSet:private] => 1
[RecordCount] => 1
[foundRows] => -1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[category_name] => Marketing Materials
[products_id] => 4
[size_visible] => Yes
[products_title] => Postcards
[predefined_product_type] => 0
[price_defining_method] => 0
)
[_IteratorKeys:protected] => Array
(
[0] => category_name
[1] => products_id
[2] => size_visible
[3] => products_title
[4] => predefined_product_type
[5] => price_defining_method
)
)
)
[IteratorCount:RDataRecordSet:private] => 0
[last_query] => SELECT product_category_description.category_name, products.products_id, products.size_visible, products_description.products_title, products.predefined_product_type, products.price_defining_method FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_category_description ON product_category_description.category_id = products.category_id AND product_category_description.site_language_id = products_description.site_language_id LEFT JOIN products_sizes ON products_sizes.products_id = products_description.products_id LEFT JOIN product_price ON product_price.products_id = products_description.products_id WHERE products.visible = 1 AND products_description.site_language_id = 1 AND product_price.visible = 1 AND (products.user_type_id = '1' OR products.user_type_id = '0') AND products_sizes.visible = 1 AND products.products_id = 4 GROUP BY products.products_id ORDER BY products.sort_order ASC, products_sizes.sort_order ASC, products.products_id ASC
)
[PriceDetails] => Array
(
[4] => Array
(
[0] => Array
(
[5] => 5 x 7
[37] => 4 x 6
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[5 x 7] => 39.99
[ismin_price] =>
[4 x 6] => 29.99
)
[250] => Array
(
[size_id] => 250
[option_title] => 250
[5 x 7] => 65.99
[ismin_price] =>
[4 x 6] => 62.99
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[5 x 7] => 79.99
[ismin_price] =>
[4 x 6] => 73.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[5 x 7] => 108.99
[ismin_price] =>
[4 x 6] => 89.99
)
[2000] => Array
(
[size_id] => 2000
[option_title] => 2000
[5 x 7] => 169.99
[ismin_price] =>
[4 x 6] => 159.99
)
)
)
)
)
40 7. SELECT * FROM website_logos WHERE corporate_id = 0 0.0001 sec