Standard Clings: Clear (Window Graphics)

1. SELECT set_value, constant_name FROM configuration_master WHERE constant_name IN ('CORPORATE_MODUEL_ENABLE', 'COUNTRY_BASED_IP_SETTING') sec

(Cached) 23c4c596bd6ed98c168f1756c4bd368d

2. SELECT corporate_user.*, (SELECT pcu.corporate_settings FROM corporate_user pcu WHERE pcu.corporate_id = corporate_user.parent_corporate_id) AS parent_corporate_settings FROM corporate_user WHERE (corporate_user.directory_name = 'uday' OR corporate_user.main_url IN ('uday.fourprintshop.com', 'www.uday.fourprintshop.com')) ORDER BY corporate_user.corporate_type ASC sec

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')) sec

(Cached) 92dd46f86c59b1ac5575508e01c5a6de

4. SELECT configuration_master.constant_name,configuration_master.set_value,configuration_master.default_value,configuration_master.setting_type FROM configuration_master WHERE (configuration_master.available_for_corporate LIKE '%%' OR configuration_master.available_for_corporate = '-1') ORDER BY configuration_master.sort_order ASC, configuration_master.configuration_id ASC sec

5. SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'greensward' sec

(Cached) eabac4887f5bca72eac7656056ff7ec0

6. SELECT payment_method_id, directory FROM payment_method WHERE directory IN ('payon_account', 'partial_payment') ORDER BY sort_order ASC sec

(Cached) e4e2b78166a96840443ba3ecc630401c

7. SELECT external_services.*,external_service_section.section_name FROM external_services LEFT JOIN external_service_section ON external_services.section_id = external_service_section.section_id WHERE external_services.corporate_id = 0 sec

(Cached) 01725a75647885828b24e7604b95b263

8. SELECT website_logos.* FROM website_logos WHERE website_logos.corporate_id = 0 ORDER BY FIELD(corporate_id, 0, 0, 0) sec

(Cached) 265fd0b99fb9b4b66ea20f75bc4bb5b8

9. SELECT * FROM site_language sec

(Cached) d006a14cdb095c4bf9083702065fe3f4

10. SELECT * FROM url_redirection_manage WHERE (old_url = 'https://uday.fourprintshop.com/signs-banners/window-graphics/standard-clings-clear/' OR old_url = 'https://uday.fourprintshop.com/signs-banners/window-graphics/standard-clings-clear/' OR old_url = 'https://uday.fourprintshop.com/signs-banners/window-graphics/standard-clings-clear/') ORDER BY url_redirection_id ASC sec

11. SET time_zone = '-04:00' sec

12. SELECT products_description.product_url,products_description.products_id,products_description.site_language_id,products.predefined_product_type FROM products_description LEFT JOIN products on products_description.products_id=products.products_id WHERE products_description.product_url = 'standard-clings-clear' sec

13. SELECT products.predefined_product_type, products.price_defining_method, products.is_promotional FROM products WHERE products.products_id = 300 sec

(Cached) 05b4b64df866d467d0759a64c1990d53

14. SELECT studio_configuration_setting.variable_name, studio_configuration_product_setting.products_id, IF(studio_configuration_product_setting.configuration_id IS NOT NULL ,studio_configuration_product_setting.value,studio_configuration_setting.value) as setting_value, studio_configuration_setting.value AS default_value FROM studio_configuration_setting LEFT JOIN studio_configuration_product_setting ON studio_configuration_setting.configuration_id = studio_configuration_product_setting.configuration_id AND ( IF(studio_configuration_product_setting.products_id != 0,
studio_configuration_product_setting.products_id = 300 AND studio_configuration_product_setting.corporate_id = 0,
studio_configuration_product_setting.products_type_id = 1 AND studio_configuration_product_setting.corporate_id = 0 ) ) WHERE ( IF( studio_configuration_setting.exclude_products_type IS NOT NULL AND studio_configuration_setting.exclude_products_type != '', studio_configuration_setting.exclude_products_type NOT LIKE '%1%', studio_configuration_setting.products_type IS NULL OR studio_configuration_setting.products_type = '' OR studio_configuration_setting.products_type LIKE '%1%' OR studio_configuration_setting.products_type = '-1') ) AND studio_configuration_setting.variable_name = 'config[3DPreview]' ORDER BY studio_configuration_product_setting.products_id sec

(Cached) 014a450ec31c3fccf7dbad08c176adb2

15. SELECT * FROM products_studio_3d_models WHERE products_studio_3d_models.products_id = 300 AND products_studio_3d_models.status = '1' sec

16. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name IN ('COMMON_PRODUCTS_SIZE', 'COMMON_QUANTITY') sec

(Cached) 42af8d93ea2bbfb3b00ba2df52c5488f

17. SELECT site_template_category.category_id, site_template_category_description.category_name, site_template_category_description.category_url, site_template_category_description.site_language_id FROM site_template_category_description LEFT JOIN site_template_category ON site_template_category_description.category_id = site_template_category.category_id WHERE site_template_category_description.site_language_id = 1 sec

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' sec

19. SELECT products.products_id, products_description.product_url as producturl, products_description.products_title as productname, products_description.site_language_id FROM products LEFT JOIN products_description on products_description.products_id = products.products_id WHERE ((products.user_type_id IN ('0', '1'))) sec

(Cached) 8010202bafea16bd20888b7d9a0ef5b4

20. SELECT product_category.category_id,product_category_description.category_name,product_category_description.category_url,product_category.status,product_category.parent_id FROM product_category
LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = '1') sec

21. SELECT products.products_id, products_description.products_title, product_category_description.category_name, products.category_id, product_category_description.category_url,products.visible,product_category.status AS category_status, products.multiple_category, products.products_id FROM products LEFT JOIN product_category ON product_category.category_id = products.category_id 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 WHERE products_description.site_language_id = 1 AND products.predefined_product_type IN ('0', '1') sec

22. SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages.type, cms_pages_description.page_id, cms_pages_description.page_url, cms_pages_description.site_language_id, cms_pages.corporate_id, cms_pages.category_id, cms_pages_description.page_heading, cms_pages_description.image_name, cms_pages_description.short_description, cms_pages.blog_page, cms_pages.sort_order, cms_pages.status, cms_pages_description.site_language_id, cms_pages.blog_page, category_cms_pages.page_name AS category_page_name, category_cms_pages_description.page_url AS category_page_url, category_cms_pages_description.page_heading AS category_page_heading FROM cms_pages LEFT JOIN cms_pages AS category_cms_pages ON category_cms_pages.page_id = cms_pages.category_id AND category_cms_pages.status = '1' LEFT JOIN cms_pages_description AS category_cms_pages_description ON category_cms_pages_description.page_id = category_cms_pages.page_id AND category_cms_pages_description.site_language_id = 1 LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages.type != 'I' AND cms_pages.corporate_id = 0 ORDER BY cms_pages.sort_order, cms_pages.corporate_id DESC, cms_pages.sort_order ASC sec

23. SELECT site_seo_description.seo_page_title, site_seo.page_name,site_seo_description.seo_page_description, 0 AS corporate_id FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE IF(site_seo_description.site_language_id IS NOT NULL, site_seo_description.site_language_id = 1, 1) AND (site_seo.page_name = 'product_info.php' OR site_seo.page_name = 'product_info' OR site_seo.page_name = 'Default') ORDER BY site_seo.page_id desc sec

24. SELECT products_description.seo_page_title,products_description.seo_page_description, products_description.seo_page_metatags, products_description.products_title,products_description.canonical_id, products_description.schema_markup, products_description.imagename FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products_description.site_language_id = 1 AND products.products_id = 300 sec

25. SELECT site_general_metatag.name, site_general_metatag.content, site_general_metatag.type 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.corporate_id = 0 AND ((site_front_pages.front_pages_name = 'product_info.php' OR site_front_pages.front_pages_name = 'product_info') OR (site_general_metatag.page_id = 0)) ORDER BY site_front_pages.front_pages_id DESC sec

(Cached) 3c57829f108685bdd23e904d34b9124d

26. SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'product_info' sec

27. SELECT * FROM(SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants.constant_id, ROW_NUMBER() OVER(PARTITION BY site_constants.constant_id ORDER BY FIELD(site_constants_description.constant_id, 0)) AS rank, site_constants_description.corporate_id FROM site_constants INNER JOIN site_constants_description ON site_constants_description.constant_id = site_constants.constant_id AND site_constants_description.site_language_id=1 INNER 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', '-1', '-2') AND (site_constants_description.corporate_id = 0 OR site_constants_description.corporate_id IS NULL )) AS ranked WHERE rank = 1 sec

28. 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 (link_display = '2' OR link_display = '0') AND menu_link.corporate_id = 0 ORDER BY sort_order ASC, menu_id ASC sec

29. SELECT * FROM sidebar_management WHERE section_pages LIKE '%|product_info.php|%' AND sidebar_management.corporate_id = 0 OR sidebar_id = '1' ORDER BY sidebar_id DESC LIMIT 1 OFFSET 0 sec

(Cached) cfe806c3379e8cc2d47671cefc0b5152

30. SELECT * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND side_menu_link.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 sec

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', 'cms_header_content', 'product_info_dispatch_countdown', 'product_info_extra_msg', 'product_info_extra_msg_two') AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 ORDER BY FIELD(cms_pages.corporate_id, 0, 0, 0), cms_pages.corporate_id DESC, cms_pages.sort_order ASC sec

32. CALL USPGetProductsDetail('product_category.category_id,products.category_id AS cat_id,product_category.sort_order,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id,product_category_description.category_icon,product_category_description.category_header_content,product_category_description.metadata,products.products_id,products.predefined_product_type,products_description.product_url,products_description.products_title,products_description.product_promotional_text', '{\"status\":\"1\",\"visible\":1,\"hidden_product\":\"yes\",\"include_kit\":\"false\",\"site_language_id\":1,\"corporate_id\":0,\"parent_corporate_id\":0,\"product_service_type\":\"1,3,4,5\",\"store_access\":\" AND ((products.user_type_id IN (\'0\',\'1\')))\",\"include_group\":\"group\",\"is_admin\":0,\"modules\":\"0,1\"}', '{\"orderby\":\"product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC,products.sort_order ASC,products_description.products_title ASC, products.products_id ASC\"}') sec

(Cached) c00a9da814defd601e9d8f3eb6878d2c

33. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

34. SELECT product_category.category_id, product_category.category_pro_enable, product_category.category_pro_pattern, product_category_description.category_promotional_text, product_category_description.category_icon, product_category_description.category_header_content, product_category_description.metadata, product_category.status FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id WHERE product_category.parent_id = '0' AND product_category_description.site_language_id = 1 sec

(Cached) 0d49af1c9847aa1d844fc8b9f1bc41c4

35. SELECT SQL_CALC_FOUND_ROWS * FROM banner_image_setting sec

(Cached) 3032d2886e227e87f9c8146b7a2b4507

37. SELECT * FROM products WHERE products.products_id = 300 sec

38. SELECT products.product_service_type FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.products_id = 300 AND products_description.site_language_id = 1 sec

39. SELECT * FROM external_services WHERE external_services.directory LIKE 'TP4over' AND external_services.corporate_id = 0 sec

40. SELECT * FROM tp_4over_settings WHERE setting_name IN ('payment_billing', 'shipping_address_4over', 'Payment', 'default_markup_4over', 'clients_detail', 'include_shipping_and_turnaround_days_in_edd', 'allow_group_shipment', 'default_bypass_address_4over', 'pay_by_echeck', 'default_profile_id') sec

41. SELECT * FROM tp_4over_settings WHERE setting_name = 'default_markup_4over' sec

42. SELECT * FROM tp_4over_settings WHERE setting_name = 'clients_detail' sec

43. SELECT *, IF(prod_add_opt_ids='', IF(attribute_ids='', '1', '0'), '-1' ) AS matchvalue FROM products_sku WHERE products_id = 300 AND `attribute_ids` = '' AND `prod_add_opt_ids` = '' ORDER BY prod_add_opt_ids DESC , matchvalue DESC , products_sku_id ASC sec

44. SELECT category_uuid FROM tp_4over_category WHERE category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

45. SELECT forover_product_id FROM tp_move_ops_product WHERE ops_product_id = 300 ORDER BY default_selected DESC sec

46. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name IN ('PRODUCT_ADDITIONAL_OPTION_FOR_STOCK_MANAGE', 'PRODUCT_MULTIPLE_QUANTITY_AS_OPTION', 'PRODUCT_MINIMUM_PRICE', 'PRODUCT_BROWSE_DESIGN', 'PRODUCT_UPLOAD_DESIGN', 'PRODUCT_CUSTOME_DESIGN', 'PRODUCT_DESC_SELECT_STORE_TEMPLATE_HELP_TEXT', 'PRODUCT_DESC_USER_UPLOAD_ART_HELP_TEXT', 'PRODUCT_DESC_USER_CREATION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_ACTION_LABEL', 'PRODUCT_QUOTE', 'PRODUCT_DESC_HIRE_DESIGNER_HELP_TEXT', 'PRODUCT_DESC_QUOTE_HELP_TEXT', 'PRODUCT_HIRE_DESIGNER', 'BOOK_NO_COVER', 'BOOK_COVER_INCLUDED_IN_CONTENT', 'PRODUCT_UPDATE_PRICE_TABLE', 'PRODUCT_ADDITIONAL_OPTION_GALLERY', 'PRODUCT_UPLOAD_LOCATION', 'ARTWORK_LATER_OPTION', 'PRODUCT_PDF_PREVIEW_ENABLE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'PRODUCT_CSS_CLASS', 'PRODUCT_DOWNLOAD_PRINT_FILE', 'CUSTOM_SIZE_INFO', 'PRODUCT_CREATE_HELP_TEMPLATE', 'PRODUCT_START_PRICE', 'PRODUCT_HIRE_DESIGNER_COST', 'PRODUCT_SETUP_COST', 'PRODUCT_APPLY_SETUP_COST', 'ENABLE_BUYNOW', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'CUSTOM_SIZE_SETUP_COST', 'CUSTOM_SIZE_CHECK', 'CUSTOM_SIZE_IMAGE') sec

(Cached) 8969e871c47cd60a1927eac4f97bef24

47. SELECT layout_name, is_mobile, sidebar_display, is_default, IF(FIND_IN_SET('300',products_id)>0,'1','0') AS info_layout_order, user_type_id, corporate_id, products_id, layout_data, full_width FROM product_info_layout WHERE (products_id LIKE '%,300,%' OR is_default = '1') AND products_type = '0' AND ((product_info_layout.user_type_id IN ('0', '1'))) ORDER BY user_type_id,corporate_id,info_layout_order ASC sec

(Cached) 8ba4b68cb4dc19a48277f34949d51281

48. SELECT products.*, products_description.* FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.products_id = 300 AND products_description.site_language_id = 1 AND products.visible = 1 AND ((products.user_type_id IN ('0', '1'))) sec

49. SELECT SQL_CALC_FOUND_ROWS product_category_description.category_name FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category.category_id = 72 AND product_category_description.site_language_id = 1 AND product_category.parent_id != 0 sec

50. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=300 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC sec

51. SELECT * FROM products_sizes WHERE products_sizes.products_id = 300 AND products_sizes.visible = '1' AND site_language_id = 1 sec

52. SELECT SQL_CALC_FOUND_ROWS orders.customers_name,orders_feedback.* FROM orders_feedback LEFT JOIN orders ON orders_feedback.orders_id = orders.orders_id WHERE orders_feedback.products_type_id = 300 AND orders_feedback.status like '1' sec

53. SELECT product_template.tp4over_template, product_template_type.*,product_template.duplicate_product_id,product_template.product_template_id,product_template.products_id, product_template.size_id,product_template.template_filename, product_template.status,product_template.sort_order,products_sizes.size_title,product_template_description.site_language_id,product_template_description.product_template_description FROM product_template_type LEFT JOIN product_template ON product_template.template_type_id = product_template_type.template_type_id LEFT JOIN product_template_description ON product_template.product_template_id = product_template_description.product_template_id INNER JOIN products_sizes on products_sizes.size_id = product_template.size_id WHERE (product_template.products_id = 300 OR duplicate_product_id LIKE '%,300-%') AND product_template_description.site_language_id = 1 AND products_sizes.site_language_id = 1 AND product_template. status = '1' GROUP BY product_template.product_template_id ORDER BY product_template.sort_order ASC sec

54. SELECT products_image_gallery.corporate_id, products_image_gallery.*, products_additional_option.status AS option_status, products_additional_option_attributes.status AS attribute_status, IF((products_image_gallery.option_id != 0 or products_image_gallery.attribute_id != 0) and (products_additional_option.status != '1' OR products_additional_option_attributes.status != '1'), 0,1) AS is_active FROM products_image_gallery LEFT JOIN products_additional_option ON products_additional_option.prod_add_opt_id = products_image_gallery.option_id LEFT JOIN products_additional_option_attributes ON products_additional_option_attributes.attribute_id = products_image_gallery.attribute_id AND products_additional_option_attributes.site_language_id = 1 WHERE products_image_gallery.products_id = 300 AND (products_image_gallery.language = 1 OR products_image_gallery.language = 0) AND products_image_gallery.status = '1' AND products_image_gallery.corporate_id = 0 HAVING is_active = 1 ORDER BY products_image_gallery.option_id ASC, products_image_gallery.option_ids ASC, products_image_gallery.sort_order ASC sec

55. SELECT GROUP_CONCAT(products_related_id) AS products_related_id FROM products_related_products WHERE product_assignment_type = 'R' AND products_id = 300 sec

56. SELECT products.predefined_product_type FROM products WHERE products.products_id = 300 sec

(Cached) 6a549756a75b1c652486d0d757fd2b6c

57. SELECT coupon.coupon_id, coupon.type, coupon.bogo_config, coupon.coupon_amount, coupon.coupon_name, coupon.product_id, coupon.user_discount_group_id, coupon.coupon_condition, coupon.applicable_with_option, coupon.type, pids.value, coupon.product_id AS coupon_products, coupon.coupon_spec_users, coupon.user_type, coupon.created_by, pids.value AS product_id, IF(coupon_combo_products_rules.discount IS NULL OR coupon_combo_products_rules.discount = 0, coupon.coupon_amount, coupon_combo_products_rules.discount) as discount, IF(coupon_combo_products_rules.min_quantity IS NULL OR coupon_combo_products_rules.min_quantity = 0, 0, coupon_combo_products_rules.min_quantity) as min_qty, IF(coupon_combo_products_rules.max_quantity IS NULL OR coupon_combo_products_rules.max_quantity = 0, 0, coupon_combo_products_rules.max_quantity) as max_qty FROM coupon CROSS JOIN JSON_TABLE(CONCAT('["', REPLACE(product_id, ',', '","'), '"]'), '$[*]' COLUMNS(value INT PATH '$')) AS pids LEFT JOIN coupon_combo_products_rules ON coupon_combo_products_rules.coupon_id = coupon.coupon_id and coupon_combo_products_rules.products_id = pids.value LEFT JOIN products ON products.products_id = pids.value AND ((products.user_type_id IN ('0', '1'))) WHERE products.visible = 1 AND (
coupon.type = 'combo_discount'
OR (coupon.type = 'bogo' AND (coupon_combo_products_rules.coupon_id IS NULL OR coupon_combo_products_rules.products_id IS NULL))
) AND coupon.product_id REGEXP '(^|,)(300)(,|$)' AND coupon.created_by = 0 AND '2026-06-13 01:37:16' BETWEEN coupon.coupon_start_date AND coupon.coupon_end_date AND coupon.coupon_status = '1' AND products.predefined_product_type IN ('0', '1') GROUP BY coupon.coupon_id,value ORDER BY coupon.created_by DESC, coupon.coupon_id, pids.value; sec

58. SELECT layout_name, is_mobile, sidebar_display FROM product_info_layout WHERE layout_name = 'L1' sec

(Cached) 38cd42efff1fff38bed6470c2cfe436b

59. SELECT * FROM tp_move_ops_product WHERE ops_product_id = 300 sec

60. SELECT tp_4over_product_group_option_master.*, tp_4over_product_group_master.order_by, tp_product_price.* FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master ON tp_4over_product_group_option_master.option_group_uuid = tp_4over_product_group_master.option_group_uuid LEFT JOIN tp_product_price ON tp_product_price.product_uuid = tp_4over_product_group_option_master.product_uuid WHERE tp_4over_product_group_option_master.product_uuid = '031e1256-bb21-4186-a849-8fa6b05b4145' AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' GROUP BY option_group_uuid ORDER BY tp_4over_product_group_master.order_by ASC, tp_product_price.product_baseprice ASC sec

61. SELECT * FROM tp_4over_product_options_settings WHERE category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' AND tp_4over_product_options_settings.ops_product_id IN ('0', '300') AND tp_4over_product_options_settings.corporate_id = 0 ORDER BY tp_4over_product_options_settings.ops_product_id DESC, FIELD(tp_4over_product_options_settings.corporate_id, 0, 0) sec

62. SELECT * FROM tp_4over_site_constant WHERE tp_4over_site_constant.default_value = '1' sec

63. SELECT * FROM tp_4over_product_group_orderby_and_quote WHERE ops_product_id IN ('0', '300') AND categoryId = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' GROUP BY ops_product_id,option_group_uuid ORDER BY ops_product_id DESC sec

64. SELECT option_group_uuid,option_group_name FROM tp_4over_product_group_master sec

(Cached) b4f1269419b4ab10b5b7d25eb2c214cf

65. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145', 'c551d06d-446e-47c6-bf1b-4a1a22a4c981', 'c6f2e8f3-90af-4ad7-81ff-d106dd376a0c', 'c86b042a-66bf-42f8-8170-6d94ba12b2ae', 'c8adf6d3-c323-41bc-9251-8f7f4b8a7954', 'c8e79276-b5df-436e-8e7c-08b26dbf3833', 'c9652cac-04f1-4f39-85e9-6a63a77a6273', 'c9cf462f-b77b-4252-a215-3dff07ccf6bd', 'ca43e798-3ead-4995-ace6-7ee9f2294f5d', 'cba24b00-1040-4167-a601-76f07dc3cdf6', 'cc0cb867-9bda-475b-8706-3521df650102', 'ccc28d03-741f-448a-97bd-d270925038df', 'cccf4b7d-60f3-43d4-a23f-febda394d3bf', 'ce1aa9b3-6292-45cf-a7d4-35367d751977', 'cee365ec-848b-4f92-8903-fd894694b9ba', 'cf480ab0-4c18-4251-abc9-2a750d000731', 'd06b46a6-fc98-4804-b273-182075f8c7c9', 'd0d1042c-5e83-4007-9422-640c53a7b931', 'd60bdcb6-487a-4259-b47e-6d21b8e673f7', 'd6f4a2f1-6422-4f8f-bacc-8eccf49d6b5f', 'd826b868-0334-4cbe-aa07-d0c981825f4e', 'd89c5d98-a0e4-4433-9a16-9c1b1998d0a7', 'db8adc8c-73b2-4066-8fe7-6aa3add6d0af', 'dc6613d4-4a55-4538-8321-5d328c5b06b7', 'df0ea7c1-3142-4741-99dc-d46d80c2047b', 'df3d5ce7-9d30-4bf9-9ab3-c64e238d94e8', 'dfb14750-93c2-4f60-8bbe-8e1269a70b16', 'dfff49a5-6e87-44dd-9f80-4aeb41af333a', 'e096b602-cc34-4ff1-8891-ec57e4ef0043', 'e0cf0d4d-6479-4405-a9c6-bb6f717d99f5', 'e1dbcc05-20d7-411b-83f0-f033cb2cbac9', 'e23acc98-ade7-47e7-a51e-17587d633f04', 'e486e32b-4859-4f58-9f2a-92ff931ff987', 'e622ba2e-7b73-461d-8fa3-545be93f4b9c', 'e6d85d67-cf0c-4f5e-874f-b3e1150e34de', 'e6f96dee-0d23-45f3-a54f-b12c7f7eaa30', 'e71eb239-2ea4-4fd4-a7a8-9ee2eb4ec974', 'e856043f-b1d1-4f6f-b5f1-0c607a634e2c', 'e906a5df-a3a9-489d-b9d2-a48e1702d3d3', 'e920e2c3-6a08-4b9a-853e-4f78cac028bb', 'e92b082e-96ba-4bae-99ff-528f5ab03f0e', 'e99f4340-1e8e-4367-8fd0-3e8b6170b97a', 'e9c18117-3a24-4b44-b59a-5d537ae5cda0', 'e9dc0714-c8ee-4690-bd24-1091aba3e57b', 'e9dc42e3-1689-47a7-82f3-7af667bb42c4', 'eb7a7faa-1750-4a7e-8ce6-6560587b5ad6', 'ed21d4a7-2314-4f6a-8b87-6180fa108c29', 'ed8e4573-a2b0-4857-94a4-020da4c3b671', 'eea43f38-80e3-497a-bd24-4fde73e25ab3', 'f0e86be3-ccf9-47bf-8403-f631297e09f2', 'f11b879c-18f2-4147-a07e-6c39eca760b6', 'f1adb832-b270-4496-af12-b8dd2cac5907', 'f20bb4ea-1184-4c8f-b734-b066a92e8702', 'f2897a73-0da0-41c7-86bf-b2a10c8f3ee5', 'f4179bf4-0c63-45b5-b60a-b8dd47512905', 'f5bb7cda-a39d-4456-bb53-7157b0c9eced', 'f5eaa44e-ec85-4b0e-b4ba-b96685c10ac9', 'f6d152cc-eff4-4603-b2a4-4ea29e49229e', 'f6e154d5-b080-4bee-8a58-9617f018033b', 'f98ec19d-bb30-4afc-b336-fbc61fd74b9e', 'f9a75cd1-3c7d-49aa-a2ee-371eda1c306e', 'fa24923d-ba5b-44e3-9fc5-51c3a9ce50c2', 'fad3f652-3ca0-458c-bccd-c87c44fc76ac', 'fd3283b4-6bc6-4364-ac3e-95e8e6aba738', 'fd86de7b-50fb-4f52-a032-99b754ffbe29', '04d2a81b-596c-4f65-92a0-9bfc58e74d14', '053a2317-f1f1-483a-abb3-4d499ee6e60e', '0565f097-4d2e-4545-a99d-8a2bcebb62cf', '05f49550-9644-4e6a-8c13-316f8bce3e1d', '06fc3fd0-0311-42b4-997f-0d8b13a69456', '096504d8-3af1-4a7c-8399-994bed36cb87', '0a2a4ee2-621b-4a6a-b075-ae4352d70f38', '0cf6aae8-dc6e-4e34-abf1-565125bc07ff', '0d7599f4-a586-4109-ad59-8799fc62b831', '0d7a1bd1-82a0-435f-a590-90238fb0270d', '0e566192-89f4-416a-9be9-f374039000bf', '0eaf5028-7ca9-4c5d-b92d-fd5e5511d04d', '10787c49-47b4-44b7-9bcf-dd84e40a9707', '11fe5f70-e468-4f9e-b198-8822b1e29208', '16df57a9-8119-4f9b-b273-3d28dfd0b3ba', '17a5885e-4a88-4789-8ff1-ab27f196c200', '1925e03d-f0bc-4edb-b16c-c384205d1733', '1a6cbc54-79eb-448b-9f0d-38b7c893b3c7', '1bc61cb1-4ac8-462b-a861-025d622cdfc9', '1d314bcf-977b-460a-adf1-e179e7a7ef9b', '1e70303c-d267-46e4-8622-bf3e47d7219b', '1f070255-99a4-4166-95f6-6cbb5c28da32', '1f783550-28be-4f11-ae7e-ccb692542a59', '1fd56d78-02e4-4c06-8c09-dd9a4dec1812', '201aa5f1-0fe5-4eda-8dca-68612e7f1d3d', '2136a970-b836-458d-b80e-5a5ae238f9a2', '21bc75c1-7675-474f-bb30-3fa19cef1e27', '231d3839-aad1-4f28-b9fb-b244f954c1b8', '23adc580-4883-44d3-a339-4a60ba07ff28', '2475894a-d030-40f3-855a-069f94ed0228', '26ef79e8-904f-4e8f-baed-b4c44906178e', '278a26b9-fc92-4615-9c41-c59a5584e852', '2799262d-caef-45da-9b24-53f3a07c5706', '27dce3c4-d000-4ffa-a591-ad7909dd0e8a', '2b31e608-c57f-46fc-9309-55c6fdcc939d', '2c2d7116-5cf1-4b22-92ef-ae5eeed2e837', '2c420f57-93b6-44b9-97a1-7d4d59c04f67', '2f6c7f8d-a61d-4a88-8ff7-8504be36125b', '3135c6d2-c081-4fd8-a746-bd3b8a618e13', '32189f21-ebff-4141-8d63-219c7c48531d', '3260f5de-0796-4cdb-91c9-4bc6914acc40', '35757bb3-ee3a-4782-8e47-ca7f64e48047', '388a9263-5bd2-48e3-9b6f-2dfc0369a5ac', '3a1df359-3131-45ab-8e5b-5ffccd100149', '3a7adc27-fb3b-4988-8dc1-64e849ed0b41', '3ac51b85-4e8d-45fa-8740-4e4ce70f7c0c', '3ce21f66-557e-4cb6-8523-90be7f708e81', '3ce32317-35f7-4467-86f2-77e701cc8d56', '3d86b366-289b-46a3-b743-c03aa771e9a6', '3ed1f979-0338-4982-890b-5852acfda2dc', '40f78e38-c08e-4795-8a66-be226c4e1773', '41276bfc-fb9b-4ffd-8ce3-5ffb664a29d4', '412b721c-54f7-4b1a-911e-018fdf728863', '43488025-bdbc-4fbc-8707-9deda56a8963', '45752a63-dea4-4576-85d7-430cdf19e7de', '467b16ec-9741-4213-9b10-1f200377fc98', '491527b6-34ef-4e1f-b934-127335192457', '4a983cf6-1594-4412-b048-75216ca453f4', '4adadf9a-14ea-4f8d-afdf-4e5597cf9d66', '4aee9f9f-1bdc-45b1-a168-aa772a8adb73', '4b90a58b-f2be-43ec-9dac-d7643af339f5', '4ec2090f-ad29-4ae7-91d3-d28004c74884', '4eff1147-d863-4d59-a31c-7226479e2388', '50d8081b-42f6-4cc8-8951-d388abb65cd6', '5101f8dc-0a13-419d-9e80-5d0b89804813', '528de7bb-a49a-46dc-ada1-b0b6c7add42c', '535509fd-ed10-4fcb-ae4a-0c299e29f478', '5642e37a-80ff-4bbc-90e0-cea79cbba30e', '5a76d0b9-4a72-4946-bca5-7c6dc5df6303', '5b6c7361-e621-4966-9609-02e79e687b60', '5c07577a-c2fc-4171-bde3-dfbc3c6df7a8', '5cca92ef-cea4-49ea-8849-a954c989da36', '5d3e05ef-8b3e-455d-8ba9-10ddbea03b53', '5e7652ae-34b0-4010-b908-b1a4300c0960', '5e9a4787-762a-4f5b-b041-7ab6dfb57149', '5ecb2fa6-bff8-4663-b674-5d39c8a57797', '5ee54386-3640-469a-b294-62db599fc3ab', '5f018c2e-7701-4b85-a6bb-fb2269aab5c2', '5f91e870-6783-4ff5-87a0-e7fd865032a7', '60d3b41d-3675-4a0f-99f2-a2483f1541f5', '6139ef2a-0740-4c72-b7ef-31675b82757b', '61debef6-910c-4c9a-99bf-9f591fb0676a', '62a350b8-e2c8-4abe-ac08-a3a596dee525', '64233972-8a40-420c-89ef-9217aa5e1794', '6478d570-dc60-4258-b5b0-96db76d9fd26', '64d58fa1-869e-47e5-aa2a-35a94d57d4a3', '654d5bf1-0c2f-4cc1-8a36-631d206b45b4', '65f56164-f318-451f-8b6d-283535a62db2', '669e2c18-7960-4342-aeeb-ea39187378f3', '6741a673-d5af-42c6-b867-492ed0d9fe81', '67f62779-e839-4a72-a884-4328dd84b365', '680172ea-5e86-40b6-98ec-8c18173845e2', '6a31ea7e-645f-4a4c-b842-92336989be1d', '6d9627f5-4b5b-4e9f-8505-03a87a28426c', '6dcbdf76-7512-49ac-9051-b971b1317bd2', '6f50f552-7686-42f2-8a7c-66c5cf628598', '6fa93ffd-4ba6-4ae3-98e1-3dcf51c6411b', '6fdb0462-302a-4688-81d1-ae238a881957', '70f23b3f-da3b-4d53-ab06-c65773c49723', '720190bd-136c-453b-a83b-53cbc6c083b3', '72a56462-a10a-4d6d-b71b-aab704f8dafc', '731826f2-7340-4b80-8684-9337e82b74da', '739c4277-12e4-41e5-a096-d027a3b7a924', '741c13f6-6cdb-4f09-affd-ef6cbe7c2774', '75104202-e471-4451-9b8c-b8cc6ed30201', '76812272-e832-4525-bfde-0990fcd9682b', '770e5d4d-75f2-4b4c-a339-93bea9b79bea', '77c0a03a-84ce-4c8a-adc8-3b39c6fe431d', '78aa15b8-a665-4aca-a9d2-4cbc01efe391', '795cb747-49fa-4475-99b4-bd068e09ea13', '79e35084-50e1-4085-8637-ce432b17a39f', '7a66566b-1fdf-4694-aa3d-755f19e83af7', '7a7c4475-c250-4540-9f7b-e186bb0a11d6', '7b05b860-c529-47a0-bfaa-74985381faa9', '7bb46df7-19dd-4447-aa45-fadfe0e1ed6c', '8005adc9-65c7-417c-92ae-35dfb5f23152', '80b51ffa-83ea-4eed-8511-66eec12f6b63', '822e4895-7da6-4946-9c39-de23bd4a1150', '8379a389-88e9-4e5c-b823-738a2ded8380', '868a55e1-31d3-4662-874e-8b005c9bd76d', '87e101a2-1933-443a-a22e-4523ff64638f', '89bf75ec-c55d-47a6-9699-dbaf9d4353d1', '8b49aa1c-b09e-4461-9dc5-598524559463', '8b4f0139-a7e8-4ae5-ace1-408d8a47baeb', '8c8ca4e3-01e8-4b22-a4b6-feea8f0c058f', '8cb5e6fd-c4a1-4ff9-a605-689a0c860831', '8d7fd3c8-5255-4f00-9cf9-d0313749504e', '8f3e3a52-e145-4562-a452-aa7a117ed8c1', '93088ef6-81f3-4a14-bdb2-a1ca0dd07bf5', '95636577-b96c-4b12-a97a-fec6044041ef', '95a1ed1f-ab9d-48c3-9274-0cd4c4a371fa', '95d3f1d6-7a90-4ce4-b0bb-ec9be7ff89c5', '97aa035c-d3eb-43b4-884b-bb5dbb51afe1', '995bf090-f5aa-4020-ac1e-3894cfd6dc45', '9b1d4753-d18f-4206-a699-5fc21a60b28b', '9b45085c-5b5e-4f38-ace2-c6b7de917937', '9c977ceb-c7df-44c5-99a5-f8f031422051', '9cc86f59-5944-4ffe-a446-e88f248de9f6', '9d30ed03-32f8-4a7b-b204-001e6a9a1924', '9d4fcd40-9ccd-4f41-9359-07b8e6d7c7c1', '9eec9718-2026-4a30-b6b0-522909dc8dc8', '9efe494d-b603-4d18-9672-a39f4a0818ac', 'a1d97d5b-f1c7-4a7f-ad28-ec85f8e3dd4c', 'a2461ad4-4b1b-4849-81f1-de02f9f21e71', 'a5959f44-0d85-490d-a867-b142f45b2c69', 'a5a8e3ca-194e-4bc9-b1b3-c7c4b027e71e', 'a61f43f1-77f0-4162-b3a3-4376cb8428ed', 'a78f38d7-e4f4-4476-8fe4-738d1f0e66ef', 'a7e43a58-46ae-431f-bfed-6a3c7247f239', 'a850730f-749c-44dc-b1b3-97a91864033c', 'a87ed843-a991-4e64-92aa-f77ca436b09a', 'a89c37c0-2948-4d27-8e67-0339dcb1e337', 'aa61a031-17b9-47d3-8ef3-19d65037b32c', 'aaa8dc4e-662f-4fb2-8c3d-773b6065519d', 'ab290cea-ddda-4b09-8c35-d03a9f9f7c7a', 'accbe0c1-4e52-4cfd-afb7-04bbac85b4a5', 'ad0ca7a7-77bb-45ff-a79f-03a3f43faec8', 'aefd91ce-5324-4bf9-a622-19caaf0ecf7b', 'b01dea8a-3d17-419e-b757-f00c3a2bbffd', 'b0b58ec9-820f-4a71-9d14-2f90dbad3bdc', 'b32f3cb7-4ddf-4be6-af95-b5fff38544b0', 'b6f2ec70-b8be-48d3-b22b-9c1726b743a1', 'b71f5403-8897-4722-8f01-cc17bec7da6e', 'b7d98113-a409-4a4f-ac8c-45db363c7503', 'b9f73034-703d-4cbf-806d-1d6ce58bd776', 'ba65e008-02df-4fb5-aee0-ba16159a1b87', 'bd3f257b-eb4d-4b91-acd8-8bd893277c19', 'bd8cbdcc-6106-4764-9a5c-a1793b2881fa', 'be85fe44-20a7-4e5c-9800-8b27d6dac19c', 'c0f20064-64b1-4399-9b6c-9a30aaff136c', 'c0fa8cb4-e942-48f9-a15e-f48ada94f23f', 'c2938976-acfd-4c2a-abfa-b529656f56c9') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

66. SELECT colorspec_uuid FROM tp_product_price WHERE product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145', 'c551d06d-446e-47c6-bf1b-4a1a22a4c981', 'c6f2e8f3-90af-4ad7-81ff-d106dd376a0c', 'c86b042a-66bf-42f8-8170-6d94ba12b2ae', 'c8adf6d3-c323-41bc-9251-8f7f4b8a7954', 'c8e79276-b5df-436e-8e7c-08b26dbf3833', 'c9652cac-04f1-4f39-85e9-6a63a77a6273', 'c9cf462f-b77b-4252-a215-3dff07ccf6bd', 'ca43e798-3ead-4995-ace6-7ee9f2294f5d', 'cba24b00-1040-4167-a601-76f07dc3cdf6', 'cc0cb867-9bda-475b-8706-3521df650102', 'ccc28d03-741f-448a-97bd-d270925038df', 'cccf4b7d-60f3-43d4-a23f-febda394d3bf', 'ce1aa9b3-6292-45cf-a7d4-35367d751977', 'cee365ec-848b-4f92-8903-fd894694b9ba', 'cf480ab0-4c18-4251-abc9-2a750d000731', 'd06b46a6-fc98-4804-b273-182075f8c7c9', 'd0d1042c-5e83-4007-9422-640c53a7b931', 'd60bdcb6-487a-4259-b47e-6d21b8e673f7', 'd6f4a2f1-6422-4f8f-bacc-8eccf49d6b5f', 'd826b868-0334-4cbe-aa07-d0c981825f4e', 'd89c5d98-a0e4-4433-9a16-9c1b1998d0a7', 'db8adc8c-73b2-4066-8fe7-6aa3add6d0af', 'dc6613d4-4a55-4538-8321-5d328c5b06b7', 'df0ea7c1-3142-4741-99dc-d46d80c2047b', 'df3d5ce7-9d30-4bf9-9ab3-c64e238d94e8', 'dfb14750-93c2-4f60-8bbe-8e1269a70b16', 'dfff49a5-6e87-44dd-9f80-4aeb41af333a', 'e096b602-cc34-4ff1-8891-ec57e4ef0043', 'e0cf0d4d-6479-4405-a9c6-bb6f717d99f5', 'e1dbcc05-20d7-411b-83f0-f033cb2cbac9', 'e23acc98-ade7-47e7-a51e-17587d633f04', 'e486e32b-4859-4f58-9f2a-92ff931ff987', 'e622ba2e-7b73-461d-8fa3-545be93f4b9c', 'e6d85d67-cf0c-4f5e-874f-b3e1150e34de', 'e6f96dee-0d23-45f3-a54f-b12c7f7eaa30', 'e71eb239-2ea4-4fd4-a7a8-9ee2eb4ec974', 'e856043f-b1d1-4f6f-b5f1-0c607a634e2c', 'e906a5df-a3a9-489d-b9d2-a48e1702d3d3', 'e920e2c3-6a08-4b9a-853e-4f78cac028bb', 'e92b082e-96ba-4bae-99ff-528f5ab03f0e', 'e99f4340-1e8e-4367-8fd0-3e8b6170b97a', 'e9c18117-3a24-4b44-b59a-5d537ae5cda0', 'e9dc0714-c8ee-4690-bd24-1091aba3e57b', 'e9dc42e3-1689-47a7-82f3-7af667bb42c4', 'eb7a7faa-1750-4a7e-8ce6-6560587b5ad6', 'ed21d4a7-2314-4f6a-8b87-6180fa108c29', 'ed8e4573-a2b0-4857-94a4-020da4c3b671', 'eea43f38-80e3-497a-bd24-4fde73e25ab3', 'f0e86be3-ccf9-47bf-8403-f631297e09f2', 'f11b879c-18f2-4147-a07e-6c39eca760b6', 'f1adb832-b270-4496-af12-b8dd2cac5907', 'f20bb4ea-1184-4c8f-b734-b066a92e8702', 'f2897a73-0da0-41c7-86bf-b2a10c8f3ee5', 'f4179bf4-0c63-45b5-b60a-b8dd47512905', 'f5bb7cda-a39d-4456-bb53-7157b0c9eced', 'f5eaa44e-ec85-4b0e-b4ba-b96685c10ac9', 'f6d152cc-eff4-4603-b2a4-4ea29e49229e', 'f6e154d5-b080-4bee-8a58-9617f018033b', 'f98ec19d-bb30-4afc-b336-fbc61fd74b9e', 'f9a75cd1-3c7d-49aa-a2ee-371eda1c306e', 'fa24923d-ba5b-44e3-9fc5-51c3a9ce50c2', 'fad3f652-3ca0-458c-bccd-c87c44fc76ac', 'fd3283b4-6bc6-4364-ac3e-95e8e6aba738', 'fd86de7b-50fb-4f52-a032-99b754ffbe29', '04d2a81b-596c-4f65-92a0-9bfc58e74d14', '053a2317-f1f1-483a-abb3-4d499ee6e60e', '0565f097-4d2e-4545-a99d-8a2bcebb62cf', '05f49550-9644-4e6a-8c13-316f8bce3e1d', '06fc3fd0-0311-42b4-997f-0d8b13a69456', '096504d8-3af1-4a7c-8399-994bed36cb87', '0a2a4ee2-621b-4a6a-b075-ae4352d70f38', '0cf6aae8-dc6e-4e34-abf1-565125bc07ff', '0d7599f4-a586-4109-ad59-8799fc62b831', '0d7a1bd1-82a0-435f-a590-90238fb0270d', '0e566192-89f4-416a-9be9-f374039000bf', '0eaf5028-7ca9-4c5d-b92d-fd5e5511d04d', '10787c49-47b4-44b7-9bcf-dd84e40a9707', '11fe5f70-e468-4f9e-b198-8822b1e29208', '16df57a9-8119-4f9b-b273-3d28dfd0b3ba', '17a5885e-4a88-4789-8ff1-ab27f196c200', '1925e03d-f0bc-4edb-b16c-c384205d1733', '1a6cbc54-79eb-448b-9f0d-38b7c893b3c7', '1bc61cb1-4ac8-462b-a861-025d622cdfc9', '1d314bcf-977b-460a-adf1-e179e7a7ef9b', '1e70303c-d267-46e4-8622-bf3e47d7219b', '1f070255-99a4-4166-95f6-6cbb5c28da32', '1f783550-28be-4f11-ae7e-ccb692542a59', '1fd56d78-02e4-4c06-8c09-dd9a4dec1812', '201aa5f1-0fe5-4eda-8dca-68612e7f1d3d', '2136a970-b836-458d-b80e-5a5ae238f9a2', '21bc75c1-7675-474f-bb30-3fa19cef1e27', '231d3839-aad1-4f28-b9fb-b244f954c1b8', '23adc580-4883-44d3-a339-4a60ba07ff28', '2475894a-d030-40f3-855a-069f94ed0228', '26ef79e8-904f-4e8f-baed-b4c44906178e', '278a26b9-fc92-4615-9c41-c59a5584e852', '2799262d-caef-45da-9b24-53f3a07c5706', '27dce3c4-d000-4ffa-a591-ad7909dd0e8a', '2b31e608-c57f-46fc-9309-55c6fdcc939d', '2c2d7116-5cf1-4b22-92ef-ae5eeed2e837', '2c420f57-93b6-44b9-97a1-7d4d59c04f67', '2f6c7f8d-a61d-4a88-8ff7-8504be36125b', '3135c6d2-c081-4fd8-a746-bd3b8a618e13', '32189f21-ebff-4141-8d63-219c7c48531d', '3260f5de-0796-4cdb-91c9-4bc6914acc40', '35757bb3-ee3a-4782-8e47-ca7f64e48047', '388a9263-5bd2-48e3-9b6f-2dfc0369a5ac', '3a1df359-3131-45ab-8e5b-5ffccd100149', '3a7adc27-fb3b-4988-8dc1-64e849ed0b41', '3ac51b85-4e8d-45fa-8740-4e4ce70f7c0c', '3ce21f66-557e-4cb6-8523-90be7f708e81', '3ce32317-35f7-4467-86f2-77e701cc8d56', '3d86b366-289b-46a3-b743-c03aa771e9a6', '3ed1f979-0338-4982-890b-5852acfda2dc', '40f78e38-c08e-4795-8a66-be226c4e1773', '41276bfc-fb9b-4ffd-8ce3-5ffb664a29d4', '412b721c-54f7-4b1a-911e-018fdf728863', '43488025-bdbc-4fbc-8707-9deda56a8963', '45752a63-dea4-4576-85d7-430cdf19e7de', '467b16ec-9741-4213-9b10-1f200377fc98', '491527b6-34ef-4e1f-b934-127335192457', '4a983cf6-1594-4412-b048-75216ca453f4', '4adadf9a-14ea-4f8d-afdf-4e5597cf9d66', '4aee9f9f-1bdc-45b1-a168-aa772a8adb73', '4b90a58b-f2be-43ec-9dac-d7643af339f5', '4ec2090f-ad29-4ae7-91d3-d28004c74884', '4eff1147-d863-4d59-a31c-7226479e2388', '50d8081b-42f6-4cc8-8951-d388abb65cd6', '5101f8dc-0a13-419d-9e80-5d0b89804813', '528de7bb-a49a-46dc-ada1-b0b6c7add42c', '535509fd-ed10-4fcb-ae4a-0c299e29f478', '5642e37a-80ff-4bbc-90e0-cea79cbba30e', '5a76d0b9-4a72-4946-bca5-7c6dc5df6303', '5b6c7361-e621-4966-9609-02e79e687b60', '5c07577a-c2fc-4171-bde3-dfbc3c6df7a8', '5cca92ef-cea4-49ea-8849-a954c989da36', '5d3e05ef-8b3e-455d-8ba9-10ddbea03b53', '5e7652ae-34b0-4010-b908-b1a4300c0960', '5e9a4787-762a-4f5b-b041-7ab6dfb57149', '5ecb2fa6-bff8-4663-b674-5d39c8a57797', '5ee54386-3640-469a-b294-62db599fc3ab', '5f018c2e-7701-4b85-a6bb-fb2269aab5c2', '5f91e870-6783-4ff5-87a0-e7fd865032a7', '60d3b41d-3675-4a0f-99f2-a2483f1541f5', '6139ef2a-0740-4c72-b7ef-31675b82757b', '61debef6-910c-4c9a-99bf-9f591fb0676a', '62a350b8-e2c8-4abe-ac08-a3a596dee525', '64233972-8a40-420c-89ef-9217aa5e1794', '6478d570-dc60-4258-b5b0-96db76d9fd26', '64d58fa1-869e-47e5-aa2a-35a94d57d4a3', '654d5bf1-0c2f-4cc1-8a36-631d206b45b4', '65f56164-f318-451f-8b6d-283535a62db2', '669e2c18-7960-4342-aeeb-ea39187378f3', '6741a673-d5af-42c6-b867-492ed0d9fe81', '67f62779-e839-4a72-a884-4328dd84b365', '680172ea-5e86-40b6-98ec-8c18173845e2', '6a31ea7e-645f-4a4c-b842-92336989be1d', '6d9627f5-4b5b-4e9f-8505-03a87a28426c', '6dcbdf76-7512-49ac-9051-b971b1317bd2', '6f50f552-7686-42f2-8a7c-66c5cf628598', '6fa93ffd-4ba6-4ae3-98e1-3dcf51c6411b', '6fdb0462-302a-4688-81d1-ae238a881957', '70f23b3f-da3b-4d53-ab06-c65773c49723', '720190bd-136c-453b-a83b-53cbc6c083b3', '72a56462-a10a-4d6d-b71b-aab704f8dafc', '731826f2-7340-4b80-8684-9337e82b74da', '739c4277-12e4-41e5-a096-d027a3b7a924', '741c13f6-6cdb-4f09-affd-ef6cbe7c2774', '75104202-e471-4451-9b8c-b8cc6ed30201', '76812272-e832-4525-bfde-0990fcd9682b', '770e5d4d-75f2-4b4c-a339-93bea9b79bea', '77c0a03a-84ce-4c8a-adc8-3b39c6fe431d', '78aa15b8-a665-4aca-a9d2-4cbc01efe391', '795cb747-49fa-4475-99b4-bd068e09ea13', '79e35084-50e1-4085-8637-ce432b17a39f', '7a66566b-1fdf-4694-aa3d-755f19e83af7', '7a7c4475-c250-4540-9f7b-e186bb0a11d6', '7b05b860-c529-47a0-bfaa-74985381faa9', '7bb46df7-19dd-4447-aa45-fadfe0e1ed6c', '8005adc9-65c7-417c-92ae-35dfb5f23152', '80b51ffa-83ea-4eed-8511-66eec12f6b63', '822e4895-7da6-4946-9c39-de23bd4a1150', '8379a389-88e9-4e5c-b823-738a2ded8380', '868a55e1-31d3-4662-874e-8b005c9bd76d', '87e101a2-1933-443a-a22e-4523ff64638f', '89bf75ec-c55d-47a6-9699-dbaf9d4353d1', '8b49aa1c-b09e-4461-9dc5-598524559463', '8b4f0139-a7e8-4ae5-ace1-408d8a47baeb', '8c8ca4e3-01e8-4b22-a4b6-feea8f0c058f', '8cb5e6fd-c4a1-4ff9-a605-689a0c860831', '8d7fd3c8-5255-4f00-9cf9-d0313749504e', '8f3e3a52-e145-4562-a452-aa7a117ed8c1', '93088ef6-81f3-4a14-bdb2-a1ca0dd07bf5', '95636577-b96c-4b12-a97a-fec6044041ef', '95a1ed1f-ab9d-48c3-9274-0cd4c4a371fa', '95d3f1d6-7a90-4ce4-b0bb-ec9be7ff89c5', '97aa035c-d3eb-43b4-884b-bb5dbb51afe1', '995bf090-f5aa-4020-ac1e-3894cfd6dc45', '9b1d4753-d18f-4206-a699-5fc21a60b28b', '9b45085c-5b5e-4f38-ace2-c6b7de917937', '9c977ceb-c7df-44c5-99a5-f8f031422051', '9cc86f59-5944-4ffe-a446-e88f248de9f6', '9d30ed03-32f8-4a7b-b204-001e6a9a1924', '9d4fcd40-9ccd-4f41-9359-07b8e6d7c7c1', '9eec9718-2026-4a30-b6b0-522909dc8dc8', '9efe494d-b603-4d18-9672-a39f4a0818ac', 'a1d97d5b-f1c7-4a7f-ad28-ec85f8e3dd4c', 'a2461ad4-4b1b-4849-81f1-de02f9f21e71', 'a5959f44-0d85-490d-a867-b142f45b2c69', 'a5a8e3ca-194e-4bc9-b1b3-c7c4b027e71e', 'a61f43f1-77f0-4162-b3a3-4376cb8428ed', 'a78f38d7-e4f4-4476-8fe4-738d1f0e66ef', 'a7e43a58-46ae-431f-bfed-6a3c7247f239', 'a850730f-749c-44dc-b1b3-97a91864033c', 'a87ed843-a991-4e64-92aa-f77ca436b09a', 'a89c37c0-2948-4d27-8e67-0339dcb1e337', 'aa61a031-17b9-47d3-8ef3-19d65037b32c', 'aaa8dc4e-662f-4fb2-8c3d-773b6065519d', 'ab290cea-ddda-4b09-8c35-d03a9f9f7c7a', 'accbe0c1-4e52-4cfd-afb7-04bbac85b4a5', 'ad0ca7a7-77bb-45ff-a79f-03a3f43faec8', 'aefd91ce-5324-4bf9-a622-19caaf0ecf7b', 'b01dea8a-3d17-419e-b757-f00c3a2bbffd', 'b0b58ec9-820f-4a71-9d14-2f90dbad3bdc', 'b32f3cb7-4ddf-4be6-af95-b5fff38544b0', 'b6f2ec70-b8be-48d3-b22b-9c1726b743a1', 'b71f5403-8897-4722-8f01-cc17bec7da6e', 'b7d98113-a409-4a4f-ac8c-45db363c7503', 'b9f73034-703d-4cbf-806d-1d6ce58bd776', 'ba65e008-02df-4fb5-aee0-ba16159a1b87', 'bd3f257b-eb4d-4b91-acd8-8bd893277c19', 'bd8cbdcc-6106-4764-9a5c-a1793b2881fa', 'be85fe44-20a7-4e5c-9800-8b27d6dac19c', 'c0f20064-64b1-4399-9b6c-9a30aaff136c', 'c0fa8cb4-e942-48f9-a15e-f48ada94f23f', 'c2938976-acfd-4c2a-abfa-b529656f56c9') GROUP BY colorspec_uuid sec

67. SELECT * FROM tp_4over_product_option_rules WHERE category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' AND status = '1' sec

68 65. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145', 'c551d06d-446e-47c6-bf1b-4a1a22a4c981', 'c6f2e8f3-90af-4ad7-81ff-d106dd376a0c', 'c86b042a-66bf-42f8-8170-6d94ba12b2ae', 'c8adf6d3-c323-41bc-9251-8f7f4b8a7954', 'c8e79276-b5df-436e-8e7c-08b26dbf3833', 'c9652cac-04f1-4f39-85e9-6a63a77a6273', 'c9cf462f-b77b-4252-a215-3dff07ccf6bd', 'ca43e798-3ead-4995-ace6-7ee9f2294f5d', 'cba24b00-1040-4167-a601-76f07dc3cdf6', 'cc0cb867-9bda-475b-8706-3521df650102', 'ccc28d03-741f-448a-97bd-d270925038df', 'cccf4b7d-60f3-43d4-a23f-febda394d3bf', 'ce1aa9b3-6292-45cf-a7d4-35367d751977', 'cee365ec-848b-4f92-8903-fd894694b9ba', 'cf480ab0-4c18-4251-abc9-2a750d000731', 'd06b46a6-fc98-4804-b273-182075f8c7c9', 'd0d1042c-5e83-4007-9422-640c53a7b931', 'd60bdcb6-487a-4259-b47e-6d21b8e673f7', 'd6f4a2f1-6422-4f8f-bacc-8eccf49d6b5f', 'd826b868-0334-4cbe-aa07-d0c981825f4e', 'd89c5d98-a0e4-4433-9a16-9c1b1998d0a7', 'db8adc8c-73b2-4066-8fe7-6aa3add6d0af', 'dc6613d4-4a55-4538-8321-5d328c5b06b7', 'df0ea7c1-3142-4741-99dc-d46d80c2047b', 'df3d5ce7-9d30-4bf9-9ab3-c64e238d94e8', 'dfb14750-93c2-4f60-8bbe-8e1269a70b16', 'dfff49a5-6e87-44dd-9f80-4aeb41af333a', 'e096b602-cc34-4ff1-8891-ec57e4ef0043', 'e0cf0d4d-6479-4405-a9c6-bb6f717d99f5', 'e1dbcc05-20d7-411b-83f0-f033cb2cbac9', 'e23acc98-ade7-47e7-a51e-17587d633f04', 'e486e32b-4859-4f58-9f2a-92ff931ff987', 'e622ba2e-7b73-461d-8fa3-545be93f4b9c', 'e6d85d67-cf0c-4f5e-874f-b3e1150e34de', 'e6f96dee-0d23-45f3-a54f-b12c7f7eaa30', 'e71eb239-2ea4-4fd4-a7a8-9ee2eb4ec974', 'e856043f-b1d1-4f6f-b5f1-0c607a634e2c', 'e906a5df-a3a9-489d-b9d2-a48e1702d3d3', 'e920e2c3-6a08-4b9a-853e-4f78cac028bb', 'e92b082e-96ba-4bae-99ff-528f5ab03f0e', 'e99f4340-1e8e-4367-8fd0-3e8b6170b97a', 'e9c18117-3a24-4b44-b59a-5d537ae5cda0', 'e9dc0714-c8ee-4690-bd24-1091aba3e57b', 'e9dc42e3-1689-47a7-82f3-7af667bb42c4', 'eb7a7faa-1750-4a7e-8ce6-6560587b5ad6', 'ed21d4a7-2314-4f6a-8b87-6180fa108c29', 'ed8e4573-a2b0-4857-94a4-020da4c3b671', 'eea43f38-80e3-497a-bd24-4fde73e25ab3', 'f0e86be3-ccf9-47bf-8403-f631297e09f2', 'f11b879c-18f2-4147-a07e-6c39eca760b6', 'f1adb832-b270-4496-af12-b8dd2cac5907', 'f20bb4ea-1184-4c8f-b734-b066a92e8702', 'f2897a73-0da0-41c7-86bf-b2a10c8f3ee5', 'f4179bf4-0c63-45b5-b60a-b8dd47512905', 'f5bb7cda-a39d-4456-bb53-7157b0c9eced', 'f5eaa44e-ec85-4b0e-b4ba-b96685c10ac9', 'f6d152cc-eff4-4603-b2a4-4ea29e49229e', 'f6e154d5-b080-4bee-8a58-9617f018033b', 'f98ec19d-bb30-4afc-b336-fbc61fd74b9e', 'f9a75cd1-3c7d-49aa-a2ee-371eda1c306e', 'fa24923d-ba5b-44e3-9fc5-51c3a9ce50c2', 'fad3f652-3ca0-458c-bccd-c87c44fc76ac', 'fd3283b4-6bc6-4364-ac3e-95e8e6aba738', 'fd86de7b-50fb-4f52-a032-99b754ffbe29', '04d2a81b-596c-4f65-92a0-9bfc58e74d14', '053a2317-f1f1-483a-abb3-4d499ee6e60e', '0565f097-4d2e-4545-a99d-8a2bcebb62cf', '05f49550-9644-4e6a-8c13-316f8bce3e1d', '06fc3fd0-0311-42b4-997f-0d8b13a69456', '096504d8-3af1-4a7c-8399-994bed36cb87', '0a2a4ee2-621b-4a6a-b075-ae4352d70f38', '0cf6aae8-dc6e-4e34-abf1-565125bc07ff', '0d7599f4-a586-4109-ad59-8799fc62b831', '0d7a1bd1-82a0-435f-a590-90238fb0270d', '0e566192-89f4-416a-9be9-f374039000bf', '0eaf5028-7ca9-4c5d-b92d-fd5e5511d04d', '10787c49-47b4-44b7-9bcf-dd84e40a9707', '11fe5f70-e468-4f9e-b198-8822b1e29208', '16df57a9-8119-4f9b-b273-3d28dfd0b3ba', '17a5885e-4a88-4789-8ff1-ab27f196c200', '1925e03d-f0bc-4edb-b16c-c384205d1733', '1a6cbc54-79eb-448b-9f0d-38b7c893b3c7', '1bc61cb1-4ac8-462b-a861-025d622cdfc9', '1d314bcf-977b-460a-adf1-e179e7a7ef9b', '1e70303c-d267-46e4-8622-bf3e47d7219b', '1f070255-99a4-4166-95f6-6cbb5c28da32', '1f783550-28be-4f11-ae7e-ccb692542a59', '1fd56d78-02e4-4c06-8c09-dd9a4dec1812', '201aa5f1-0fe5-4eda-8dca-68612e7f1d3d', '2136a970-b836-458d-b80e-5a5ae238f9a2', '21bc75c1-7675-474f-bb30-3fa19cef1e27', '231d3839-aad1-4f28-b9fb-b244f954c1b8', '23adc580-4883-44d3-a339-4a60ba07ff28', '2475894a-d030-40f3-855a-069f94ed0228', '26ef79e8-904f-4e8f-baed-b4c44906178e', '278a26b9-fc92-4615-9c41-c59a5584e852', '2799262d-caef-45da-9b24-53f3a07c5706', '27dce3c4-d000-4ffa-a591-ad7909dd0e8a', '2b31e608-c57f-46fc-9309-55c6fdcc939d', '2c2d7116-5cf1-4b22-92ef-ae5eeed2e837', '2c420f57-93b6-44b9-97a1-7d4d59c04f67', '2f6c7f8d-a61d-4a88-8ff7-8504be36125b', '3135c6d2-c081-4fd8-a746-bd3b8a618e13', '32189f21-ebff-4141-8d63-219c7c48531d', '3260f5de-0796-4cdb-91c9-4bc6914acc40', '35757bb3-ee3a-4782-8e47-ca7f64e48047', '388a9263-5bd2-48e3-9b6f-2dfc0369a5ac', '3a1df359-3131-45ab-8e5b-5ffccd100149', '3a7adc27-fb3b-4988-8dc1-64e849ed0b41', '3ac51b85-4e8d-45fa-8740-4e4ce70f7c0c', '3ce21f66-557e-4cb6-8523-90be7f708e81', '3ce32317-35f7-4467-86f2-77e701cc8d56', '3d86b366-289b-46a3-b743-c03aa771e9a6', '3ed1f979-0338-4982-890b-5852acfda2dc', '40f78e38-c08e-4795-8a66-be226c4e1773', '41276bfc-fb9b-4ffd-8ce3-5ffb664a29d4', '412b721c-54f7-4b1a-911e-018fdf728863', '43488025-bdbc-4fbc-8707-9deda56a8963', '45752a63-dea4-4576-85d7-430cdf19e7de', '467b16ec-9741-4213-9b10-1f200377fc98', '491527b6-34ef-4e1f-b934-127335192457', '4a983cf6-1594-4412-b048-75216ca453f4', '4adadf9a-14ea-4f8d-afdf-4e5597cf9d66', '4aee9f9f-1bdc-45b1-a168-aa772a8adb73', '4b90a58b-f2be-43ec-9dac-d7643af339f5', '4ec2090f-ad29-4ae7-91d3-d28004c74884', '4eff1147-d863-4d59-a31c-7226479e2388', '50d8081b-42f6-4cc8-8951-d388abb65cd6', '5101f8dc-0a13-419d-9e80-5d0b89804813', '528de7bb-a49a-46dc-ada1-b0b6c7add42c', '535509fd-ed10-4fcb-ae4a-0c299e29f478', '5642e37a-80ff-4bbc-90e0-cea79cbba30e', '5a76d0b9-4a72-4946-bca5-7c6dc5df6303', '5b6c7361-e621-4966-9609-02e79e687b60', '5c07577a-c2fc-4171-bde3-dfbc3c6df7a8', '5cca92ef-cea4-49ea-8849-a954c989da36', '5d3e05ef-8b3e-455d-8ba9-10ddbea03b53', '5e7652ae-34b0-4010-b908-b1a4300c0960', '5e9a4787-762a-4f5b-b041-7ab6dfb57149', '5ecb2fa6-bff8-4663-b674-5d39c8a57797', '5ee54386-3640-469a-b294-62db599fc3ab', '5f018c2e-7701-4b85-a6bb-fb2269aab5c2', '5f91e870-6783-4ff5-87a0-e7fd865032a7', '60d3b41d-3675-4a0f-99f2-a2483f1541f5', '6139ef2a-0740-4c72-b7ef-31675b82757b', '61debef6-910c-4c9a-99bf-9f591fb0676a', '62a350b8-e2c8-4abe-ac08-a3a596dee525', '64233972-8a40-420c-89ef-9217aa5e1794', '6478d570-dc60-4258-b5b0-96db76d9fd26', '64d58fa1-869e-47e5-aa2a-35a94d57d4a3', '654d5bf1-0c2f-4cc1-8a36-631d206b45b4', '65f56164-f318-451f-8b6d-283535a62db2', '669e2c18-7960-4342-aeeb-ea39187378f3', '6741a673-d5af-42c6-b867-492ed0d9fe81', '67f62779-e839-4a72-a884-4328dd84b365', '680172ea-5e86-40b6-98ec-8c18173845e2', '6a31ea7e-645f-4a4c-b842-92336989be1d', '6d9627f5-4b5b-4e9f-8505-03a87a28426c', '6dcbdf76-7512-49ac-9051-b971b1317bd2', '6f50f552-7686-42f2-8a7c-66c5cf628598', '6fa93ffd-4ba6-4ae3-98e1-3dcf51c6411b', '6fdb0462-302a-4688-81d1-ae238a881957', '70f23b3f-da3b-4d53-ab06-c65773c49723', '720190bd-136c-453b-a83b-53cbc6c083b3', '72a56462-a10a-4d6d-b71b-aab704f8dafc', '731826f2-7340-4b80-8684-9337e82b74da', '739c4277-12e4-41e5-a096-d027a3b7a924', '741c13f6-6cdb-4f09-affd-ef6cbe7c2774', '75104202-e471-4451-9b8c-b8cc6ed30201', '76812272-e832-4525-bfde-0990fcd9682b', '770e5d4d-75f2-4b4c-a339-93bea9b79bea', '77c0a03a-84ce-4c8a-adc8-3b39c6fe431d', '78aa15b8-a665-4aca-a9d2-4cbc01efe391', '795cb747-49fa-4475-99b4-bd068e09ea13', '79e35084-50e1-4085-8637-ce432b17a39f', '7a66566b-1fdf-4694-aa3d-755f19e83af7', '7a7c4475-c250-4540-9f7b-e186bb0a11d6', '7b05b860-c529-47a0-bfaa-74985381faa9', '7bb46df7-19dd-4447-aa45-fadfe0e1ed6c', '8005adc9-65c7-417c-92ae-35dfb5f23152', '80b51ffa-83ea-4eed-8511-66eec12f6b63', '822e4895-7da6-4946-9c39-de23bd4a1150', '8379a389-88e9-4e5c-b823-738a2ded8380', '868a55e1-31d3-4662-874e-8b005c9bd76d', '87e101a2-1933-443a-a22e-4523ff64638f', '89bf75ec-c55d-47a6-9699-dbaf9d4353d1', '8b49aa1c-b09e-4461-9dc5-598524559463', '8b4f0139-a7e8-4ae5-ace1-408d8a47baeb', '8c8ca4e3-01e8-4b22-a4b6-feea8f0c058f', '8cb5e6fd-c4a1-4ff9-a605-689a0c860831', '8d7fd3c8-5255-4f00-9cf9-d0313749504e', '8f3e3a52-e145-4562-a452-aa7a117ed8c1', '93088ef6-81f3-4a14-bdb2-a1ca0dd07bf5', '95636577-b96c-4b12-a97a-fec6044041ef', '95a1ed1f-ab9d-48c3-9274-0cd4c4a371fa', '95d3f1d6-7a90-4ce4-b0bb-ec9be7ff89c5', '97aa035c-d3eb-43b4-884b-bb5dbb51afe1', '995bf090-f5aa-4020-ac1e-3894cfd6dc45', '9b1d4753-d18f-4206-a699-5fc21a60b28b', '9b45085c-5b5e-4f38-ace2-c6b7de917937', '9c977ceb-c7df-44c5-99a5-f8f031422051', '9cc86f59-5944-4ffe-a446-e88f248de9f6', '9d30ed03-32f8-4a7b-b204-001e6a9a1924', '9d4fcd40-9ccd-4f41-9359-07b8e6d7c7c1', '9eec9718-2026-4a30-b6b0-522909dc8dc8', '9efe494d-b603-4d18-9672-a39f4a0818ac', 'a1d97d5b-f1c7-4a7f-ad28-ec85f8e3dd4c', 'a2461ad4-4b1b-4849-81f1-de02f9f21e71', 'a5959f44-0d85-490d-a867-b142f45b2c69', 'a5a8e3ca-194e-4bc9-b1b3-c7c4b027e71e', 'a61f43f1-77f0-4162-b3a3-4376cb8428ed', 'a78f38d7-e4f4-4476-8fe4-738d1f0e66ef', 'a7e43a58-46ae-431f-bfed-6a3c7247f239', 'a850730f-749c-44dc-b1b3-97a91864033c', 'a87ed843-a991-4e64-92aa-f77ca436b09a', 'a89c37c0-2948-4d27-8e67-0339dcb1e337', 'aa61a031-17b9-47d3-8ef3-19d65037b32c', 'aaa8dc4e-662f-4fb2-8c3d-773b6065519d', 'ab290cea-ddda-4b09-8c35-d03a9f9f7c7a', 'accbe0c1-4e52-4cfd-afb7-04bbac85b4a5', 'ad0ca7a7-77bb-45ff-a79f-03a3f43faec8', 'aefd91ce-5324-4bf9-a622-19caaf0ecf7b', 'b01dea8a-3d17-419e-b757-f00c3a2bbffd', 'b0b58ec9-820f-4a71-9d14-2f90dbad3bdc', 'b32f3cb7-4ddf-4be6-af95-b5fff38544b0', 'b6f2ec70-b8be-48d3-b22b-9c1726b743a1', 'b71f5403-8897-4722-8f01-cc17bec7da6e', 'b7d98113-a409-4a4f-ac8c-45db363c7503', 'b9f73034-703d-4cbf-806d-1d6ce58bd776', 'ba65e008-02df-4fb5-aee0-ba16159a1b87', 'bd3f257b-eb4d-4b91-acd8-8bd893277c19', 'bd8cbdcc-6106-4764-9a5c-a1793b2881fa', 'be85fe44-20a7-4e5c-9800-8b27d6dac19c', 'c0f20064-64b1-4399-9b6c-9a30aaff136c', 'c0fa8cb4-e942-48f9-a15e-f48ada94f23f', 'c2938976-acfd-4c2a-abfa-b529656f56c9') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

69. SELECT product_uuid FROM tp_4over_products WHERE categories = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' And status = '1' sec

70. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = 'af949995-7444-490c-af35-c9ab635a2bef' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P9 INNER JOIN (SELECT t4pgo.product_uuid as pid_10 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '67ad8402-341f-4a0a-bd1a-b7fc64688a7f' AND t4pgo.option_uuid = '595a3499-310b-46ed-85bb-f7c14e223759' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P10 INNER JOIN (SELECT t4pgo.product_uuid as pid_11 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'f80e8179-b264-42ce-9f80-bb258a09a1fe' AND t4pgo.option_uuid = '9f85d0c4-d344-4088-a719-86f8f84d504d' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P11 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P1.pid_1 = P9.pid_9) AND (P1.pid_1 = P10.pid_10) AND (P1.pid_1 = P11.pid_11) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P2.pid_2 = P9.pid_9) AND (P2.pid_2 = P10.pid_10) AND (P2.pid_2 = P11.pid_11) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P3.pid_3 = P9.pid_9) AND (P3.pid_3 = P10.pid_10) AND (P3.pid_3 = P11.pid_11) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P4.pid_4 = P9.pid_9) AND (P4.pid_4 = P10.pid_10) AND (P4.pid_4 = P11.pid_11) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P5.pid_5 = P9.pid_9) AND (P5.pid_5 = P10.pid_10) AND (P5.pid_5 = P11.pid_11) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P6.pid_6 = P9.pid_9) AND (P6.pid_6 = P10.pid_10) AND (P6.pid_6 = P11.pid_11) AND (P7.pid_7 = P8.pid_8) AND (P7.pid_7 = P9.pid_9) AND (P7.pid_7 = P10.pid_10) AND (P7.pid_7 = P11.pid_11) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P8.pid_8 = P11.pid_11) AND (P9.pid_9 = P10.pid_10) AND (P9.pid_9 = P11.pid_11) AND (P10.pid_10 = P11.pid_11) sec

71. SELECT DISTINCT(FPAG.product_uuid) as product_uuid FROM tp_4over_product_group_option_master AS FPAG LEFT JOIN tp_4over_products as FP ON FP.product_uuid = FPAG.product_uuid AND FP.status = '1' WHERE FPAG.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND FP.categories = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

73. SELECT tp_4over_product_group_option_master.option_group_uuid,prd_grp_mst.option_group_name,count(tp_4over_product_group_option_master.option_group_uuid) grp_opt_cnt FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as prd_grp_mst ON prd_grp_mst.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' GROUP BY tp_4over_product_group_option_master.option_group_uuid sec

74. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name IN ('PRODUCT_APPLY_SETUP_COST', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'PRODUCT_HIRE_DESIGNER_COST', 'PRODUCT_UPDATE_PRICE_TABLE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_CUT_OFF_TIME', 'PRODUCT_DESC_HIRE_DESIGNER_OPTION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_OPTION_LABEL', 'PRODUCT_HIRE_DESIGNER_NO', 'PRODUCT_HIRE_DESIGNER_YES') sec

(Cached) c8ddd73ab1d6dcc43b995d82967ab39f

75 65. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145', 'c551d06d-446e-47c6-bf1b-4a1a22a4c981', 'c6f2e8f3-90af-4ad7-81ff-d106dd376a0c', 'c86b042a-66bf-42f8-8170-6d94ba12b2ae', 'c8adf6d3-c323-41bc-9251-8f7f4b8a7954', 'c8e79276-b5df-436e-8e7c-08b26dbf3833', 'c9652cac-04f1-4f39-85e9-6a63a77a6273', 'c9cf462f-b77b-4252-a215-3dff07ccf6bd', 'ca43e798-3ead-4995-ace6-7ee9f2294f5d', 'cba24b00-1040-4167-a601-76f07dc3cdf6', 'cc0cb867-9bda-475b-8706-3521df650102', 'ccc28d03-741f-448a-97bd-d270925038df', 'cccf4b7d-60f3-43d4-a23f-febda394d3bf', 'ce1aa9b3-6292-45cf-a7d4-35367d751977', 'cee365ec-848b-4f92-8903-fd894694b9ba', 'cf480ab0-4c18-4251-abc9-2a750d000731', 'd06b46a6-fc98-4804-b273-182075f8c7c9', 'd0d1042c-5e83-4007-9422-640c53a7b931', 'd60bdcb6-487a-4259-b47e-6d21b8e673f7', 'd6f4a2f1-6422-4f8f-bacc-8eccf49d6b5f', 'd826b868-0334-4cbe-aa07-d0c981825f4e', 'd89c5d98-a0e4-4433-9a16-9c1b1998d0a7', 'db8adc8c-73b2-4066-8fe7-6aa3add6d0af', 'dc6613d4-4a55-4538-8321-5d328c5b06b7', 'df0ea7c1-3142-4741-99dc-d46d80c2047b', 'df3d5ce7-9d30-4bf9-9ab3-c64e238d94e8', 'dfb14750-93c2-4f60-8bbe-8e1269a70b16', 'dfff49a5-6e87-44dd-9f80-4aeb41af333a', 'e096b602-cc34-4ff1-8891-ec57e4ef0043', 'e0cf0d4d-6479-4405-a9c6-bb6f717d99f5', 'e1dbcc05-20d7-411b-83f0-f033cb2cbac9', 'e23acc98-ade7-47e7-a51e-17587d633f04', 'e486e32b-4859-4f58-9f2a-92ff931ff987', 'e622ba2e-7b73-461d-8fa3-545be93f4b9c', 'e6d85d67-cf0c-4f5e-874f-b3e1150e34de', 'e6f96dee-0d23-45f3-a54f-b12c7f7eaa30', 'e71eb239-2ea4-4fd4-a7a8-9ee2eb4ec974', 'e856043f-b1d1-4f6f-b5f1-0c607a634e2c', 'e906a5df-a3a9-489d-b9d2-a48e1702d3d3', 'e920e2c3-6a08-4b9a-853e-4f78cac028bb', 'e92b082e-96ba-4bae-99ff-528f5ab03f0e', 'e99f4340-1e8e-4367-8fd0-3e8b6170b97a', 'e9c18117-3a24-4b44-b59a-5d537ae5cda0', 'e9dc0714-c8ee-4690-bd24-1091aba3e57b', 'e9dc42e3-1689-47a7-82f3-7af667bb42c4', 'eb7a7faa-1750-4a7e-8ce6-6560587b5ad6', 'ed21d4a7-2314-4f6a-8b87-6180fa108c29', 'ed8e4573-a2b0-4857-94a4-020da4c3b671', 'eea43f38-80e3-497a-bd24-4fde73e25ab3', 'f0e86be3-ccf9-47bf-8403-f631297e09f2', 'f11b879c-18f2-4147-a07e-6c39eca760b6', 'f1adb832-b270-4496-af12-b8dd2cac5907', 'f20bb4ea-1184-4c8f-b734-b066a92e8702', 'f2897a73-0da0-41c7-86bf-b2a10c8f3ee5', 'f4179bf4-0c63-45b5-b60a-b8dd47512905', 'f5bb7cda-a39d-4456-bb53-7157b0c9eced', 'f5eaa44e-ec85-4b0e-b4ba-b96685c10ac9', 'f6d152cc-eff4-4603-b2a4-4ea29e49229e', 'f6e154d5-b080-4bee-8a58-9617f018033b', 'f98ec19d-bb30-4afc-b336-fbc61fd74b9e', 'f9a75cd1-3c7d-49aa-a2ee-371eda1c306e', 'fa24923d-ba5b-44e3-9fc5-51c3a9ce50c2', 'fad3f652-3ca0-458c-bccd-c87c44fc76ac', 'fd3283b4-6bc6-4364-ac3e-95e8e6aba738', 'fd86de7b-50fb-4f52-a032-99b754ffbe29', '04d2a81b-596c-4f65-92a0-9bfc58e74d14', '053a2317-f1f1-483a-abb3-4d499ee6e60e', '0565f097-4d2e-4545-a99d-8a2bcebb62cf', '05f49550-9644-4e6a-8c13-316f8bce3e1d', '06fc3fd0-0311-42b4-997f-0d8b13a69456', '096504d8-3af1-4a7c-8399-994bed36cb87', '0a2a4ee2-621b-4a6a-b075-ae4352d70f38', '0cf6aae8-dc6e-4e34-abf1-565125bc07ff', '0d7599f4-a586-4109-ad59-8799fc62b831', '0d7a1bd1-82a0-435f-a590-90238fb0270d', '0e566192-89f4-416a-9be9-f374039000bf', '0eaf5028-7ca9-4c5d-b92d-fd5e5511d04d', '10787c49-47b4-44b7-9bcf-dd84e40a9707', '11fe5f70-e468-4f9e-b198-8822b1e29208', '16df57a9-8119-4f9b-b273-3d28dfd0b3ba', '17a5885e-4a88-4789-8ff1-ab27f196c200', '1925e03d-f0bc-4edb-b16c-c384205d1733', '1a6cbc54-79eb-448b-9f0d-38b7c893b3c7', '1bc61cb1-4ac8-462b-a861-025d622cdfc9', '1d314bcf-977b-460a-adf1-e179e7a7ef9b', '1e70303c-d267-46e4-8622-bf3e47d7219b', '1f070255-99a4-4166-95f6-6cbb5c28da32', '1f783550-28be-4f11-ae7e-ccb692542a59', '1fd56d78-02e4-4c06-8c09-dd9a4dec1812', '201aa5f1-0fe5-4eda-8dca-68612e7f1d3d', '2136a970-b836-458d-b80e-5a5ae238f9a2', '21bc75c1-7675-474f-bb30-3fa19cef1e27', '231d3839-aad1-4f28-b9fb-b244f954c1b8', '23adc580-4883-44d3-a339-4a60ba07ff28', '2475894a-d030-40f3-855a-069f94ed0228', '26ef79e8-904f-4e8f-baed-b4c44906178e', '278a26b9-fc92-4615-9c41-c59a5584e852', '2799262d-caef-45da-9b24-53f3a07c5706', '27dce3c4-d000-4ffa-a591-ad7909dd0e8a', '2b31e608-c57f-46fc-9309-55c6fdcc939d', '2c2d7116-5cf1-4b22-92ef-ae5eeed2e837', '2c420f57-93b6-44b9-97a1-7d4d59c04f67', '2f6c7f8d-a61d-4a88-8ff7-8504be36125b', '3135c6d2-c081-4fd8-a746-bd3b8a618e13', '32189f21-ebff-4141-8d63-219c7c48531d', '3260f5de-0796-4cdb-91c9-4bc6914acc40', '35757bb3-ee3a-4782-8e47-ca7f64e48047', '388a9263-5bd2-48e3-9b6f-2dfc0369a5ac', '3a1df359-3131-45ab-8e5b-5ffccd100149', '3a7adc27-fb3b-4988-8dc1-64e849ed0b41', '3ac51b85-4e8d-45fa-8740-4e4ce70f7c0c', '3ce21f66-557e-4cb6-8523-90be7f708e81', '3ce32317-35f7-4467-86f2-77e701cc8d56', '3d86b366-289b-46a3-b743-c03aa771e9a6', '3ed1f979-0338-4982-890b-5852acfda2dc', '40f78e38-c08e-4795-8a66-be226c4e1773', '41276bfc-fb9b-4ffd-8ce3-5ffb664a29d4', '412b721c-54f7-4b1a-911e-018fdf728863', '43488025-bdbc-4fbc-8707-9deda56a8963', '45752a63-dea4-4576-85d7-430cdf19e7de', '467b16ec-9741-4213-9b10-1f200377fc98', '491527b6-34ef-4e1f-b934-127335192457', '4a983cf6-1594-4412-b048-75216ca453f4', '4adadf9a-14ea-4f8d-afdf-4e5597cf9d66', '4aee9f9f-1bdc-45b1-a168-aa772a8adb73', '4b90a58b-f2be-43ec-9dac-d7643af339f5', '4ec2090f-ad29-4ae7-91d3-d28004c74884', '4eff1147-d863-4d59-a31c-7226479e2388', '50d8081b-42f6-4cc8-8951-d388abb65cd6', '5101f8dc-0a13-419d-9e80-5d0b89804813', '528de7bb-a49a-46dc-ada1-b0b6c7add42c', '535509fd-ed10-4fcb-ae4a-0c299e29f478', '5642e37a-80ff-4bbc-90e0-cea79cbba30e', '5a76d0b9-4a72-4946-bca5-7c6dc5df6303', '5b6c7361-e621-4966-9609-02e79e687b60', '5c07577a-c2fc-4171-bde3-dfbc3c6df7a8', '5cca92ef-cea4-49ea-8849-a954c989da36', '5d3e05ef-8b3e-455d-8ba9-10ddbea03b53', '5e7652ae-34b0-4010-b908-b1a4300c0960', '5e9a4787-762a-4f5b-b041-7ab6dfb57149', '5ecb2fa6-bff8-4663-b674-5d39c8a57797', '5ee54386-3640-469a-b294-62db599fc3ab', '5f018c2e-7701-4b85-a6bb-fb2269aab5c2', '5f91e870-6783-4ff5-87a0-e7fd865032a7', '60d3b41d-3675-4a0f-99f2-a2483f1541f5', '6139ef2a-0740-4c72-b7ef-31675b82757b', '61debef6-910c-4c9a-99bf-9f591fb0676a', '62a350b8-e2c8-4abe-ac08-a3a596dee525', '64233972-8a40-420c-89ef-9217aa5e1794', '6478d570-dc60-4258-b5b0-96db76d9fd26', '64d58fa1-869e-47e5-aa2a-35a94d57d4a3', '654d5bf1-0c2f-4cc1-8a36-631d206b45b4', '65f56164-f318-451f-8b6d-283535a62db2', '669e2c18-7960-4342-aeeb-ea39187378f3', '6741a673-d5af-42c6-b867-492ed0d9fe81', '67f62779-e839-4a72-a884-4328dd84b365', '680172ea-5e86-40b6-98ec-8c18173845e2', '6a31ea7e-645f-4a4c-b842-92336989be1d', '6d9627f5-4b5b-4e9f-8505-03a87a28426c', '6dcbdf76-7512-49ac-9051-b971b1317bd2', '6f50f552-7686-42f2-8a7c-66c5cf628598', '6fa93ffd-4ba6-4ae3-98e1-3dcf51c6411b', '6fdb0462-302a-4688-81d1-ae238a881957', '70f23b3f-da3b-4d53-ab06-c65773c49723', '720190bd-136c-453b-a83b-53cbc6c083b3', '72a56462-a10a-4d6d-b71b-aab704f8dafc', '731826f2-7340-4b80-8684-9337e82b74da', '739c4277-12e4-41e5-a096-d027a3b7a924', '741c13f6-6cdb-4f09-affd-ef6cbe7c2774', '75104202-e471-4451-9b8c-b8cc6ed30201', '76812272-e832-4525-bfde-0990fcd9682b', '770e5d4d-75f2-4b4c-a339-93bea9b79bea', '77c0a03a-84ce-4c8a-adc8-3b39c6fe431d', '78aa15b8-a665-4aca-a9d2-4cbc01efe391', '795cb747-49fa-4475-99b4-bd068e09ea13', '79e35084-50e1-4085-8637-ce432b17a39f', '7a66566b-1fdf-4694-aa3d-755f19e83af7', '7a7c4475-c250-4540-9f7b-e186bb0a11d6', '7b05b860-c529-47a0-bfaa-74985381faa9', '7bb46df7-19dd-4447-aa45-fadfe0e1ed6c', '8005adc9-65c7-417c-92ae-35dfb5f23152', '80b51ffa-83ea-4eed-8511-66eec12f6b63', '822e4895-7da6-4946-9c39-de23bd4a1150', '8379a389-88e9-4e5c-b823-738a2ded8380', '868a55e1-31d3-4662-874e-8b005c9bd76d', '87e101a2-1933-443a-a22e-4523ff64638f', '89bf75ec-c55d-47a6-9699-dbaf9d4353d1', '8b49aa1c-b09e-4461-9dc5-598524559463', '8b4f0139-a7e8-4ae5-ace1-408d8a47baeb', '8c8ca4e3-01e8-4b22-a4b6-feea8f0c058f', '8cb5e6fd-c4a1-4ff9-a605-689a0c860831', '8d7fd3c8-5255-4f00-9cf9-d0313749504e', '8f3e3a52-e145-4562-a452-aa7a117ed8c1', '93088ef6-81f3-4a14-bdb2-a1ca0dd07bf5', '95636577-b96c-4b12-a97a-fec6044041ef', '95a1ed1f-ab9d-48c3-9274-0cd4c4a371fa', '95d3f1d6-7a90-4ce4-b0bb-ec9be7ff89c5', '97aa035c-d3eb-43b4-884b-bb5dbb51afe1', '995bf090-f5aa-4020-ac1e-3894cfd6dc45', '9b1d4753-d18f-4206-a699-5fc21a60b28b', '9b45085c-5b5e-4f38-ace2-c6b7de917937', '9c977ceb-c7df-44c5-99a5-f8f031422051', '9cc86f59-5944-4ffe-a446-e88f248de9f6', '9d30ed03-32f8-4a7b-b204-001e6a9a1924', '9d4fcd40-9ccd-4f41-9359-07b8e6d7c7c1', '9eec9718-2026-4a30-b6b0-522909dc8dc8', '9efe494d-b603-4d18-9672-a39f4a0818ac', 'a1d97d5b-f1c7-4a7f-ad28-ec85f8e3dd4c', 'a2461ad4-4b1b-4849-81f1-de02f9f21e71', 'a5959f44-0d85-490d-a867-b142f45b2c69', 'a5a8e3ca-194e-4bc9-b1b3-c7c4b027e71e', 'a61f43f1-77f0-4162-b3a3-4376cb8428ed', 'a78f38d7-e4f4-4476-8fe4-738d1f0e66ef', 'a7e43a58-46ae-431f-bfed-6a3c7247f239', 'a850730f-749c-44dc-b1b3-97a91864033c', 'a87ed843-a991-4e64-92aa-f77ca436b09a', 'a89c37c0-2948-4d27-8e67-0339dcb1e337', 'aa61a031-17b9-47d3-8ef3-19d65037b32c', 'aaa8dc4e-662f-4fb2-8c3d-773b6065519d', 'ab290cea-ddda-4b09-8c35-d03a9f9f7c7a', 'accbe0c1-4e52-4cfd-afb7-04bbac85b4a5', 'ad0ca7a7-77bb-45ff-a79f-03a3f43faec8', 'aefd91ce-5324-4bf9-a622-19caaf0ecf7b', 'b01dea8a-3d17-419e-b757-f00c3a2bbffd', 'b0b58ec9-820f-4a71-9d14-2f90dbad3bdc', 'b32f3cb7-4ddf-4be6-af95-b5fff38544b0', 'b6f2ec70-b8be-48d3-b22b-9c1726b743a1', 'b71f5403-8897-4722-8f01-cc17bec7da6e', 'b7d98113-a409-4a4f-ac8c-45db363c7503', 'b9f73034-703d-4cbf-806d-1d6ce58bd776', 'ba65e008-02df-4fb5-aee0-ba16159a1b87', 'bd3f257b-eb4d-4b91-acd8-8bd893277c19', 'bd8cbdcc-6106-4764-9a5c-a1793b2881fa', 'be85fe44-20a7-4e5c-9800-8b27d6dac19c', 'c0f20064-64b1-4399-9b6c-9a30aaff136c', 'c0fa8cb4-e942-48f9-a15e-f48ada94f23f', 'c2938976-acfd-4c2a-abfa-b529656f56c9') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

76. SELECT DISTINCT product_uuid FROM (SELECT t4pgo.product_uuid FROM tp_4over_product_group_option_master as t4pgo LEFT JOIN tp_4over_products as FP ON FP.product_uuid = t4pgo.product_uuid WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND FP.status = '1' AND FP.categories = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as product_data sec

77. SELECT DISTINCT(FPAG.product_uuid) as product_uuid FROM tp_4over_product_group_option_master AS FPAG LEFT JOIN tp_4over_products as FP ON FP.product_uuid = FPAG.product_uuid AND FP.status = '1' WHERE FPAG.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145', 'c551d06d-446e-47c6-bf1b-4a1a22a4c981', 'c6f2e8f3-90af-4ad7-81ff-d106dd376a0c', 'c86b042a-66bf-42f8-8170-6d94ba12b2ae', 'c8adf6d3-c323-41bc-9251-8f7f4b8a7954', 'c8e79276-b5df-436e-8e7c-08b26dbf3833', 'c9652cac-04f1-4f39-85e9-6a63a77a6273', 'c9cf462f-b77b-4252-a215-3dff07ccf6bd', 'ca43e798-3ead-4995-ace6-7ee9f2294f5d', 'cba24b00-1040-4167-a601-76f07dc3cdf6', 'cc0cb867-9bda-475b-8706-3521df650102', 'ccc28d03-741f-448a-97bd-d270925038df', 'cccf4b7d-60f3-43d4-a23f-febda394d3bf', 'ce1aa9b3-6292-45cf-a7d4-35367d751977', 'cee365ec-848b-4f92-8903-fd894694b9ba', 'cf480ab0-4c18-4251-abc9-2a750d000731', 'd06b46a6-fc98-4804-b273-182075f8c7c9', 'd0d1042c-5e83-4007-9422-640c53a7b931', 'd60bdcb6-487a-4259-b47e-6d21b8e673f7', 'd6f4a2f1-6422-4f8f-bacc-8eccf49d6b5f', 'd826b868-0334-4cbe-aa07-d0c981825f4e', 'd89c5d98-a0e4-4433-9a16-9c1b1998d0a7', 'db8adc8c-73b2-4066-8fe7-6aa3add6d0af', 'dc6613d4-4a55-4538-8321-5d328c5b06b7', 'df0ea7c1-3142-4741-99dc-d46d80c2047b', 'df3d5ce7-9d30-4bf9-9ab3-c64e238d94e8', 'dfb14750-93c2-4f60-8bbe-8e1269a70b16', 'dfff49a5-6e87-44dd-9f80-4aeb41af333a', 'e096b602-cc34-4ff1-8891-ec57e4ef0043', 'e0cf0d4d-6479-4405-a9c6-bb6f717d99f5', 'e1dbcc05-20d7-411b-83f0-f033cb2cbac9', 'e23acc98-ade7-47e7-a51e-17587d633f04', 'e486e32b-4859-4f58-9f2a-92ff931ff987', 'e622ba2e-7b73-461d-8fa3-545be93f4b9c', 'e6d85d67-cf0c-4f5e-874f-b3e1150e34de', 'e6f96dee-0d23-45f3-a54f-b12c7f7eaa30', 'e71eb239-2ea4-4fd4-a7a8-9ee2eb4ec974', 'e856043f-b1d1-4f6f-b5f1-0c607a634e2c', 'e906a5df-a3a9-489d-b9d2-a48e1702d3d3', 'e920e2c3-6a08-4b9a-853e-4f78cac028bb', 'e92b082e-96ba-4bae-99ff-528f5ab03f0e', 'e99f4340-1e8e-4367-8fd0-3e8b6170b97a', 'e9c18117-3a24-4b44-b59a-5d537ae5cda0', 'e9dc0714-c8ee-4690-bd24-1091aba3e57b', 'e9dc42e3-1689-47a7-82f3-7af667bb42c4', 'eb7a7faa-1750-4a7e-8ce6-6560587b5ad6', 'ed21d4a7-2314-4f6a-8b87-6180fa108c29', 'ed8e4573-a2b0-4857-94a4-020da4c3b671', 'eea43f38-80e3-497a-bd24-4fde73e25ab3', 'f0e86be3-ccf9-47bf-8403-f631297e09f2', 'f11b879c-18f2-4147-a07e-6c39eca760b6', 'f1adb832-b270-4496-af12-b8dd2cac5907', 'f20bb4ea-1184-4c8f-b734-b066a92e8702', 'f2897a73-0da0-41c7-86bf-b2a10c8f3ee5', 'f4179bf4-0c63-45b5-b60a-b8dd47512905', 'f5bb7cda-a39d-4456-bb53-7157b0c9eced', 'f5eaa44e-ec85-4b0e-b4ba-b96685c10ac9', 'f6d152cc-eff4-4603-b2a4-4ea29e49229e', 'f6e154d5-b080-4bee-8a58-9617f018033b', 'f98ec19d-bb30-4afc-b336-fbc61fd74b9e', 'f9a75cd1-3c7d-49aa-a2ee-371eda1c306e', 'fa24923d-ba5b-44e3-9fc5-51c3a9ce50c2', 'fad3f652-3ca0-458c-bccd-c87c44fc76ac', 'fd3283b4-6bc6-4364-ac3e-95e8e6aba738', 'fd86de7b-50fb-4f52-a032-99b754ffbe29', '04d2a81b-596c-4f65-92a0-9bfc58e74d14', '053a2317-f1f1-483a-abb3-4d499ee6e60e', '0565f097-4d2e-4545-a99d-8a2bcebb62cf', '05f49550-9644-4e6a-8c13-316f8bce3e1d', '06fc3fd0-0311-42b4-997f-0d8b13a69456', '096504d8-3af1-4a7c-8399-994bed36cb87', '0a2a4ee2-621b-4a6a-b075-ae4352d70f38', '0cf6aae8-dc6e-4e34-abf1-565125bc07ff', '0d7599f4-a586-4109-ad59-8799fc62b831', '0d7a1bd1-82a0-435f-a590-90238fb0270d', '0e566192-89f4-416a-9be9-f374039000bf', '0eaf5028-7ca9-4c5d-b92d-fd5e5511d04d', '10787c49-47b4-44b7-9bcf-dd84e40a9707', '11fe5f70-e468-4f9e-b198-8822b1e29208', '16df57a9-8119-4f9b-b273-3d28dfd0b3ba', '17a5885e-4a88-4789-8ff1-ab27f196c200', '1925e03d-f0bc-4edb-b16c-c384205d1733', '1a6cbc54-79eb-448b-9f0d-38b7c893b3c7', '1bc61cb1-4ac8-462b-a861-025d622cdfc9', '1d314bcf-977b-460a-adf1-e179e7a7ef9b', '1e70303c-d267-46e4-8622-bf3e47d7219b', '1f070255-99a4-4166-95f6-6cbb5c28da32', '1f783550-28be-4f11-ae7e-ccb692542a59', '1fd56d78-02e4-4c06-8c09-dd9a4dec1812', '201aa5f1-0fe5-4eda-8dca-68612e7f1d3d', '2136a970-b836-458d-b80e-5a5ae238f9a2', '21bc75c1-7675-474f-bb30-3fa19cef1e27', '231d3839-aad1-4f28-b9fb-b244f954c1b8', '23adc580-4883-44d3-a339-4a60ba07ff28', '2475894a-d030-40f3-855a-069f94ed0228', '26ef79e8-904f-4e8f-baed-b4c44906178e', '278a26b9-fc92-4615-9c41-c59a5584e852', '2799262d-caef-45da-9b24-53f3a07c5706', '27dce3c4-d000-4ffa-a591-ad7909dd0e8a', '2b31e608-c57f-46fc-9309-55c6fdcc939d', '2c2d7116-5cf1-4b22-92ef-ae5eeed2e837', '2c420f57-93b6-44b9-97a1-7d4d59c04f67', '2f6c7f8d-a61d-4a88-8ff7-8504be36125b', '3135c6d2-c081-4fd8-a746-bd3b8a618e13', '32189f21-ebff-4141-8d63-219c7c48531d', '3260f5de-0796-4cdb-91c9-4bc6914acc40', '35757bb3-ee3a-4782-8e47-ca7f64e48047', '388a9263-5bd2-48e3-9b6f-2dfc0369a5ac', '3a1df359-3131-45ab-8e5b-5ffccd100149', '3a7adc27-fb3b-4988-8dc1-64e849ed0b41', '3ac51b85-4e8d-45fa-8740-4e4ce70f7c0c', '3ce21f66-557e-4cb6-8523-90be7f708e81', '3ce32317-35f7-4467-86f2-77e701cc8d56', '3d86b366-289b-46a3-b743-c03aa771e9a6', '3ed1f979-0338-4982-890b-5852acfda2dc', '40f78e38-c08e-4795-8a66-be226c4e1773', '41276bfc-fb9b-4ffd-8ce3-5ffb664a29d4', '412b721c-54f7-4b1a-911e-018fdf728863', '43488025-bdbc-4fbc-8707-9deda56a8963', '45752a63-dea4-4576-85d7-430cdf19e7de', '467b16ec-9741-4213-9b10-1f200377fc98', '491527b6-34ef-4e1f-b934-127335192457', '4a983cf6-1594-4412-b048-75216ca453f4', '4adadf9a-14ea-4f8d-afdf-4e5597cf9d66', '4aee9f9f-1bdc-45b1-a168-aa772a8adb73', '4b90a58b-f2be-43ec-9dac-d7643af339f5', '4ec2090f-ad29-4ae7-91d3-d28004c74884', '4eff1147-d863-4d59-a31c-7226479e2388', '50d8081b-42f6-4cc8-8951-d388abb65cd6', '5101f8dc-0a13-419d-9e80-5d0b89804813', '528de7bb-a49a-46dc-ada1-b0b6c7add42c', '535509fd-ed10-4fcb-ae4a-0c299e29f478', '5642e37a-80ff-4bbc-90e0-cea79cbba30e', '5a76d0b9-4a72-4946-bca5-7c6dc5df6303', '5b6c7361-e621-4966-9609-02e79e687b60', '5c07577a-c2fc-4171-bde3-dfbc3c6df7a8', '5cca92ef-cea4-49ea-8849-a954c989da36', '5d3e05ef-8b3e-455d-8ba9-10ddbea03b53', '5e7652ae-34b0-4010-b908-b1a4300c0960', '5e9a4787-762a-4f5b-b041-7ab6dfb57149', '5ecb2fa6-bff8-4663-b674-5d39c8a57797', '5ee54386-3640-469a-b294-62db599fc3ab', '5f018c2e-7701-4b85-a6bb-fb2269aab5c2', '5f91e870-6783-4ff5-87a0-e7fd865032a7', '60d3b41d-3675-4a0f-99f2-a2483f1541f5', '6139ef2a-0740-4c72-b7ef-31675b82757b', '61debef6-910c-4c9a-99bf-9f591fb0676a', '62a350b8-e2c8-4abe-ac08-a3a596dee525', '64233972-8a40-420c-89ef-9217aa5e1794', '6478d570-dc60-4258-b5b0-96db76d9fd26', '64d58fa1-869e-47e5-aa2a-35a94d57d4a3', '654d5bf1-0c2f-4cc1-8a36-631d206b45b4', '65f56164-f318-451f-8b6d-283535a62db2', '669e2c18-7960-4342-aeeb-ea39187378f3', '6741a673-d5af-42c6-b867-492ed0d9fe81', '67f62779-e839-4a72-a884-4328dd84b365', '680172ea-5e86-40b6-98ec-8c18173845e2', '6a31ea7e-645f-4a4c-b842-92336989be1d', '6d9627f5-4b5b-4e9f-8505-03a87a28426c', '6dcbdf76-7512-49ac-9051-b971b1317bd2', '6f50f552-7686-42f2-8a7c-66c5cf628598', '6fa93ffd-4ba6-4ae3-98e1-3dcf51c6411b', '6fdb0462-302a-4688-81d1-ae238a881957', '70f23b3f-da3b-4d53-ab06-c65773c49723', '720190bd-136c-453b-a83b-53cbc6c083b3', '72a56462-a10a-4d6d-b71b-aab704f8dafc', '731826f2-7340-4b80-8684-9337e82b74da', '739c4277-12e4-41e5-a096-d027a3b7a924', '741c13f6-6cdb-4f09-affd-ef6cbe7c2774', '75104202-e471-4451-9b8c-b8cc6ed30201', '76812272-e832-4525-bfde-0990fcd9682b', '770e5d4d-75f2-4b4c-a339-93bea9b79bea', '77c0a03a-84ce-4c8a-adc8-3b39c6fe431d', '78aa15b8-a665-4aca-a9d2-4cbc01efe391', '795cb747-49fa-4475-99b4-bd068e09ea13', '79e35084-50e1-4085-8637-ce432b17a39f', '7a66566b-1fdf-4694-aa3d-755f19e83af7', '7a7c4475-c250-4540-9f7b-e186bb0a11d6', '7b05b860-c529-47a0-bfaa-74985381faa9', '7bb46df7-19dd-4447-aa45-fadfe0e1ed6c', '8005adc9-65c7-417c-92ae-35dfb5f23152', '80b51ffa-83ea-4eed-8511-66eec12f6b63', '822e4895-7da6-4946-9c39-de23bd4a1150', '8379a389-88e9-4e5c-b823-738a2ded8380', '868a55e1-31d3-4662-874e-8b005c9bd76d', '87e101a2-1933-443a-a22e-4523ff64638f', '89bf75ec-c55d-47a6-9699-dbaf9d4353d1', '8b49aa1c-b09e-4461-9dc5-598524559463', '8b4f0139-a7e8-4ae5-ace1-408d8a47baeb', '8c8ca4e3-01e8-4b22-a4b6-feea8f0c058f', '8cb5e6fd-c4a1-4ff9-a605-689a0c860831', '8d7fd3c8-5255-4f00-9cf9-d0313749504e', '8f3e3a52-e145-4562-a452-aa7a117ed8c1', '93088ef6-81f3-4a14-bdb2-a1ca0dd07bf5', '95636577-b96c-4b12-a97a-fec6044041ef', '95a1ed1f-ab9d-48c3-9274-0cd4c4a371fa', '95d3f1d6-7a90-4ce4-b0bb-ec9be7ff89c5', '97aa035c-d3eb-43b4-884b-bb5dbb51afe1', '995bf090-f5aa-4020-ac1e-3894cfd6dc45', '9b1d4753-d18f-4206-a699-5fc21a60b28b', '9b45085c-5b5e-4f38-ace2-c6b7de917937', '9c977ceb-c7df-44c5-99a5-f8f031422051', '9cc86f59-5944-4ffe-a446-e88f248de9f6', '9d30ed03-32f8-4a7b-b204-001e6a9a1924', '9d4fcd40-9ccd-4f41-9359-07b8e6d7c7c1', '9eec9718-2026-4a30-b6b0-522909dc8dc8', '9efe494d-b603-4d18-9672-a39f4a0818ac', 'a1d97d5b-f1c7-4a7f-ad28-ec85f8e3dd4c', 'a2461ad4-4b1b-4849-81f1-de02f9f21e71', 'a5959f44-0d85-490d-a867-b142f45b2c69', 'a5a8e3ca-194e-4bc9-b1b3-c7c4b027e71e', 'a61f43f1-77f0-4162-b3a3-4376cb8428ed', 'a78f38d7-e4f4-4476-8fe4-738d1f0e66ef', 'a7e43a58-46ae-431f-bfed-6a3c7247f239', 'a850730f-749c-44dc-b1b3-97a91864033c', 'a87ed843-a991-4e64-92aa-f77ca436b09a', 'a89c37c0-2948-4d27-8e67-0339dcb1e337', 'aa61a031-17b9-47d3-8ef3-19d65037b32c', 'aaa8dc4e-662f-4fb2-8c3d-773b6065519d', 'ab290cea-ddda-4b09-8c35-d03a9f9f7c7a', 'accbe0c1-4e52-4cfd-afb7-04bbac85b4a5', 'ad0ca7a7-77bb-45ff-a79f-03a3f43faec8', 'aefd91ce-5324-4bf9-a622-19caaf0ecf7b', 'b01dea8a-3d17-419e-b757-f00c3a2bbffd', 'b0b58ec9-820f-4a71-9d14-2f90dbad3bdc', 'b32f3cb7-4ddf-4be6-af95-b5fff38544b0', 'b6f2ec70-b8be-48d3-b22b-9c1726b743a1', 'b71f5403-8897-4722-8f01-cc17bec7da6e', 'b7d98113-a409-4a4f-ac8c-45db363c7503', 'b9f73034-703d-4cbf-806d-1d6ce58bd776', 'ba65e008-02df-4fb5-aee0-ba16159a1b87', 'bd3f257b-eb4d-4b91-acd8-8bd893277c19', 'bd8cbdcc-6106-4764-9a5c-a1793b2881fa', 'be85fe44-20a7-4e5c-9800-8b27d6dac19c', 'c0f20064-64b1-4399-9b6c-9a30aaff136c', 'c0fa8cb4-e942-48f9-a15e-f48ada94f23f', 'c2938976-acfd-4c2a-abfa-b529656f56c9') AND FP.categories = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

78. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145', '04d2a81b-596c-4f65-92a0-9bfc58e74d14', '053a2317-f1f1-483a-abb3-4d499ee6e60e', '0565f097-4d2e-4545-a99d-8a2bcebb62cf', '05f49550-9644-4e6a-8c13-316f8bce3e1d', '06fc3fd0-0311-42b4-997f-0d8b13a69456', '096504d8-3af1-4a7c-8399-994bed36cb87', '0a2a4ee2-621b-4a6a-b075-ae4352d70f38', '0cf6aae8-dc6e-4e34-abf1-565125bc07ff', '0d7599f4-a586-4109-ad59-8799fc62b831', '0d7a1bd1-82a0-435f-a590-90238fb0270d', '0e566192-89f4-416a-9be9-f374039000bf', '0eaf5028-7ca9-4c5d-b92d-fd5e5511d04d', '10787c49-47b4-44b7-9bcf-dd84e40a9707', '11fe5f70-e468-4f9e-b198-8822b1e29208', '16df57a9-8119-4f9b-b273-3d28dfd0b3ba', '17a5885e-4a88-4789-8ff1-ab27f196c200', '1925e03d-f0bc-4edb-b16c-c384205d1733', '1a6cbc54-79eb-448b-9f0d-38b7c893b3c7', '1bc61cb1-4ac8-462b-a861-025d622cdfc9', '1d314bcf-977b-460a-adf1-e179e7a7ef9b', '1e70303c-d267-46e4-8622-bf3e47d7219b', '1f070255-99a4-4166-95f6-6cbb5c28da32', '1f783550-28be-4f11-ae7e-ccb692542a59', '1fd56d78-02e4-4c06-8c09-dd9a4dec1812', '201aa5f1-0fe5-4eda-8dca-68612e7f1d3d', '2136a970-b836-458d-b80e-5a5ae238f9a2', '21bc75c1-7675-474f-bb30-3fa19cef1e27', '231d3839-aad1-4f28-b9fb-b244f954c1b8', '23adc580-4883-44d3-a339-4a60ba07ff28', '2475894a-d030-40f3-855a-069f94ed0228', '26ef79e8-904f-4e8f-baed-b4c44906178e', '278a26b9-fc92-4615-9c41-c59a5584e852', '2799262d-caef-45da-9b24-53f3a07c5706', '27dce3c4-d000-4ffa-a591-ad7909dd0e8a', '2b31e608-c57f-46fc-9309-55c6fdcc939d', '2c2d7116-5cf1-4b22-92ef-ae5eeed2e837', '2c420f57-93b6-44b9-97a1-7d4d59c04f67', '2f6c7f8d-a61d-4a88-8ff7-8504be36125b', '3135c6d2-c081-4fd8-a746-bd3b8a618e13', '32189f21-ebff-4141-8d63-219c7c48531d', '3260f5de-0796-4cdb-91c9-4bc6914acc40', '35757bb3-ee3a-4782-8e47-ca7f64e48047', '388a9263-5bd2-48e3-9b6f-2dfc0369a5ac', '3a1df359-3131-45ab-8e5b-5ffccd100149', '3a7adc27-fb3b-4988-8dc1-64e849ed0b41', '3ac51b85-4e8d-45fa-8740-4e4ce70f7c0c', '3ce21f66-557e-4cb6-8523-90be7f708e81', '3ce32317-35f7-4467-86f2-77e701cc8d56', '3d86b366-289b-46a3-b743-c03aa771e9a6', '3ed1f979-0338-4982-890b-5852acfda2dc', '40f78e38-c08e-4795-8a66-be226c4e1773', '41276bfc-fb9b-4ffd-8ce3-5ffb664a29d4', '412b721c-54f7-4b1a-911e-018fdf728863', '43488025-bdbc-4fbc-8707-9deda56a8963', '45752a63-dea4-4576-85d7-430cdf19e7de', '467b16ec-9741-4213-9b10-1f200377fc98', '491527b6-34ef-4e1f-b934-127335192457', '4a983cf6-1594-4412-b048-75216ca453f4', '4adadf9a-14ea-4f8d-afdf-4e5597cf9d66', '4aee9f9f-1bdc-45b1-a168-aa772a8adb73', '4b90a58b-f2be-43ec-9dac-d7643af339f5', '4ec2090f-ad29-4ae7-91d3-d28004c74884', '4eff1147-d863-4d59-a31c-7226479e2388', '50d8081b-42f6-4cc8-8951-d388abb65cd6', '5101f8dc-0a13-419d-9e80-5d0b89804813', '528de7bb-a49a-46dc-ada1-b0b6c7add42c', '535509fd-ed10-4fcb-ae4a-0c299e29f478', '5642e37a-80ff-4bbc-90e0-cea79cbba30e', '5a76d0b9-4a72-4946-bca5-7c6dc5df6303', '5b6c7361-e621-4966-9609-02e79e687b60', '5c07577a-c2fc-4171-bde3-dfbc3c6df7a8', '5cca92ef-cea4-49ea-8849-a954c989da36', '5d3e05ef-8b3e-455d-8ba9-10ddbea03b53', '5e7652ae-34b0-4010-b908-b1a4300c0960', '5e9a4787-762a-4f5b-b041-7ab6dfb57149', '5ecb2fa6-bff8-4663-b674-5d39c8a57797', '5ee54386-3640-469a-b294-62db599fc3ab', '5f018c2e-7701-4b85-a6bb-fb2269aab5c2', '5f91e870-6783-4ff5-87a0-e7fd865032a7', '60d3b41d-3675-4a0f-99f2-a2483f1541f5', '6139ef2a-0740-4c72-b7ef-31675b82757b', '61debef6-910c-4c9a-99bf-9f591fb0676a', '62a350b8-e2c8-4abe-ac08-a3a596dee525', '64233972-8a40-420c-89ef-9217aa5e1794', '6478d570-dc60-4258-b5b0-96db76d9fd26', '64d58fa1-869e-47e5-aa2a-35a94d57d4a3', '654d5bf1-0c2f-4cc1-8a36-631d206b45b4', '65f56164-f318-451f-8b6d-283535a62db2', '669e2c18-7960-4342-aeeb-ea39187378f3', '6741a673-d5af-42c6-b867-492ed0d9fe81', '67f62779-e839-4a72-a884-4328dd84b365', '680172ea-5e86-40b6-98ec-8c18173845e2', '6a31ea7e-645f-4a4c-b842-92336989be1d', '6d9627f5-4b5b-4e9f-8505-03a87a28426c', '6dcbdf76-7512-49ac-9051-b971b1317bd2', '6f50f552-7686-42f2-8a7c-66c5cf628598', '6fa93ffd-4ba6-4ae3-98e1-3dcf51c6411b', '6fdb0462-302a-4688-81d1-ae238a881957', '70f23b3f-da3b-4d53-ab06-c65773c49723', '720190bd-136c-453b-a83b-53cbc6c083b3', '72a56462-a10a-4d6d-b71b-aab704f8dafc', '731826f2-7340-4b80-8684-9337e82b74da', '739c4277-12e4-41e5-a096-d027a3b7a924', '741c13f6-6cdb-4f09-affd-ef6cbe7c2774', '75104202-e471-4451-9b8c-b8cc6ed30201', '76812272-e832-4525-bfde-0990fcd9682b', '770e5d4d-75f2-4b4c-a339-93bea9b79bea', '77c0a03a-84ce-4c8a-adc8-3b39c6fe431d', '78aa15b8-a665-4aca-a9d2-4cbc01efe391', '795cb747-49fa-4475-99b4-bd068e09ea13', '79e35084-50e1-4085-8637-ce432b17a39f', '7a66566b-1fdf-4694-aa3d-755f19e83af7', '7a7c4475-c250-4540-9f7b-e186bb0a11d6', '7b05b860-c529-47a0-bfaa-74985381faa9', '7bb46df7-19dd-4447-aa45-fadfe0e1ed6c', '8005adc9-65c7-417c-92ae-35dfb5f23152', '80b51ffa-83ea-4eed-8511-66eec12f6b63', '822e4895-7da6-4946-9c39-de23bd4a1150', '8379a389-88e9-4e5c-b823-738a2ded8380', '868a55e1-31d3-4662-874e-8b005c9bd76d', '87e101a2-1933-443a-a22e-4523ff64638f', '89bf75ec-c55d-47a6-9699-dbaf9d4353d1', '8b49aa1c-b09e-4461-9dc5-598524559463', '8b4f0139-a7e8-4ae5-ace1-408d8a47baeb', '8c8ca4e3-01e8-4b22-a4b6-feea8f0c058f', '8cb5e6fd-c4a1-4ff9-a605-689a0c860831', '8d7fd3c8-5255-4f00-9cf9-d0313749504e', '8f3e3a52-e145-4562-a452-aa7a117ed8c1', '93088ef6-81f3-4a14-bdb2-a1ca0dd07bf5', '95636577-b96c-4b12-a97a-fec6044041ef', '95a1ed1f-ab9d-48c3-9274-0cd4c4a371fa', '95d3f1d6-7a90-4ce4-b0bb-ec9be7ff89c5', '97aa035c-d3eb-43b4-884b-bb5dbb51afe1', '995bf090-f5aa-4020-ac1e-3894cfd6dc45', '9b1d4753-d18f-4206-a699-5fc21a60b28b', '9b45085c-5b5e-4f38-ace2-c6b7de917937', '9c977ceb-c7df-44c5-99a5-f8f031422051', '9cc86f59-5944-4ffe-a446-e88f248de9f6', '9d30ed03-32f8-4a7b-b204-001e6a9a1924', '9d4fcd40-9ccd-4f41-9359-07b8e6d7c7c1', '9eec9718-2026-4a30-b6b0-522909dc8dc8', '9efe494d-b603-4d18-9672-a39f4a0818ac', 'a1d97d5b-f1c7-4a7f-ad28-ec85f8e3dd4c', 'a2461ad4-4b1b-4849-81f1-de02f9f21e71', 'a5959f44-0d85-490d-a867-b142f45b2c69', 'a5a8e3ca-194e-4bc9-b1b3-c7c4b027e71e', 'a61f43f1-77f0-4162-b3a3-4376cb8428ed', 'a78f38d7-e4f4-4476-8fe4-738d1f0e66ef', 'a7e43a58-46ae-431f-bfed-6a3c7247f239', 'a850730f-749c-44dc-b1b3-97a91864033c', 'a87ed843-a991-4e64-92aa-f77ca436b09a', 'a89c37c0-2948-4d27-8e67-0339dcb1e337', 'aa61a031-17b9-47d3-8ef3-19d65037b32c', 'aaa8dc4e-662f-4fb2-8c3d-773b6065519d', 'ab290cea-ddda-4b09-8c35-d03a9f9f7c7a', 'accbe0c1-4e52-4cfd-afb7-04bbac85b4a5', 'ad0ca7a7-77bb-45ff-a79f-03a3f43faec8', 'aefd91ce-5324-4bf9-a622-19caaf0ecf7b', 'b01dea8a-3d17-419e-b757-f00c3a2bbffd', 'b0b58ec9-820f-4a71-9d14-2f90dbad3bdc', 'b32f3cb7-4ddf-4be6-af95-b5fff38544b0', 'b6f2ec70-b8be-48d3-b22b-9c1726b743a1', 'b71f5403-8897-4722-8f01-cc17bec7da6e', 'b7d98113-a409-4a4f-ac8c-45db363c7503', 'b9f73034-703d-4cbf-806d-1d6ce58bd776', 'ba65e008-02df-4fb5-aee0-ba16159a1b87', 'bd3f257b-eb4d-4b91-acd8-8bd893277c19', 'bd8cbdcc-6106-4764-9a5c-a1793b2881fa', 'be85fe44-20a7-4e5c-9800-8b27d6dac19c', 'c0f20064-64b1-4399-9b6c-9a30aaff136c', 'c0fa8cb4-e942-48f9-a15e-f48ada94f23f', 'c2938976-acfd-4c2a-abfa-b529656f56c9', 'c551d06d-446e-47c6-bf1b-4a1a22a4c981', 'c6f2e8f3-90af-4ad7-81ff-d106dd376a0c', 'c86b042a-66bf-42f8-8170-6d94ba12b2ae', 'c8adf6d3-c323-41bc-9251-8f7f4b8a7954', 'c8e79276-b5df-436e-8e7c-08b26dbf3833', 'c9652cac-04f1-4f39-85e9-6a63a77a6273', 'c9cf462f-b77b-4252-a215-3dff07ccf6bd', 'ca43e798-3ead-4995-ace6-7ee9f2294f5d', 'cba24b00-1040-4167-a601-76f07dc3cdf6', 'cc0cb867-9bda-475b-8706-3521df650102', 'ccc28d03-741f-448a-97bd-d270925038df', 'cccf4b7d-60f3-43d4-a23f-febda394d3bf', 'ce1aa9b3-6292-45cf-a7d4-35367d751977', 'cee365ec-848b-4f92-8903-fd894694b9ba', 'cf480ab0-4c18-4251-abc9-2a750d000731', 'd06b46a6-fc98-4804-b273-182075f8c7c9', 'd0d1042c-5e83-4007-9422-640c53a7b931', 'd60bdcb6-487a-4259-b47e-6d21b8e673f7', 'd6f4a2f1-6422-4f8f-bacc-8eccf49d6b5f', 'd826b868-0334-4cbe-aa07-d0c981825f4e', 'd89c5d98-a0e4-4433-9a16-9c1b1998d0a7', 'db8adc8c-73b2-4066-8fe7-6aa3add6d0af', 'dc6613d4-4a55-4538-8321-5d328c5b06b7', 'df0ea7c1-3142-4741-99dc-d46d80c2047b', 'df3d5ce7-9d30-4bf9-9ab3-c64e238d94e8', 'dfb14750-93c2-4f60-8bbe-8e1269a70b16', 'dfff49a5-6e87-44dd-9f80-4aeb41af333a', 'e096b602-cc34-4ff1-8891-ec57e4ef0043', 'e0cf0d4d-6479-4405-a9c6-bb6f717d99f5', 'e1dbcc05-20d7-411b-83f0-f033cb2cbac9', 'e23acc98-ade7-47e7-a51e-17587d633f04', 'e486e32b-4859-4f58-9f2a-92ff931ff987', 'e622ba2e-7b73-461d-8fa3-545be93f4b9c', 'e6d85d67-cf0c-4f5e-874f-b3e1150e34de', 'e6f96dee-0d23-45f3-a54f-b12c7f7eaa30', 'e71eb239-2ea4-4fd4-a7a8-9ee2eb4ec974', 'e856043f-b1d1-4f6f-b5f1-0c607a634e2c', 'e906a5df-a3a9-489d-b9d2-a48e1702d3d3', 'e920e2c3-6a08-4b9a-853e-4f78cac028bb', 'e92b082e-96ba-4bae-99ff-528f5ab03f0e', 'e99f4340-1e8e-4367-8fd0-3e8b6170b97a', 'e9c18117-3a24-4b44-b59a-5d537ae5cda0', 'e9dc0714-c8ee-4690-bd24-1091aba3e57b', 'e9dc42e3-1689-47a7-82f3-7af667bb42c4', 'eb7a7faa-1750-4a7e-8ce6-6560587b5ad6', 'ed21d4a7-2314-4f6a-8b87-6180fa108c29', 'ed8e4573-a2b0-4857-94a4-020da4c3b671', 'eea43f38-80e3-497a-bd24-4fde73e25ab3', 'f0e86be3-ccf9-47bf-8403-f631297e09f2', 'f11b879c-18f2-4147-a07e-6c39eca760b6', 'f1adb832-b270-4496-af12-b8dd2cac5907', 'f20bb4ea-1184-4c8f-b734-b066a92e8702', 'f2897a73-0da0-41c7-86bf-b2a10c8f3ee5', 'f4179bf4-0c63-45b5-b60a-b8dd47512905', 'f5bb7cda-a39d-4456-bb53-7157b0c9eced', 'f5eaa44e-ec85-4b0e-b4ba-b96685c10ac9', 'f6d152cc-eff4-4603-b2a4-4ea29e49229e', 'f6e154d5-b080-4bee-8a58-9617f018033b', 'f98ec19d-bb30-4afc-b336-fbc61fd74b9e', 'f9a75cd1-3c7d-49aa-a2ee-371eda1c306e', 'fa24923d-ba5b-44e3-9fc5-51c3a9ce50c2', 'fad3f652-3ca0-458c-bccd-c87c44fc76ac', 'fd3283b4-6bc6-4364-ac3e-95e8e6aba738', 'fd86de7b-50fb-4f52-a032-99b754ffbe29') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

79. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 ON (P1.pid_1 = P2.pid_2) sec

80. SELECT DISTINCT(FPAG.product_uuid) as product_uuid FROM tp_4over_product_group_option_master AS FPAG LEFT JOIN tp_4over_products as FP ON FP.product_uuid = FPAG.product_uuid AND FP.status = '1' WHERE FPAG.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145', 'e23acc98-ade7-47e7-a51e-17587d633f04', '0e566192-89f4-416a-9be9-f374039000bf', '4adadf9a-14ea-4f8d-afdf-4e5597cf9d66', '6fdb0462-302a-4688-81d1-ae238a881957', '8b4f0139-a7e8-4ae5-ace1-408d8a47baeb', '8d7fd3c8-5255-4f00-9cf9-d0313749504e') AND FP.categories = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

81. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145', '0e566192-89f4-416a-9be9-f374039000bf', '4adadf9a-14ea-4f8d-afdf-4e5597cf9d66', '6fdb0462-302a-4688-81d1-ae238a881957', '8b4f0139-a7e8-4ae5-ace1-408d8a47baeb', '8d7fd3c8-5255-4f00-9cf9-d0313749504e', 'e23acc98-ade7-47e7-a51e-17587d633f04') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

82. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P2.pid_2 = P3.pid_3) sec

83. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

84. SELECT size_id,tp4over_size_title FROM tp_4over_ops_size_mapping WHERE ops_product_id =300 sec

85. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P3.pid_3 = P4.pid_4) sec

86 83. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

87. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P5 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P4.pid_4 = P5.pid_5) sec

88 83. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

89. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = 'af949995-7444-490c-af35-c9ab635a2bef' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P6 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P5.pid_5 = P6.pid_6) sec

90 83. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

91. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = 'af949995-7444-490c-af35-c9ab635a2bef' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P7 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P6.pid_6 = P7.pid_7) sec

92 83. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

93. SELECT colorspec_uuid FROM tp_product_price WHERE product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') GROUP BY colorspec_uuid sec

94. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = 'af949995-7444-490c-af35-c9ab635a2bef' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P8 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P7.pid_7 = P8.pid_8) sec

95 72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

96 83. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

97. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = 'af949995-7444-490c-af35-c9ab635a2bef' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P9 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P1.pid_1 = P9.pid_9) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P2.pid_2 = P9.pid_9) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P3.pid_3 = P9.pid_9) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P4.pid_4 = P9.pid_9) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P5.pid_5 = P9.pid_9) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P6.pid_6 = P9.pid_9) AND (P7.pid_7 = P8.pid_8) AND (P7.pid_7 = P9.pid_9) AND (P8.pid_8 = P9.pid_9) sec

98 72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

99 83. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

100. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = 'af949995-7444-490c-af35-c9ab635a2bef' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P9 INNER JOIN (SELECT t4pgo.product_uuid as pid_10 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '67ad8402-341f-4a0a-bd1a-b7fc64688a7f' AND t4pgo.option_uuid = '595a3499-310b-46ed-85bb-f7c14e223759' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P10 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P1.pid_1 = P9.pid_9) AND (P1.pid_1 = P10.pid_10) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P2.pid_2 = P9.pid_9) AND (P2.pid_2 = P10.pid_10) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P3.pid_3 = P9.pid_9) AND (P3.pid_3 = P10.pid_10) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P4.pid_4 = P9.pid_9) AND (P4.pid_4 = P10.pid_10) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P5.pid_5 = P9.pid_9) AND (P5.pid_5 = P10.pid_10) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P6.pid_6 = P9.pid_9) AND (P6.pid_6 = P10.pid_10) AND (P7.pid_7 = P8.pid_8) AND (P7.pid_7 = P9.pid_9) AND (P7.pid_7 = P10.pid_10) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P9.pid_9 = P10.pid_10) sec

101 72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

102. SELECT DISTINCT(option_uuid) FROM tp_4over_product_turnaround_time_price WHERE product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND runsize_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' sec

103. SELECT DISTINCT(tp_4over_product_group_option_master.option_group_uuid),pgm.option_group_name, tp_4over_product_group_option_master.option_uuid, tp_4over_product_group_option_master.option_name, tp_4over_product_group_option_master.option_description FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as pgm ON pgm.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' AND tp_4over_product_group_option_master.option_uuid IN ('ad290b77-c9d5-476c-b847-9ad4d25ae14e') sec

104. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = 'e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P1 INNER JOIN (SELECT t4pgo.product_uuid as pid_2 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '2780e6cc-19d0-4a50-b8a5-d17a8ed468af' AND t4pgo.option_uuid = '81d46271-9322-49f1-a108-5236d4198a0f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P2 INNER JOIN (SELECT t4pgo.product_uuid as pid_3 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'fbe03bb5-c038-4a59-bc79-38739d362abb' AND t4pgo.option_uuid = '30b7527a-cedd-4205-8941-1f4f9644fc13' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P3 INNER JOIN (SELECT t4pgo.product_uuid as pid_4 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P4 INNER JOIN (SELECT t4pgo.product_uuid as pid_5 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P5 INNER JOIN (SELECT t4pgo.product_uuid as pid_6 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '24865ffa-793d-43ea-b3b1-d1b5cf22268d' AND t4pgo.option_uuid = 'af949995-7444-490c-af35-c9ab635a2bef' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P9 INNER JOIN (SELECT t4pgo.product_uuid as pid_10 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '67ad8402-341f-4a0a-bd1a-b7fc64688a7f' AND t4pgo.option_uuid = '595a3499-310b-46ed-85bb-f7c14e223759' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P10 INNER JOIN (SELECT t4pgo.product_uuid as pid_11 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'f80e8179-b264-42ce-9f80-bb258a09a1fe' AND t4pgo.option_uuid = 'ad290b77-c9d5-476c-b847-9ad4d25ae14e' AND t4pgo.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' ) as P11 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P1.pid_1 = P4.pid_4) AND (P1.pid_1 = P5.pid_5) AND (P1.pid_1 = P6.pid_6) AND (P1.pid_1 = P7.pid_7) AND (P1.pid_1 = P8.pid_8) AND (P1.pid_1 = P9.pid_9) AND (P1.pid_1 = P10.pid_10) AND (P1.pid_1 = P11.pid_11) AND (P2.pid_2 = P3.pid_3) AND (P2.pid_2 = P4.pid_4) AND (P2.pid_2 = P5.pid_5) AND (P2.pid_2 = P6.pid_6) AND (P2.pid_2 = P7.pid_7) AND (P2.pid_2 = P8.pid_8) AND (P2.pid_2 = P9.pid_9) AND (P2.pid_2 = P10.pid_10) AND (P2.pid_2 = P11.pid_11) AND (P3.pid_3 = P4.pid_4) AND (P3.pid_3 = P5.pid_5) AND (P3.pid_3 = P6.pid_6) AND (P3.pid_3 = P7.pid_7) AND (P3.pid_3 = P8.pid_8) AND (P3.pid_3 = P9.pid_9) AND (P3.pid_3 = P10.pid_10) AND (P3.pid_3 = P11.pid_11) AND (P4.pid_4 = P5.pid_5) AND (P4.pid_4 = P6.pid_6) AND (P4.pid_4 = P7.pid_7) AND (P4.pid_4 = P8.pid_8) AND (P4.pid_4 = P9.pid_9) AND (P4.pid_4 = P10.pid_10) AND (P4.pid_4 = P11.pid_11) AND (P5.pid_5 = P6.pid_6) AND (P5.pid_5 = P7.pid_7) AND (P5.pid_5 = P8.pid_8) AND (P5.pid_5 = P9.pid_9) AND (P5.pid_5 = P10.pid_10) AND (P5.pid_5 = P11.pid_11) AND (P6.pid_6 = P7.pid_7) AND (P6.pid_6 = P8.pid_8) AND (P6.pid_6 = P9.pid_9) AND (P6.pid_6 = P10.pid_10) AND (P6.pid_6 = P11.pid_11) AND (P7.pid_7 = P8.pid_8) AND (P7.pid_7 = P9.pid_9) AND (P7.pid_7 = P10.pid_10) AND (P7.pid_7 = P11.pid_11) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P8.pid_8 = P11.pid_11) AND (P9.pid_9 = P10.pid_10) AND (P9.pid_9 = P11.pid_11) AND (P10.pid_10 = P11.pid_11) sec

105 72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('031e1256-bb21-4186-a849-8fa6b05b4145') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

106. SELECT DISTINCT(option_uuid),option_name FROM tp_4over_product_group_option_master WHERE option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' sec

107. SELECT is_flat_fee,qty,price_per_qty,price,startqty,endqty,product_option_group_uuid,is_percentage, option_uuid FROM tp_product_opt_price WHERE product_uuid = '031e1256-bb21-4186-a849-8fa6b05b4145' AND product_option_group_uuid IN ('b19d4ac3-2d48-40c0-9729-e35af6846271', '2780e6cc-19d0-4a50-b8a5-d17a8ed468af', 'fbe03bb5-c038-4a59-bc79-38739d362abb', '34f407f8-0b50-4227-9378-10fddefbe596', '88c28e92-7c8c-4c05-9908-dcd495e0957a', '24865ffa-793d-43ea-b3b1-d1b5cf22268d', '26ca0df3-0682-4f37-8979-409868e2df2d', '38d33954-5a42-4112-a905-215eb827e62c', '87e09691-ef33-4cf4-8f17-48af06ce84f4', '67ad8402-341f-4a0a-bd1a-b7fc64688a7f', 'f80e8179-b264-42ce-9f80-bb258a09a1fe') AND option_uuid IN ('e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc', '81d46271-9322-49f1-a108-5236d4198a0f', '30b7527a-cedd-4205-8941-1f4f9644fc13', 'e8d3bb66-7561-457b-a746-168e4d28b956', '991b850a-6643-48d3-afa6-bcda4cf58c85', 'af949995-7444-490c-af35-c9ab635a2bef', '3e7618de-abca-4bda-9f97-8b9129e913d8', '32d3c223-f82c-492b-b915-ba065a00862f', 'c088d9de-bfe6-401d-94f7-5648672a98f8', '595a3499-310b-46ed-85bb-f7c14e223759', 'ad290b77-c9d5-476c-b847-9ad4d25ae14e') AND startqty <= 1 AND endqty >= 1 sec

(Cached) 7c3bb65dfab7b71d0e404ac4962be59c

108. SELECT * FROM tp_4over_product_turnaround_time_price WHERE product_uuid ='031e1256-bb21-4186-a849-8fa6b05b4145' And option_uuid ='ad290b77-c9d5-476c-b847-9ad4d25ae14e' And colorspec_uuid ='32d3c223-f82c-492b-b915-ba065a00862f' And runsize_uuid ='c088d9de-bfe6-401d-94f7-5648672a98f8' sec

109. SELECT markup, markup_type FROM tp_4over_category WHERE category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

110. SELECT markup, markup_type FROM tp_move_ops_product_markup WHERE ops_product_id = 300 sec

111. SELECT size_id FROM tp_4over_ops_size_mapping LEFT JOIN tp_4over_product_group_option_master as opt ON opt.option_name = tp_4over_ops_size_mapping.tp4over_size_title WHERE opt.option_uuid = 'e8d3bb66-7561-457b-a746-168e4d28b956' AND ops_product_id =300 LIMIT 1 OFFSET 0 sec

112. SELECT grp.option_group_name,tp_4over_product_group_option_master.* FROM tp_4over_product_group_option_master LEFT JOIN tp_4over_product_group_master as grp ON grp.option_group_uuid = tp_4over_product_group_option_master.option_group_uuid WHERE tp_4over_product_group_option_master.product_uuid = '031e1256-bb21-4186-a849-8fa6b05b4145' AND tp_4over_product_group_option_master.category_uuid = 'ae3afb44-beb1-4fda-8b2c-3f940f005fc6' sec

113. SELECT coupon.*, IF (coupon.product_id != 'all',1,2) AS OrderBY FROM coupon WHERE coupon.type = 'discount' AND coupon.coupon_type = 'product' AND '2026-06-13 01:37:16' 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 sec

114 74. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name IN ('PRODUCT_APPLY_SETUP_COST', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'PRODUCT_HIRE_DESIGNER_COST', 'PRODUCT_UPDATE_PRICE_TABLE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_CUT_OFF_TIME', 'PRODUCT_DESC_HIRE_DESIGNER_OPTION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_OPTION_LABEL', 'PRODUCT_HIRE_DESIGNER_NO', 'PRODUCT_HIRE_DESIGNER_YES') sec

(Cached) c8ddd73ab1d6dcc43b995d82967ab39f

115 74. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name IN ('PRODUCT_APPLY_SETUP_COST', 'PRODUCT_MINIMUM_PRICE_APPLICABLE', 'PRODUCT_HIRE_DESIGNER_COST', 'PRODUCT_UPDATE_PRICE_TABLE', 'PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_PREVIEW_ENABLE', 'PRODUCT_CUT_OFF_TIME', 'PRODUCT_DESC_HIRE_DESIGNER_OPTION_HELP_TEXT', 'PRODUCT_HIRE_DESGNER_OPTION_LABEL', 'PRODUCT_HIRE_DESIGNER_NO', 'PRODUCT_HIRE_DESIGNER_YES') sec

(Cached) c8ddd73ab1d6dcc43b995d82967ab39f

116. SELECT production_days FROM products_production_days left join products_sizes on products_production_days.size_id=products_sizes.size_id WHERE products_production_days.size_id = 5739 AND products_production_days.attribute_id = 0 AND products_sizes.products_id= 300 AND products_sizes.site_language_id= 1 sec

117. SELECT setting_constant_name, setting_value FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name = 'DEFAULT_PRODUCTION_DAYS' sec

(Cached) 31a783d075833498bea52d5c6c57b544

118. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name = 'PRODUCT_CUT_OFF_TIME' sec

(Cached) 39f6131b29619346cd2cf015ce7b2dfc

119 107. SELECT is_flat_fee,qty,price_per_qty,price,startqty,endqty,product_option_group_uuid,is_percentage, option_uuid FROM tp_product_opt_price WHERE product_uuid = '031e1256-bb21-4186-a849-8fa6b05b4145' AND product_option_group_uuid IN ('b19d4ac3-2d48-40c0-9729-e35af6846271', '2780e6cc-19d0-4a50-b8a5-d17a8ed468af', 'fbe03bb5-c038-4a59-bc79-38739d362abb', '34f407f8-0b50-4227-9378-10fddefbe596', '88c28e92-7c8c-4c05-9908-dcd495e0957a', '24865ffa-793d-43ea-b3b1-d1b5cf22268d', '26ca0df3-0682-4f37-8979-409868e2df2d', '38d33954-5a42-4112-a905-215eb827e62c', '87e09691-ef33-4cf4-8f17-48af06ce84f4', '67ad8402-341f-4a0a-bd1a-b7fc64688a7f', 'f80e8179-b264-42ce-9f80-bb258a09a1fe') AND option_uuid IN ('e6af26ef-fbad-4ba2-9b96-b65fbaf9c1bc', '81d46271-9322-49f1-a108-5236d4198a0f', '30b7527a-cedd-4205-8941-1f4f9644fc13', 'e8d3bb66-7561-457b-a746-168e4d28b956', '991b850a-6643-48d3-afa6-bcda4cf58c85', 'af949995-7444-490c-af35-c9ab635a2bef', '3e7618de-abca-4bda-9f97-8b9129e913d8', '32d3c223-f82c-492b-b915-ba065a00862f', 'c088d9de-bfe6-401d-94f7-5648672a98f8', '595a3499-310b-46ed-85bb-f7c14e223759', 'ad290b77-c9d5-476c-b847-9ad4d25ae14e') AND startqty <= 1 AND endqty >= 1 sec

(Cached) 7c3bb65dfab7b71d0e404ac4962be59c

120 110. SELECT markup, markup_type FROM tp_move_ops_product_markup WHERE ops_product_id = 300 sec

121. SELECT shipping_method_id, directory, shipping_pcalc_config, shipping_details FROM shipping_method WHERE status = '1' sec

(Cached) 52520048f72321f7fc95c1219427ab6d

122. SELECT * FROM address_book WHERE user_id = 0 sec

123. SELECT * FROM countries WHERE countries_id = 223 AND countries.available_for_default_store = '1' sec

(Cached) cd3fa65484d94fadd06c251b01a31fd8

124 121. SELECT shipping_method_id, directory, shipping_pcalc_config, shipping_details FROM shipping_method WHERE status = '1' sec

(Cached) 52520048f72321f7fc95c1219427ab6d

125. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name IN ('PRODUCT_PRICE_CALCULATOR_VISUALIZATION', 'PRODUCT_ADDITIONAL_OPTION_VISUAL_ENABLE', 'ALLOW_FREE_SHIPPING') sec

(Cached) 2f6cf269870950028e91c457ad5dfc1c

126. SELECT count(countries_id) as total FROM countries WHERE status = '1' AND countries.available_for_default_store = '1' sec

(Cached) 6eaa3b39c2718890711cfd27fb194775

127. SELECT * FROM countries WHERE status = '1' AND countries.available_for_default_store = '1' ORDER BY countries_name ASC sec

(Cached) 09edf8b51add513de8d19a10ef493375

128. SELECT shipping_method_id,shipping_pcalc_config, shipping_method.* FROM shipping_method WHERE status ='1' AND FIND_IN_SET('1',user_type) AND (NOT FIND_IN_SET(1, user_group_lookup)) ORDER BY sort_order ASC sec

129. 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 = 'cms_header_content' AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC sec

130. SELECT * FROM site_currency WHERE status = '1' sec

(Cached) 613b110f15bfd6188f372b9124b62c8e

131 33. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

132. SELECT SQL_CALC_FOUND_ROWS products.sort_order, products_description.imagename, products_description.product_description, products_description.products_title, products_description.products_id, products_description.imagename_alt, products_description.product_desc_image_alt, products_description.metadata FROM product_kit LEFT JOIN products ON product_kit.product_id = products.products_id LEFT JOIN products_description ON products.products_id = products_description.products_id AND products_description.site_language_id = 1 WHERE products.kit_type_id != '1' AND products.visible = '1' AND ((products.user_type_id IN ('0', '1'))) AND hidden_product = '0' ORDER BY product_kit.kit_id ASC sec

(Cached) 1cffd954f20a0fb38cfc672226b9b38a

133 33. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

134. 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.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

135 33. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

136 134. 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.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

137 33. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

138 134. 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.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

139 33. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

140 134. 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.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

141 33. SELECT * FROM product_settings WHERE product_settings.setting_constant_name IN ('PRODUCT_PROMOTION_IN_TITLE', 'PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) c8e223f507693db39efdca3236d7987c

142 134. 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.corporate_id = 0 AND cms_pages_description.site_language_id = 1 AND ( cms_pages.page_name = 'all_category_and_product_menu') ORDER BY cms_pages.corporate_id DESC, cms_pages.sort_order ASC LIMIT 1 OFFSET 0 sec

143. SELECT SQL_CALC_FOUND_ROWS banner_image.title, banner_image.banner_image_name, banner_image.banner_mobile_image_name, banner_image.banner_link, banner_image.open_target, banner_image.banner_text, banner_image.mobile_banner_text, banner_image.banner_image_id, banner_image.banner_upperimage_name, banner_image.banner_display_type, banner_image.banner_display, banner_image.banner_advance_settings, banner_image.metadata FROM banner_image WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2026-06-13 01:37:17' AND banner_image.banner_end_date >= '2026-06-13 01:37:17')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](300)[[:>:]]' AND banner_image.corporate_id = 0 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC sec

144 143. SELECT SQL_CALC_FOUND_ROWS banner_image.title, banner_image.banner_image_name, banner_image.banner_mobile_image_name, banner_image.banner_link, banner_image.open_target, banner_image.banner_text, banner_image.mobile_banner_text, banner_image.banner_image_id, banner_image.banner_upperimage_name, banner_image.banner_display_type, banner_image.banner_display, banner_image.banner_advance_settings, banner_image.metadata FROM banner_image WHERE (banner_image.banner_start_date = '0000-00-00 00:00:00' OR (banner_image.banner_start_date <= '2026-06-13 01:37:17' AND banner_image.banner_end_date >= '2026-06-13 01:37:17')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](300)[[:>:]]' AND banner_image.corporate_id = 0 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC sec

145. SELECT * FROM breadcrumbs WHERE status = '1' sec

(Cached) cfc88bdad1d3c808679011331b88f107

146. SELECT products_description.products_title, product_category_description.category_name, products.category_id, product_category.status, products.multiple_category FROM products LEFT JOIN product_category ON product_category.category_id = products.category_id 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 WHERE products.products_id = 300 AND products_description.site_language_id = 1 AND products.predefined_product_type IN ('0', '1') sec

147. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name IN ('PRODUCT_QUICK_DESIGN', 'DISPLAY_BROWSE_DESIGN_BEFORE_PRODUCT_INFO') sec

(Cached) 6beddfef940cd758680708edbb7dba91

148. SELECT product_category.category_id,product_category_description.category_name,product_category.parent_id,product_category.status FROM product_category
LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = '1')
WHERE 1 AND (product_category.category_id= ( SELECT `parent_id` FROM `product_category` WHERE `category_id` = '72' ) AND product_category.parent_id = '0' ) OR product_category.category_id = 72 AND product_category.status = '1' sec

149. SELECT id, process_id, status FROM background_processes WHERE tag = 'products_product_gallery' AND status = 'running' sec

150. SELECT * FROM product_settings WHERE product_settings.products_id = 300 AND product_settings.setting_constant_name = 'PRODUCT_CREATE_HELP_TEMPLATE' sec

(Cached) b05caf85482119e43839baa921006bd8

151. SELECT studio_configuration_setting.variable_name, (studio_configuration_setting.value) as setting_value FROM studio_configuration_setting WHERE studio_configuration_setting.variable_name IN ('custom_add_cut_customsize') sec

(Cached) ab6870bc59dbc9ac402298b62edb44b3

152. SELECT products.*, products_description.*, measurement_unit.* FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN measurement_unit ON products.measurement_unit_id = measurement_unit.unit_id AND measurement_unit.site_language_id=1 WHERE products.products_id = 300 AND products_description.site_language_id = 1 sec

153. SELECT * FROM product_settings WHERE product_settings.products_id = 300 sec

(Cached) 5630ac40d6630a15635fd078e1d3d11e

154 50. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=300 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC sec

155. SELECT product_master_option.`master_option_id`,
product_master_option.`option_key`,
product_master_option.`options_type`,
product_master_option.`status` As master_status,
product_master_option.`pricing_method`,
product_master_option.`linear_formula`,
product_master_option.`weight_setting`,
product_master_option.`price_range_lookup`,
product_master_option.`formula`,
product_master_option.`sort_order` AS master_sort_order,
product_master_option.`hire_designer_option` AS master_hire_designer_option,
product_master_option.`prod_add_opt_export_group_id`,
product_master_option.`custom_txtbox_opt_id`,
product_master_option.`min_default_value`,
product_master_option.`presentation_settings`,
product_master_option.`master_option_tag`,
product_master_option.`custom_weight_txtbox_opt_id`,
product_master_option.`additional_lookup_details`,
product_master_option_description.title,
product_master_option_description.description,
product_master_option_attributes.master_attribute_id,
product_master_option_attributes.multiplier_type as attr_multiplier_type,
product_master_option_attributes.attribute_key,
product_master_option_attributes.default_attribute,
product_master_option_attributes.setup_cost AS attr_setup_cost,
product_master_option_attributes.multiplier as attr_multiplier,
product_master_option_attributes.weight,
product_master_option_attributes.material_thickness,
product_master_option_attributes.production_days,
product_master_option_attributes.attributes_image,
product_master_option_attributes.sort_order AS attr_sort_order,
product_master_option_attributes.status AS attr_status,
product_master_option_attributes.material_thickness,
product_master_option_attributes_description.label,
product_master_option_attributes.metadata, products_additional_option.`sort_order` AS option_sort_order, products_additional_option.`setup_cost` as option_setup_cost, products_additional_option.`multiplier` as option_multiplier, products_additional_option.`multiplier_type` as option_multiplier_type, products_additional_option.`status`, products_additional_option.`prod_add_opt_id` FROM product_master_option LEFT JOIN product_master_option_description ON product_master_option_description.master_option_id = product_master_option.master_option_id AND product_master_option_description.site_language_id = 1 LEFT JOIN product_master_option_attributes ON product_master_option_attributes.master_option_id = product_master_option.master_option_id AND product_master_option_attributes.status = '1' LEFT JOIN product_master_option_attributes_description ON product_master_option_attributes_description.master_attribute_id = product_master_option_attributes.master_attribute_id AND product_master_option_attributes_description.site_language_id = 1 INNER JOIN products_additional_option ON products_additional_option.option_key = product_master_option.option_key AND products_additional_option.products_id = 300 WHERE product_master_option.status = '1' sec

156. SELECT products.*, products_description.products_title, products_description.long_description, products_description.product_desc_image, products_description.bw_page_label, products_description.color_page_label, products_description.imagename FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.products_id = 300 AND products.kit_type_id != '2' AND products_description.site_language_id = 1 AND products.visible = 1 ORDER BY products.products_id ASC sec

157. SELECT size_id, size_title, size_width, size_height, no_of_folding, orientation, page_size_details FROM products_sizes WHERE site_language_id = 1 AND products_sizes.products_id = 300 sec

158. SELECT pages_id, page_title FROM products_pages WHERE visible = '1' AND products_id = 300 AND site_language_id = 1 ORDER BY sort_order ASC, pages_id ASC sec

(Cached) 36e97036273c3b92c6e831a83de7480e

159. SELECT unit_type_name FROM measurement_unit WHERE unit_type_code = 'Inch' AND site_language_id = 1 sec

160. SELECT option_id,mask_image_landscape,mask_image_potrait,pages_id,size_id,attribute_id FROM products_mask WHERE product_id = 300 sec

161 13. SELECT products.predefined_product_type, products.price_defining_method, products.is_promotional FROM products WHERE products.products_id = 300 sec

(Cached) 05b4b64df866d467d0759a64c1990d53

162. SELECT studio_configuration_setting.variable_name, studio_configuration_product_setting.products_id, IF(studio_configuration_product_setting.configuration_id IS NOT NULL ,studio_configuration_product_setting.value,studio_configuration_setting.value) as setting_value, studio_configuration_setting.value AS default_value FROM studio_configuration_setting LEFT JOIN studio_configuration_product_setting ON studio_configuration_setting.configuration_id = studio_configuration_product_setting.configuration_id AND ( IF(studio_configuration_product_setting.products_id != 0,
studio_configuration_product_setting.products_id = 300 AND studio_configuration_product_setting.corporate_id = 0,
studio_configuration_product_setting.products_type_id = 1 AND studio_configuration_product_setting.corporate_id = 0 ) ) WHERE ( IF( studio_configuration_setting.exclude_products_type IS NOT NULL AND studio_configuration_setting.exclude_products_type != '', studio_configuration_setting.exclude_products_type NOT LIKE '%1%', studio_configuration_setting.products_type IS NULL OR studio_configuration_setting.products_type = '' OR studio_configuration_setting.products_type LIKE '%1%' OR studio_configuration_setting.products_type = '-1') ) AND studio_configuration_setting.variable_name IN ('product[margins][data][0][border][color]', 'product[margins][data][1][border][color]') ORDER BY studio_configuration_product_setting.products_id sec

(Cached) 80c3d4ca71db8155d2274138d9cec02a