Low Tack Vinyl Wall Decals (Wall Decals)

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/wall-decals/low-tack-vinyl-wall-decals/' OR old_url = 'https://uday.fourprintshop.com/signs-banners/wall-decals/low-tack-vinyl-wall-decals/' OR old_url = 'https://uday.fourprintshop.com/signs-banners/wall-decals/low-tack-vinyl-wall-decals/') 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 = 'low-tack-vinyl-wall-decals' sec

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

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 = 352 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

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

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

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 = 352 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 = 352 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 = 352 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 = 352 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

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

46. SELECT * FROM product_settings WHERE product_settings.products_id = 352 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

47. SELECT layout_name, is_mobile, sidebar_display, is_default, IF(FIND_IN_SET('352',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 '%,352,%' 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

48. SELECT products.*, products_description.* FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id WHERE products.products_id = 352 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 = 73 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`=352 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 = 352 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 = 352 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 = 352 OR duplicate_product_id LIKE '%,352-%') 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 = 352 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 = 352 sec

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

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 '(^|,)(352)(,|$)' AND coupon.created_by = 0 AND '2026-06-13 00:46:19' 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 = 352 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 = '00747741-f013-400d-9cfb-0066012e70de' AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' AND tp_4over_product_options_settings.ops_product_id IN ('0', '352') 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', '352') AND categoryId = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 ('00747741-f013-400d-9cfb-0066012e70de', '99a1d43d-f785-429d-ad95-da187206a180', '9aa542cc-d824-4303-b0a1-585b7ed2fba8', '9aac4cfb-9176-48cc-81e2-ea60aa1f6f49', '9af25a6e-a011-4972-85f0-8c288b928054', '9b9f1e8e-d202-4b90-b45a-684e92120fa3', '9c9a2e87-a14e-4d04-9e67-39b3fb6b0ad1', '9f77bc07-0890-4534-a24b-0ee00b4f90d5', 'a1ea09a5-3871-4b52-898a-cadbad388710', 'a3a6fcc1-0e4d-4567-8555-363de573dd7c', 'a50549cc-660c-4f36-a6c9-fcb2cb70b7bf', 'a52407a4-18e0-4e9a-964e-e913c9ed974f', 'a537ea74-a374-49cf-a933-62d1fc8f836f', 'a5c5d519-1830-4412-b6fb-52d10a4ad739', 'a6eb881a-740d-4d7c-9fa4-9c81c369e2af', 'a72bc4d2-8571-496b-9074-661455508294', 'a74b6cab-b910-44bf-bc3b-62b7a6c2216b', 'a7b174d0-0379-4556-b69e-9d3d2a75421e', 'a9521d20-f976-4b37-a9cd-e73d113ae03c', 'a9711d26-0646-4d69-bb93-c9fa8e6f1fb3', 'aa7280bc-01d4-44bb-9b7e-214216c7d2d6', 'abb18933-246c-4204-b05b-e40f665eba81', 'abdfed0e-c271-4334-9e8c-22daaee96354', 'ae6d9bc6-86f6-40cb-8983-caf9be98afa6', 'af0fd641-686e-4a26-99a3-723bf30cd0b4', 'b196484a-6600-4517-89a1-37dd02c22cf9', 'b344e31e-517e-4abd-80bc-5ee15ac05284', 'b38cbf1b-3632-4750-8a55-a2a448111b2a', 'b42f460c-5b69-4e2a-a2d8-e6eef4368b46', 'b464a862-d041-4fa0-8e44-c6c819ca5dc7', 'b4b88413-54dd-452d-8f65-8439f55b0e80', 'b4df2527-bc35-4d28-9c81-c0edf21170cf', 'b86ee0a4-62ae-447c-a838-2cee605c5e88', 'b8b1bd03-988b-40d0-ad59-c40f20b84245', 'b9254169-fcff-4bc5-a129-fc0250301e75', 'b955bec5-8f4b-46ad-a0aa-8d75ca71ecd8', 'b969c161-5ed8-48c7-b686-18f2fb315ec3', 'bb451739-550c-4974-b3dd-708360516939', 'bb6b2057-f010-4647-9cdd-398f9b020229', 'bc9a1405-4c1a-41d6-b15e-328f7039305e', 'bda80530-8cab-48f9-ae83-50109bfc4162', 'bdc430af-b4d4-4ebc-90ac-2ac555c69970', 'be128173-5367-48c6-ac1a-87d181ab316d', 'be9e6b82-632e-45df-8bce-ab76e8c9db9a', 'becb1216-d30a-4572-97fd-333f87113775', 'befd1b74-4f93-42e6-943b-025ed709d58b', 'befd329d-b442-4e8b-8053-720576725a04', 'bf8df2f7-84d9-479d-900c-a7bf23c6312d', 'bfc342b1-8dad-42ca-b8a1-d8f87d5e274d', 'bfd12268-f2d9-49d0-8d4f-e55c7b2bbd80', 'bffd1dd0-bef2-4716-ac02-62ee3e4cade3', 'c20e10a3-62dd-4c8b-93b7-a704f3338c06', 'c2d86161-8797-4b1c-b4ed-b59c4a2cf436', '001f1c26-0b38-4294-9a0b-c36d1ff5f369', 'c40a978b-297b-4ac5-909d-d63437eb62be', '003d0669-289b-4727-9271-96f49eea7dfe', 'c6abb2d6-ff6c-4344-a162-3b4ab26e5e77', 'c84ea125-f2d1-475c-960f-4c0e0f235cd4', '009477f2-1b77-4314-9404-51a3d4d57f65', 'c898301a-60f3-4ffb-b06b-88c8c4cf91b3', '015e282a-ce00-40e9-846d-21fbd5800dcb', 'c89ddf4f-20af-4363-99a9-38595f8b6a10', '01d8d07a-d3b7-4737-8ccb-baa3c2c7cf26', 'c8b4b906-d784-4f41-b4b6-1bb887b89405', '030d94e4-e370-4c6c-bae7-a276f63da3bf', 'c8b60743-2a52-4675-aa64-17dbf34e0150', '03169289-f05e-41f0-91fc-da42e8675da9', 'c8ccb0ea-3c47-4e4c-93a2-68228c1a409f', '0348b66a-1803-411b-b920-78e80bedba03', 'c8de379a-6734-4506-b0de-5987c8d0cb16', '05b11a27-8796-48ce-92db-6d87c6905829', 'ca8b7f03-8162-4c9c-82ae-9d3c5760d86d', '05cbd995-163d-4854-8865-583382a5d0fe', 'ca8e28f7-f6bd-4048-bed0-b223ea8c9d9f', '0600e203-2a0c-4c06-8190-21ffb8875a4c', 'cb3b867c-1ed9-4bce-b33d-5c100da95740', '08a00483-c3bc-44c3-a984-2bc4108f8784', 'cb8b9574-7df4-4ef6-a7fe-679d63ad03b2', '095353fa-caca-4d90-aaaf-6c83ce01eb5a', 'cc6a15a1-4a9a-4f8e-a5d5-9abbb3ad2720', '0bb237c6-34ea-4114-b563-97fb45c6f42c', 'cc8a14d4-52dd-40d2-a546-23c8c6aebc43', '0c45c8c0-d661-4b44-8266-ae80983ae11b', 'cf2864e9-4740-43a6-b92c-7b33b446b939', '0d0cf456-e903-47e3-bd50-2cc1a4eb99c1', 'cf9915b8-27b9-4c34-a7a9-2ade59647497', '0d181391-c4e9-46c5-8867-de2f339c2404', 'd0f6176f-30b3-49ca-8fe8-bb39f052686f', '0f7476d1-32f4-4357-9e87-ee832e46da05', 'd15d194f-b881-49a4-bb00-38f54a597470', '10532f72-c221-437e-824e-8699be162207', 'd18f5541-b22c-47e6-91c9-9d9b50c3bb2c', '113a6cb2-6ad4-49da-b55d-6517545f3139', 'd216212a-5872-4b66-9ca1-0c31856908db', '11d63ff4-3f0b-4582-85a7-35655c21954d', 'd2693d35-c4a1-48db-9f53-9589ee3e1d7c', '12409a97-8a5f-49e2-8450-3fcd670ca0a5', 'd3b4d0fe-f67e-46a5-b6e3-4ced4a4f07ca', '12647e25-92fd-4c4f-8b2f-967579913c27', 'd6f89ec6-0f49-4c54-a456-2a8bdbe6552d', '127b5ae0-a767-4ea4-9426-da13efb07103', 'd714c733-9c09-40a0-b54b-ab30f9444db3', '1426b845-171c-489a-be03-e29d6ba4ef73', 'd86fa561-a100-4510-a88a-96f7a52ff27c', '147cd77a-eaac-4af1-b03e-d95b9e3355e1', 'd8cbdb94-2111-4bcc-961c-3211c175eb03', '15ac1c1f-88e7-481e-9fcf-ef560f74f600', 'd97ed3e1-08af-4924-9adc-845d8001d034', '15ea2bcd-3caa-4b89-bc76-08f9308b2995', 'da982a8d-8986-4b0e-90d5-294ae49d1cbe', '171ae8f6-104b-4919-87c4-ed214a8d1c3d', 'dcbb1683-fed3-4016-9101-258ce9cf96ac', '1725d346-d990-469b-98fb-0455e2ef5b4e', 'df3422b9-255d-4ab3-af73-8834c4847af7', '172ddb07-c5fb-430e-bf14-ae37dce21a12', 'df6065f4-7c48-4a6f-8b9a-f39c3e62f402', '18bf1fb6-35b4-43ed-b463-b283d5e588f4', 'e25af105-fa48-48f9-ab5a-7d9adccf774a', '18d0829f-063d-4e92-a34e-9a997f5d6984', 'e372be0e-3cc3-41e6-bb1e-bc16139613e3', '1b065624-9b4b-4118-9bcc-5600e65d9d8b', 'e4be5349-91dc-4429-946f-1babc75aee1e', '1b723576-8563-42a4-9237-abaf91958f26', 'e4ffbd7f-7e86-4306-a10e-dc232cfe57b6', '1bcb0dc1-cfcc-42cb-b2c0-5ceaa868d775', 'e534fcac-d032-4e8c-9f05-65279a3ce0ab', '1c16ff90-1dc6-46cb-9803-3d6ed58e5688', 'e58843ca-9096-4bdf-b490-9e988635eb1c', '1c3bf896-fada-4260-a619-47a9986d50a5', 'e625603a-2ba2-4b38-83cc-bb2113abdc7f', '1ccd3d62-47c7-4570-bfae-41ce79c7bb56', 'e64286a2-c208-410a-b325-0d78b6c18b1f', '1d5f0729-afcb-4636-827c-8610db02d326', 'e6d132cc-b5b7-426e-ad66-464e331ff747', '1e2afb64-c846-4773-b744-3a1b1617d695', 'e82f938f-f4f2-4001-95fe-e783ab6d2d09', '1f94876d-5da1-4f24-b786-d4a4b6e99c73', 'e88ab716-c4bc-44af-8394-b5488083a1b3', '1fa6de09-f344-4624-8256-8488058600cd', 'e8fa700c-8194-4c86-ab83-d575547bc626', '20c67baa-308d-46a5-9b40-111f0b2186f3', 'e9f3d079-f497-40e0-a555-31834ae78639', '20fbb21d-4d80-4fa4-beae-6a0c27351a33', 'ec3c5435-bb24-42da-a706-17c39692bb5a', '2176f775-3b96-4813-808d-627d03f56801', 'ed8b9bb7-b560-4ef6-b21b-a1a0838e1dd0', '21a5e034-e9a4-4f03-8327-567deddb730a', 'ed9d424c-1c87-4ab4-b139-6fb1bb46dabc', '22a27e33-06d4-48e6-9145-069707b3706f', 'edb643e2-e685-462c-84a5-07038b7b445b', '23ddc204-56dd-4ad6-b60e-350e4f8aeb58', 'edde72c2-bc27-43f1-8468-a522bea66ccc', '23eb593e-53b6-4347-aadd-a360733c71d6', 'eded4b6c-61d4-4e65-b6ee-4e7aaaeec1c6', '25ab35d4-07fd-46dd-8d51-1bac44a84aab', 'eec63979-db6d-406e-bcae-0677dcf71d96', '261b1742-1538-452e-a863-c9a2f8abe5d4', 'efb9aab7-9d10-4b61-ba9f-eb484067239a', '27da38e7-ffd6-48b6-af02-de16ab715893', 'f03df520-78cd-4996-81cb-f995948ce2c7', '2a09e209-5d72-4286-be90-9daef28e1ddf', 'f043f12b-fc37-447d-b07d-22d4ebfb4675', '2a1c62a2-b9b0-47d3-bbf4-caaeffb487b0', 'f044555c-db66-4b0a-987a-383978c1db28', '2ac8cda2-9141-4f11-b5a0-386868607633', 'f1645869-d0c2-49e9-b24a-a05dfc852efa', '2b1e23db-80fb-4e46-9e9c-1634dc754e90', 'f17261e0-445d-482a-b194-0adf68624380', '2b260348-5f0b-4566-a8c2-20c719f89703', 'f1ca53b0-93ec-4676-9bb4-7098e005ca12', '2b8b09a1-0053-4a53-94f6-ed5d1767d624', 'f2ff0e8f-3bd3-4f6e-958c-053ebadd8878', '2c17c007-7b36-42d9-946b-25e1f91d1342', 'f3dcf405-f7d8-4fae-9914-86fd217231fa', '2c32efa2-e01d-4b8c-9811-4073e110a5e7', 'f452d08d-150b-430c-8d79-4b14b36c4950', '2d062abc-474a-43f5-862d-ac0daf11bda0', 'f47fab3c-b06d-46a5-99c7-66545bee8461', '2d97966a-0c01-44ed-ba44-3705037329e4', 'f5349134-334f-4f8b-b2cd-9ba8929eaa6a', '2e99943d-d95b-496d-88e3-69c510eac234', 'f68a1d74-3026-4f6b-9e4f-09107278ddfe', '2f14c257-c399-4d3b-a690-3270f072f743', 'f75b4869-f37e-4274-a0fc-3df9fa5cafd3', '2f3742c1-4775-4348-9496-dc802accfcf3', 'f773aefb-a1db-4058-b0c4-a3e7849ab9d1', '2f950259-30fe-4d7a-94cb-5a4460a30f98', 'f89bfcf1-d692-4236-b8de-fe1ad785a6de', '31680cad-d73f-4192-996b-38a839745d39', 'f93f571d-16d6-446b-adbc-416d04f2b8cc', '328700ff-d209-41b9-a925-0de7e7b32542', 'f9f97065-ae81-49fd-831e-39baaec0cb56', '328ffc1b-d760-471b-8257-50f5ca68a322', 'fa5b9883-8ca1-4bdc-882c-8a7fbd5cb648', '32950cf7-43a2-4e6a-8f01-45f9d971b3a3', 'fb752442-f6d3-4020-875b-86c85da86109', '3323bad6-99d3-4f76-9c0a-79990c9c45ac', 'fbad12c8-cd2d-4e39-8bee-6deaadd3b64e', '339c7ac8-e66a-41d1-9365-82f68db40ec0', 'fc438edb-0716-4b93-a3c3-dbe9568ea2b1', '34d2bc73-4ddb-4548-85b8-cdfb628dd2d0', 'fd2a04e8-3ec8-4eb4-9eca-5695ead02192', '3714227d-13de-4c93-9c39-c028423b0780', 'fde204ab-5ac9-4f63-baa6-01d57deeba9f', '373b4bf0-d658-4a51-9afe-4f9a9074fa99', 'fe06a684-fe76-4179-b88b-2099ebef5af8', '37c204b5-765e-46ff-9f1c-822decb68705', 'ff4404d2-3416-4d5e-9a3b-e4ac74ed6545', '389f8888-c667-40f1-bf89-a0ab6908d5c1', '38a770a8-7d75-49a3-851c-bcb70aedef78', '399a05c7-4c5f-4b5e-87e1-28eb886d6864', '399a2ff2-da15-4b8e-be32-fc4684ef0082', '3aab1732-f42d-44c2-b74c-aef9ed4fceac', '3b0658c9-1b60-4a79-b4b4-019fb74a8c36', '3b06b944-579f-467e-ba9d-d78319a47004', '3b7c1384-31c7-48b7-90b4-9ed3a50b2a5a', '3b9a9cc0-9ebc-4628-b7f3-76a411c5fbca', '3bd6cba8-6d78-4fcf-8d72-cd5cf21ee059', '3cf2a732-9f4d-42a2-bbf4-a1d1c62ed3bc', '3d36a48a-e1b8-4433-bbd2-315f35a45ae6', '3e44148e-9cb6-449b-b7ae-662eae7bc6e9', '3e9cdf75-c858-4511-94f5-8d457864a572', '3ef66c88-5d5a-4474-9c21-9e3092a95e94', '407d260c-445a-446f-ba42-507a214f3af1', '417e15a9-c276-44ab-a337-6edf269e1167', '438d66ff-087b-47ba-a88c-43016a332484', '4395c9ed-a988-4d41-b578-9f6784af1393', '44a9a5f5-3524-48a1-9d99-8dae8a972f90', '46b2c5a2-7951-434a-aab7-ef451ab48691', '487f1384-4708-4ba0-b4da-32104bf79638', '49406784-b26c-435a-9331-f462b709e81a', '4a4d8954-8f3f-4154-9517-b461219f0a45', '4a7cf0ed-fe19-427d-913a-814cf076871a', '4b3163b1-752e-46da-81b4-cfacc7928680', '4b4c8de5-f620-4a97-b519-7c008014a76f', '4b65bc52-acd4-4b79-8bd8-51389a9f6282', '4b7f11ed-0982-42be-931b-6ce4c5dcae1f', '4c60c1b2-1118-446f-b238-5f781a5aab6e', '4d02f495-db0a-46a8-89e1-b206bc8948e6', '4d255bb4-5069-45ee-b609-725704a1d768', '4d7a6cfa-f31d-49ba-b026-80e5d239e05e', '4e93d4b0-a14f-486c-a66a-ce58a9b384ad', '4ec7a2e1-dccf-4560-abd1-958645760b6e', '4f52a504-a6df-4022-9283-8381c33192bc', '4fc26bab-086f-41ae-a562-e88d12265df6', '505a9985-70d3-4c5b-aabe-64d06f350cd4', '529c8434-284d-44fe-8cd8-a14de2ac340a', '52f978b8-c166-4afb-a4b9-d7a518374df6', '5429b2b9-3d96-4653-bc72-4c944015bda7', '55cae66c-0fe0-4f51-b024-ba81d2157524', '567f911e-fec4-4197-b1f2-fcfb39bfa04e', '57615d6d-e0d8-429b-a046-1768f2dbba3e', '579d46ef-f051-48f6-ae53-52fd4fbafc93', '57ae8e01-a329-4759-bb27-3226f679a6a4', '57e383db-5154-4486-9738-0d12a90f462f', '58cc1540-6d0c-4bd3-96ff-e797208719c3', '5aabf26b-1377-420a-bc65-47c570fc7a73', '5d48ddfa-3ab7-47cc-802c-3e27566357af', '5d535153-4b45-41ea-9a72-f52a6d9192b6', '60a6ae8d-3536-45a5-9352-72b5ed4ccc18', '61081533-ffdf-45bf-af0f-8bf66212edd0', '63a27745-24ca-4fc0-b42f-5c5f6169e601', '641350f2-8e59-440c-b213-01b5b94f29df', '652c9e99-5a45-43e4-bf3f-611c68994cda', '6588916b-653b-4be0-9f9e-39a7a27d9ecb', '66112f84-e598-4569-b735-af64c71301bf', '6894b678-86d1-482d-93c9-8d517414ad44', '69c040f9-2048-4b7c-9153-5fa57cdbf5ef', '6ef1cb0d-03ec-4800-980e-694bc903be03', '6fa4ffaa-8b09-4588-8485-457f3046f88e', '6fb7bb13-f660-4051-8ef0-69b6f1c80ed5', '702b9fee-7f2c-4dd8-b4c7-7ae3181b05db', '70fdb753-b32b-43b9-b083-f88bab3f1fe3', '710c9921-0e87-4e12-aed3-2f35805ba20a', '725f6cfb-f295-4f09-bc69-3646ced686d8', '72934627-f00a-4b37-96e9-2449a9647be1', '73d700dc-034a-4970-8354-bcea24ca3d88', '748d45de-340c-4ea9-9b37-737b93aca70f', '74f399bd-8a08-44a2-9b69-e245ffecc7fd', '75794aca-8eca-409f-bc2d-18b14d737179', '75c7e4c2-4e98-457f-bcdf-7206b2e9c1e6', '76419ef4-56e6-4690-800e-962fb995b579', '76c8f416-847e-4790-8f87-8c7f528d871a', '77411520-8497-44f7-8f7f-261653b1fd76', '7768c73b-2450-433e-97e4-e50b67377ebf', '77cef6c7-51c1-4b0e-ac27-0d90d2c8b7a5', '77dbc682-9a53-472a-8c96-c4a8176d0d25', '7877c7e6-b4fd-4ee0-add1-c215bb08bfff', '7958b838-143f-437f-a6b8-f8860063d5f5', '79ab7294-1665-4ebe-ac9b-242a962908a2', '79e0d911-ffb5-4bca-a165-982bc1c5c69d', '7a37ba95-1e82-49af-af05-bd277ac5d666', '7b000d6e-e375-425c-9089-f7150c64d4c9', '7b1694cb-9516-46d1-9c1b-f5bc1552b2ae', '7b7cf37a-08f7-42b6-bfe8-aab41cb8a3f0', '7bef25c6-1b2e-47d2-a195-cf2e81130cee', '7c01da0f-f5ce-4996-b835-b76bbe3e5001', '7c3e4f50-9483-4172-b851-7ce962485848', '7cc0a1ad-8811-47a5-8cb2-1747b589a415', '7e003fa1-a9d5-44d4-87de-6d7a90d6ce45', '7e685a80-7c18-4dac-a3f1-c76486ea91b1', '7fc67674-0eab-497a-87eb-cf68353465b1', '825b18cf-7151-42d7-ab81-c50f8b3cfe33', '8260883c-32fa-4b0a-871c-0fe8ea500a15', '82920c97-ae34-46d9-9ad0-386a451b00c4', '830a8b27-b71a-4cb6-a943-d74dc9b05288', '83d68b94-40b3-4f37-94d0-decd62c32716', '83e9b9f5-27ea-4420-9923-d8f4eb3f814f', '84871b3c-6806-4aca-8854-c0bceb6c0cc5', '84c87108-4558-4bb2-8651-4748270359a5', '84fc4702-2ac6-446b-8933-7e34a2761629', '85654de9-d2cb-4801-ae8f-d2de59e23aef', '861837a7-ead1-4f83-a523-4dec12282506', '872ab539-297c-4ba8-82c3-e3a924c4bd98', '873c4b22-cd7b-4f33-9245-ac618f1393d9', '878cb27c-97e0-4d76-a06a-f930a8272b70', '893bfb6b-1e15-476a-8ebc-bfb9121fa8de', '8ce03cdb-6824-4cb6-a068-0d5cddc1ee5f', '8ce62a7d-f972-4529-bebc-a2fb8d1c8b17', '8dbd8e9d-5530-43c7-9603-2986b0db8e2c', '8dc25685-856c-4484-a7e8-d07b2a634be8', '8de2f8e3-32c0-463d-8605-347434bfb77b', '8f9b4a1e-547e-408d-b231-ca71fd24ac03', '909fc0f6-a483-4d4e-ac60-43358c621369', '90a29461-2b8b-47b0-8518-ec02786bff6d', '91f5e4ee-afbb-417b-9ea3-9de6dd2a2542', '92bb97eb-3ddd-4de9-bd6e-cb391dc98304', '93fdcf0d-f15f-47b9-ab30-4a81c9cb000b', '94b1cb9a-787d-49c3-9372-7fe6df47fb5a', '97760f7a-2204-4c8c-9a17-ea4f4deae0ec', '97937129-8cde-4c50-b3a0-f76b2440e88c', '98380577-42b0-42ec-9dee-6609adb1a1a4', '9843282f-2060-4ce0-a64e-d512cfc5ae7c', '997fc525-f620-4d3f-9415-43f614061b63') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

66. SELECT colorspec_uuid FROM tp_product_price WHERE product_uuid IN ('00747741-f013-400d-9cfb-0066012e70de', '99a1d43d-f785-429d-ad95-da187206a180', '9aa542cc-d824-4303-b0a1-585b7ed2fba8', '9aac4cfb-9176-48cc-81e2-ea60aa1f6f49', '9af25a6e-a011-4972-85f0-8c288b928054', '9b9f1e8e-d202-4b90-b45a-684e92120fa3', '9c9a2e87-a14e-4d04-9e67-39b3fb6b0ad1', '9f77bc07-0890-4534-a24b-0ee00b4f90d5', 'a1ea09a5-3871-4b52-898a-cadbad388710', 'a3a6fcc1-0e4d-4567-8555-363de573dd7c', 'a50549cc-660c-4f36-a6c9-fcb2cb70b7bf', 'a52407a4-18e0-4e9a-964e-e913c9ed974f', 'a537ea74-a374-49cf-a933-62d1fc8f836f', 'a5c5d519-1830-4412-b6fb-52d10a4ad739', 'a6eb881a-740d-4d7c-9fa4-9c81c369e2af', 'a72bc4d2-8571-496b-9074-661455508294', 'a74b6cab-b910-44bf-bc3b-62b7a6c2216b', 'a7b174d0-0379-4556-b69e-9d3d2a75421e', 'a9521d20-f976-4b37-a9cd-e73d113ae03c', 'a9711d26-0646-4d69-bb93-c9fa8e6f1fb3', 'aa7280bc-01d4-44bb-9b7e-214216c7d2d6', 'abb18933-246c-4204-b05b-e40f665eba81', 'abdfed0e-c271-4334-9e8c-22daaee96354', 'ae6d9bc6-86f6-40cb-8983-caf9be98afa6', 'af0fd641-686e-4a26-99a3-723bf30cd0b4', 'b196484a-6600-4517-89a1-37dd02c22cf9', 'b344e31e-517e-4abd-80bc-5ee15ac05284', 'b38cbf1b-3632-4750-8a55-a2a448111b2a', 'b42f460c-5b69-4e2a-a2d8-e6eef4368b46', 'b464a862-d041-4fa0-8e44-c6c819ca5dc7', 'b4b88413-54dd-452d-8f65-8439f55b0e80', 'b4df2527-bc35-4d28-9c81-c0edf21170cf', 'b86ee0a4-62ae-447c-a838-2cee605c5e88', 'b8b1bd03-988b-40d0-ad59-c40f20b84245', 'b9254169-fcff-4bc5-a129-fc0250301e75', 'b955bec5-8f4b-46ad-a0aa-8d75ca71ecd8', 'b969c161-5ed8-48c7-b686-18f2fb315ec3', 'bb451739-550c-4974-b3dd-708360516939', 'bb6b2057-f010-4647-9cdd-398f9b020229', 'bc9a1405-4c1a-41d6-b15e-328f7039305e', 'bda80530-8cab-48f9-ae83-50109bfc4162', 'bdc430af-b4d4-4ebc-90ac-2ac555c69970', 'be128173-5367-48c6-ac1a-87d181ab316d', 'be9e6b82-632e-45df-8bce-ab76e8c9db9a', 'becb1216-d30a-4572-97fd-333f87113775', 'befd1b74-4f93-42e6-943b-025ed709d58b', 'befd329d-b442-4e8b-8053-720576725a04', 'bf8df2f7-84d9-479d-900c-a7bf23c6312d', 'bfc342b1-8dad-42ca-b8a1-d8f87d5e274d', 'bfd12268-f2d9-49d0-8d4f-e55c7b2bbd80', 'bffd1dd0-bef2-4716-ac02-62ee3e4cade3', 'c20e10a3-62dd-4c8b-93b7-a704f3338c06', 'c2d86161-8797-4b1c-b4ed-b59c4a2cf436', '001f1c26-0b38-4294-9a0b-c36d1ff5f369', 'c40a978b-297b-4ac5-909d-d63437eb62be', '003d0669-289b-4727-9271-96f49eea7dfe', 'c6abb2d6-ff6c-4344-a162-3b4ab26e5e77', 'c84ea125-f2d1-475c-960f-4c0e0f235cd4', '009477f2-1b77-4314-9404-51a3d4d57f65', 'c898301a-60f3-4ffb-b06b-88c8c4cf91b3', '015e282a-ce00-40e9-846d-21fbd5800dcb', 'c89ddf4f-20af-4363-99a9-38595f8b6a10', '01d8d07a-d3b7-4737-8ccb-baa3c2c7cf26', 'c8b4b906-d784-4f41-b4b6-1bb887b89405', '030d94e4-e370-4c6c-bae7-a276f63da3bf', 'c8b60743-2a52-4675-aa64-17dbf34e0150', '03169289-f05e-41f0-91fc-da42e8675da9', 'c8ccb0ea-3c47-4e4c-93a2-68228c1a409f', '0348b66a-1803-411b-b920-78e80bedba03', 'c8de379a-6734-4506-b0de-5987c8d0cb16', '05b11a27-8796-48ce-92db-6d87c6905829', 'ca8b7f03-8162-4c9c-82ae-9d3c5760d86d', '05cbd995-163d-4854-8865-583382a5d0fe', 'ca8e28f7-f6bd-4048-bed0-b223ea8c9d9f', '0600e203-2a0c-4c06-8190-21ffb8875a4c', 'cb3b867c-1ed9-4bce-b33d-5c100da95740', '08a00483-c3bc-44c3-a984-2bc4108f8784', 'cb8b9574-7df4-4ef6-a7fe-679d63ad03b2', '095353fa-caca-4d90-aaaf-6c83ce01eb5a', 'cc6a15a1-4a9a-4f8e-a5d5-9abbb3ad2720', '0bb237c6-34ea-4114-b563-97fb45c6f42c', 'cc8a14d4-52dd-40d2-a546-23c8c6aebc43', '0c45c8c0-d661-4b44-8266-ae80983ae11b', 'cf2864e9-4740-43a6-b92c-7b33b446b939', '0d0cf456-e903-47e3-bd50-2cc1a4eb99c1', 'cf9915b8-27b9-4c34-a7a9-2ade59647497', '0d181391-c4e9-46c5-8867-de2f339c2404', 'd0f6176f-30b3-49ca-8fe8-bb39f052686f', '0f7476d1-32f4-4357-9e87-ee832e46da05', 'd15d194f-b881-49a4-bb00-38f54a597470', '10532f72-c221-437e-824e-8699be162207', 'd18f5541-b22c-47e6-91c9-9d9b50c3bb2c', '113a6cb2-6ad4-49da-b55d-6517545f3139', 'd216212a-5872-4b66-9ca1-0c31856908db', '11d63ff4-3f0b-4582-85a7-35655c21954d', 'd2693d35-c4a1-48db-9f53-9589ee3e1d7c', '12409a97-8a5f-49e2-8450-3fcd670ca0a5', 'd3b4d0fe-f67e-46a5-b6e3-4ced4a4f07ca', '12647e25-92fd-4c4f-8b2f-967579913c27', 'd6f89ec6-0f49-4c54-a456-2a8bdbe6552d', '127b5ae0-a767-4ea4-9426-da13efb07103', 'd714c733-9c09-40a0-b54b-ab30f9444db3', '1426b845-171c-489a-be03-e29d6ba4ef73', 'd86fa561-a100-4510-a88a-96f7a52ff27c', '147cd77a-eaac-4af1-b03e-d95b9e3355e1', 'd8cbdb94-2111-4bcc-961c-3211c175eb03', '15ac1c1f-88e7-481e-9fcf-ef560f74f600', 'd97ed3e1-08af-4924-9adc-845d8001d034', '15ea2bcd-3caa-4b89-bc76-08f9308b2995', 'da982a8d-8986-4b0e-90d5-294ae49d1cbe', '171ae8f6-104b-4919-87c4-ed214a8d1c3d', 'dcbb1683-fed3-4016-9101-258ce9cf96ac', '1725d346-d990-469b-98fb-0455e2ef5b4e', 'df3422b9-255d-4ab3-af73-8834c4847af7', '172ddb07-c5fb-430e-bf14-ae37dce21a12', 'df6065f4-7c48-4a6f-8b9a-f39c3e62f402', '18bf1fb6-35b4-43ed-b463-b283d5e588f4', 'e25af105-fa48-48f9-ab5a-7d9adccf774a', '18d0829f-063d-4e92-a34e-9a997f5d6984', 'e372be0e-3cc3-41e6-bb1e-bc16139613e3', '1b065624-9b4b-4118-9bcc-5600e65d9d8b', 'e4be5349-91dc-4429-946f-1babc75aee1e', '1b723576-8563-42a4-9237-abaf91958f26', 'e4ffbd7f-7e86-4306-a10e-dc232cfe57b6', '1bcb0dc1-cfcc-42cb-b2c0-5ceaa868d775', 'e534fcac-d032-4e8c-9f05-65279a3ce0ab', '1c16ff90-1dc6-46cb-9803-3d6ed58e5688', 'e58843ca-9096-4bdf-b490-9e988635eb1c', '1c3bf896-fada-4260-a619-47a9986d50a5', 'e625603a-2ba2-4b38-83cc-bb2113abdc7f', '1ccd3d62-47c7-4570-bfae-41ce79c7bb56', 'e64286a2-c208-410a-b325-0d78b6c18b1f', '1d5f0729-afcb-4636-827c-8610db02d326', 'e6d132cc-b5b7-426e-ad66-464e331ff747', '1e2afb64-c846-4773-b744-3a1b1617d695', 'e82f938f-f4f2-4001-95fe-e783ab6d2d09', '1f94876d-5da1-4f24-b786-d4a4b6e99c73', 'e88ab716-c4bc-44af-8394-b5488083a1b3', '1fa6de09-f344-4624-8256-8488058600cd', 'e8fa700c-8194-4c86-ab83-d575547bc626', '20c67baa-308d-46a5-9b40-111f0b2186f3', 'e9f3d079-f497-40e0-a555-31834ae78639', '20fbb21d-4d80-4fa4-beae-6a0c27351a33', 'ec3c5435-bb24-42da-a706-17c39692bb5a', '2176f775-3b96-4813-808d-627d03f56801', 'ed8b9bb7-b560-4ef6-b21b-a1a0838e1dd0', '21a5e034-e9a4-4f03-8327-567deddb730a', 'ed9d424c-1c87-4ab4-b139-6fb1bb46dabc', '22a27e33-06d4-48e6-9145-069707b3706f', 'edb643e2-e685-462c-84a5-07038b7b445b', '23ddc204-56dd-4ad6-b60e-350e4f8aeb58', 'edde72c2-bc27-43f1-8468-a522bea66ccc', '23eb593e-53b6-4347-aadd-a360733c71d6', 'eded4b6c-61d4-4e65-b6ee-4e7aaaeec1c6', '25ab35d4-07fd-46dd-8d51-1bac44a84aab', 'eec63979-db6d-406e-bcae-0677dcf71d96', '261b1742-1538-452e-a863-c9a2f8abe5d4', 'efb9aab7-9d10-4b61-ba9f-eb484067239a', '27da38e7-ffd6-48b6-af02-de16ab715893', 'f03df520-78cd-4996-81cb-f995948ce2c7', '2a09e209-5d72-4286-be90-9daef28e1ddf', 'f043f12b-fc37-447d-b07d-22d4ebfb4675', '2a1c62a2-b9b0-47d3-bbf4-caaeffb487b0', 'f044555c-db66-4b0a-987a-383978c1db28', '2ac8cda2-9141-4f11-b5a0-386868607633', 'f1645869-d0c2-49e9-b24a-a05dfc852efa', '2b1e23db-80fb-4e46-9e9c-1634dc754e90', 'f17261e0-445d-482a-b194-0adf68624380', '2b260348-5f0b-4566-a8c2-20c719f89703', 'f1ca53b0-93ec-4676-9bb4-7098e005ca12', '2b8b09a1-0053-4a53-94f6-ed5d1767d624', 'f2ff0e8f-3bd3-4f6e-958c-053ebadd8878', '2c17c007-7b36-42d9-946b-25e1f91d1342', 'f3dcf405-f7d8-4fae-9914-86fd217231fa', '2c32efa2-e01d-4b8c-9811-4073e110a5e7', 'f452d08d-150b-430c-8d79-4b14b36c4950', '2d062abc-474a-43f5-862d-ac0daf11bda0', 'f47fab3c-b06d-46a5-99c7-66545bee8461', '2d97966a-0c01-44ed-ba44-3705037329e4', 'f5349134-334f-4f8b-b2cd-9ba8929eaa6a', '2e99943d-d95b-496d-88e3-69c510eac234', 'f68a1d74-3026-4f6b-9e4f-09107278ddfe', '2f14c257-c399-4d3b-a690-3270f072f743', 'f75b4869-f37e-4274-a0fc-3df9fa5cafd3', '2f3742c1-4775-4348-9496-dc802accfcf3', 'f773aefb-a1db-4058-b0c4-a3e7849ab9d1', '2f950259-30fe-4d7a-94cb-5a4460a30f98', 'f89bfcf1-d692-4236-b8de-fe1ad785a6de', '31680cad-d73f-4192-996b-38a839745d39', 'f93f571d-16d6-446b-adbc-416d04f2b8cc', '328700ff-d209-41b9-a925-0de7e7b32542', 'f9f97065-ae81-49fd-831e-39baaec0cb56', '328ffc1b-d760-471b-8257-50f5ca68a322', 'fa5b9883-8ca1-4bdc-882c-8a7fbd5cb648', '32950cf7-43a2-4e6a-8f01-45f9d971b3a3', 'fb752442-f6d3-4020-875b-86c85da86109', '3323bad6-99d3-4f76-9c0a-79990c9c45ac', 'fbad12c8-cd2d-4e39-8bee-6deaadd3b64e', '339c7ac8-e66a-41d1-9365-82f68db40ec0', 'fc438edb-0716-4b93-a3c3-dbe9568ea2b1', '34d2bc73-4ddb-4548-85b8-cdfb628dd2d0', 'fd2a04e8-3ec8-4eb4-9eca-5695ead02192', '3714227d-13de-4c93-9c39-c028423b0780', 'fde204ab-5ac9-4f63-baa6-01d57deeba9f', '373b4bf0-d658-4a51-9afe-4f9a9074fa99', 'fe06a684-fe76-4179-b88b-2099ebef5af8', '37c204b5-765e-46ff-9f1c-822decb68705', 'ff4404d2-3416-4d5e-9a3b-e4ac74ed6545', '389f8888-c667-40f1-bf89-a0ab6908d5c1', '38a770a8-7d75-49a3-851c-bcb70aedef78', '399a05c7-4c5f-4b5e-87e1-28eb886d6864', '399a2ff2-da15-4b8e-be32-fc4684ef0082', '3aab1732-f42d-44c2-b74c-aef9ed4fceac', '3b0658c9-1b60-4a79-b4b4-019fb74a8c36', '3b06b944-579f-467e-ba9d-d78319a47004', '3b7c1384-31c7-48b7-90b4-9ed3a50b2a5a', '3b9a9cc0-9ebc-4628-b7f3-76a411c5fbca', '3bd6cba8-6d78-4fcf-8d72-cd5cf21ee059', '3cf2a732-9f4d-42a2-bbf4-a1d1c62ed3bc', '3d36a48a-e1b8-4433-bbd2-315f35a45ae6', '3e44148e-9cb6-449b-b7ae-662eae7bc6e9', '3e9cdf75-c858-4511-94f5-8d457864a572', '3ef66c88-5d5a-4474-9c21-9e3092a95e94', '407d260c-445a-446f-ba42-507a214f3af1', '417e15a9-c276-44ab-a337-6edf269e1167', '438d66ff-087b-47ba-a88c-43016a332484', '4395c9ed-a988-4d41-b578-9f6784af1393', '44a9a5f5-3524-48a1-9d99-8dae8a972f90', '46b2c5a2-7951-434a-aab7-ef451ab48691', '487f1384-4708-4ba0-b4da-32104bf79638', '49406784-b26c-435a-9331-f462b709e81a', '4a4d8954-8f3f-4154-9517-b461219f0a45', '4a7cf0ed-fe19-427d-913a-814cf076871a', '4b3163b1-752e-46da-81b4-cfacc7928680', '4b4c8de5-f620-4a97-b519-7c008014a76f', '4b65bc52-acd4-4b79-8bd8-51389a9f6282', '4b7f11ed-0982-42be-931b-6ce4c5dcae1f', '4c60c1b2-1118-446f-b238-5f781a5aab6e', '4d02f495-db0a-46a8-89e1-b206bc8948e6', '4d255bb4-5069-45ee-b609-725704a1d768', '4d7a6cfa-f31d-49ba-b026-80e5d239e05e', '4e93d4b0-a14f-486c-a66a-ce58a9b384ad', '4ec7a2e1-dccf-4560-abd1-958645760b6e', '4f52a504-a6df-4022-9283-8381c33192bc', '4fc26bab-086f-41ae-a562-e88d12265df6', '505a9985-70d3-4c5b-aabe-64d06f350cd4', '529c8434-284d-44fe-8cd8-a14de2ac340a', '52f978b8-c166-4afb-a4b9-d7a518374df6', '5429b2b9-3d96-4653-bc72-4c944015bda7', '55cae66c-0fe0-4f51-b024-ba81d2157524', '567f911e-fec4-4197-b1f2-fcfb39bfa04e', '57615d6d-e0d8-429b-a046-1768f2dbba3e', '579d46ef-f051-48f6-ae53-52fd4fbafc93', '57ae8e01-a329-4759-bb27-3226f679a6a4', '57e383db-5154-4486-9738-0d12a90f462f', '58cc1540-6d0c-4bd3-96ff-e797208719c3', '5aabf26b-1377-420a-bc65-47c570fc7a73', '5d48ddfa-3ab7-47cc-802c-3e27566357af', '5d535153-4b45-41ea-9a72-f52a6d9192b6', '60a6ae8d-3536-45a5-9352-72b5ed4ccc18', '61081533-ffdf-45bf-af0f-8bf66212edd0', '63a27745-24ca-4fc0-b42f-5c5f6169e601', '641350f2-8e59-440c-b213-01b5b94f29df', '652c9e99-5a45-43e4-bf3f-611c68994cda', '6588916b-653b-4be0-9f9e-39a7a27d9ecb', '66112f84-e598-4569-b735-af64c71301bf', '6894b678-86d1-482d-93c9-8d517414ad44', '69c040f9-2048-4b7c-9153-5fa57cdbf5ef', '6ef1cb0d-03ec-4800-980e-694bc903be03', '6fa4ffaa-8b09-4588-8485-457f3046f88e', '6fb7bb13-f660-4051-8ef0-69b6f1c80ed5', '702b9fee-7f2c-4dd8-b4c7-7ae3181b05db', '70fdb753-b32b-43b9-b083-f88bab3f1fe3', '710c9921-0e87-4e12-aed3-2f35805ba20a', '725f6cfb-f295-4f09-bc69-3646ced686d8', '72934627-f00a-4b37-96e9-2449a9647be1', '73d700dc-034a-4970-8354-bcea24ca3d88', '748d45de-340c-4ea9-9b37-737b93aca70f', '74f399bd-8a08-44a2-9b69-e245ffecc7fd', '75794aca-8eca-409f-bc2d-18b14d737179', '75c7e4c2-4e98-457f-bcdf-7206b2e9c1e6', '76419ef4-56e6-4690-800e-962fb995b579', '76c8f416-847e-4790-8f87-8c7f528d871a', '77411520-8497-44f7-8f7f-261653b1fd76', '7768c73b-2450-433e-97e4-e50b67377ebf', '77cef6c7-51c1-4b0e-ac27-0d90d2c8b7a5', '77dbc682-9a53-472a-8c96-c4a8176d0d25', '7877c7e6-b4fd-4ee0-add1-c215bb08bfff', '7958b838-143f-437f-a6b8-f8860063d5f5', '79ab7294-1665-4ebe-ac9b-242a962908a2', '79e0d911-ffb5-4bca-a165-982bc1c5c69d', '7a37ba95-1e82-49af-af05-bd277ac5d666', '7b000d6e-e375-425c-9089-f7150c64d4c9', '7b1694cb-9516-46d1-9c1b-f5bc1552b2ae', '7b7cf37a-08f7-42b6-bfe8-aab41cb8a3f0', '7bef25c6-1b2e-47d2-a195-cf2e81130cee', '7c01da0f-f5ce-4996-b835-b76bbe3e5001', '7c3e4f50-9483-4172-b851-7ce962485848', '7cc0a1ad-8811-47a5-8cb2-1747b589a415', '7e003fa1-a9d5-44d4-87de-6d7a90d6ce45', '7e685a80-7c18-4dac-a3f1-c76486ea91b1', '7fc67674-0eab-497a-87eb-cf68353465b1', '825b18cf-7151-42d7-ab81-c50f8b3cfe33', '8260883c-32fa-4b0a-871c-0fe8ea500a15', '82920c97-ae34-46d9-9ad0-386a451b00c4', '830a8b27-b71a-4cb6-a943-d74dc9b05288', '83d68b94-40b3-4f37-94d0-decd62c32716', '83e9b9f5-27ea-4420-9923-d8f4eb3f814f', '84871b3c-6806-4aca-8854-c0bceb6c0cc5', '84c87108-4558-4bb2-8651-4748270359a5', '84fc4702-2ac6-446b-8933-7e34a2761629', '85654de9-d2cb-4801-ae8f-d2de59e23aef', '861837a7-ead1-4f83-a523-4dec12282506', '872ab539-297c-4ba8-82c3-e3a924c4bd98', '873c4b22-cd7b-4f33-9245-ac618f1393d9', '878cb27c-97e0-4d76-a06a-f930a8272b70', '893bfb6b-1e15-476a-8ebc-bfb9121fa8de', '8ce03cdb-6824-4cb6-a068-0d5cddc1ee5f', '8ce62a7d-f972-4529-bebc-a2fb8d1c8b17', '8dbd8e9d-5530-43c7-9603-2986b0db8e2c', '8dc25685-856c-4484-a7e8-d07b2a634be8', '8de2f8e3-32c0-463d-8605-347434bfb77b', '8f9b4a1e-547e-408d-b231-ca71fd24ac03', '909fc0f6-a483-4d4e-ac60-43358c621369', '90a29461-2b8b-47b0-8518-ec02786bff6d', '91f5e4ee-afbb-417b-9ea3-9de6dd2a2542', '92bb97eb-3ddd-4de9-bd6e-cb391dc98304', '93fdcf0d-f15f-47b9-ab30-4a81c9cb000b', '94b1cb9a-787d-49c3-9372-7fe6df47fb5a', '97760f7a-2204-4c8c-9a17-ea4f4deae0ec', '97937129-8cde-4c50-b3a0-f76b2440e88c', '98380577-42b0-42ec-9dee-6609adb1a1a4', '9843282f-2060-4ce0-a64e-d512cfc5ae7c', '997fc525-f620-4d3f-9415-43f614061b63') GROUP BY colorspec_uuid sec

67. SELECT * FROM tp_4over_product_option_rules WHERE category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 ('00747741-f013-400d-9cfb-0066012e70de', '99a1d43d-f785-429d-ad95-da187206a180', '9aa542cc-d824-4303-b0a1-585b7ed2fba8', '9aac4cfb-9176-48cc-81e2-ea60aa1f6f49', '9af25a6e-a011-4972-85f0-8c288b928054', '9b9f1e8e-d202-4b90-b45a-684e92120fa3', '9c9a2e87-a14e-4d04-9e67-39b3fb6b0ad1', '9f77bc07-0890-4534-a24b-0ee00b4f90d5', 'a1ea09a5-3871-4b52-898a-cadbad388710', 'a3a6fcc1-0e4d-4567-8555-363de573dd7c', 'a50549cc-660c-4f36-a6c9-fcb2cb70b7bf', 'a52407a4-18e0-4e9a-964e-e913c9ed974f', 'a537ea74-a374-49cf-a933-62d1fc8f836f', 'a5c5d519-1830-4412-b6fb-52d10a4ad739', 'a6eb881a-740d-4d7c-9fa4-9c81c369e2af', 'a72bc4d2-8571-496b-9074-661455508294', 'a74b6cab-b910-44bf-bc3b-62b7a6c2216b', 'a7b174d0-0379-4556-b69e-9d3d2a75421e', 'a9521d20-f976-4b37-a9cd-e73d113ae03c', 'a9711d26-0646-4d69-bb93-c9fa8e6f1fb3', 'aa7280bc-01d4-44bb-9b7e-214216c7d2d6', 'abb18933-246c-4204-b05b-e40f665eba81', 'abdfed0e-c271-4334-9e8c-22daaee96354', 'ae6d9bc6-86f6-40cb-8983-caf9be98afa6', 'af0fd641-686e-4a26-99a3-723bf30cd0b4', 'b196484a-6600-4517-89a1-37dd02c22cf9', 'b344e31e-517e-4abd-80bc-5ee15ac05284', 'b38cbf1b-3632-4750-8a55-a2a448111b2a', 'b42f460c-5b69-4e2a-a2d8-e6eef4368b46', 'b464a862-d041-4fa0-8e44-c6c819ca5dc7', 'b4b88413-54dd-452d-8f65-8439f55b0e80', 'b4df2527-bc35-4d28-9c81-c0edf21170cf', 'b86ee0a4-62ae-447c-a838-2cee605c5e88', 'b8b1bd03-988b-40d0-ad59-c40f20b84245', 'b9254169-fcff-4bc5-a129-fc0250301e75', 'b955bec5-8f4b-46ad-a0aa-8d75ca71ecd8', 'b969c161-5ed8-48c7-b686-18f2fb315ec3', 'bb451739-550c-4974-b3dd-708360516939', 'bb6b2057-f010-4647-9cdd-398f9b020229', 'bc9a1405-4c1a-41d6-b15e-328f7039305e', 'bda80530-8cab-48f9-ae83-50109bfc4162', 'bdc430af-b4d4-4ebc-90ac-2ac555c69970', 'be128173-5367-48c6-ac1a-87d181ab316d', 'be9e6b82-632e-45df-8bce-ab76e8c9db9a', 'becb1216-d30a-4572-97fd-333f87113775', 'befd1b74-4f93-42e6-943b-025ed709d58b', 'befd329d-b442-4e8b-8053-720576725a04', 'bf8df2f7-84d9-479d-900c-a7bf23c6312d', 'bfc342b1-8dad-42ca-b8a1-d8f87d5e274d', 'bfd12268-f2d9-49d0-8d4f-e55c7b2bbd80', 'bffd1dd0-bef2-4716-ac02-62ee3e4cade3', 'c20e10a3-62dd-4c8b-93b7-a704f3338c06', 'c2d86161-8797-4b1c-b4ed-b59c4a2cf436', '001f1c26-0b38-4294-9a0b-c36d1ff5f369', 'c40a978b-297b-4ac5-909d-d63437eb62be', '003d0669-289b-4727-9271-96f49eea7dfe', 'c6abb2d6-ff6c-4344-a162-3b4ab26e5e77', 'c84ea125-f2d1-475c-960f-4c0e0f235cd4', '009477f2-1b77-4314-9404-51a3d4d57f65', 'c898301a-60f3-4ffb-b06b-88c8c4cf91b3', '015e282a-ce00-40e9-846d-21fbd5800dcb', 'c89ddf4f-20af-4363-99a9-38595f8b6a10', '01d8d07a-d3b7-4737-8ccb-baa3c2c7cf26', 'c8b4b906-d784-4f41-b4b6-1bb887b89405', '030d94e4-e370-4c6c-bae7-a276f63da3bf', 'c8b60743-2a52-4675-aa64-17dbf34e0150', '03169289-f05e-41f0-91fc-da42e8675da9', 'c8ccb0ea-3c47-4e4c-93a2-68228c1a409f', '0348b66a-1803-411b-b920-78e80bedba03', 'c8de379a-6734-4506-b0de-5987c8d0cb16', '05b11a27-8796-48ce-92db-6d87c6905829', 'ca8b7f03-8162-4c9c-82ae-9d3c5760d86d', '05cbd995-163d-4854-8865-583382a5d0fe', 'ca8e28f7-f6bd-4048-bed0-b223ea8c9d9f', '0600e203-2a0c-4c06-8190-21ffb8875a4c', 'cb3b867c-1ed9-4bce-b33d-5c100da95740', '08a00483-c3bc-44c3-a984-2bc4108f8784', 'cb8b9574-7df4-4ef6-a7fe-679d63ad03b2', '095353fa-caca-4d90-aaaf-6c83ce01eb5a', 'cc6a15a1-4a9a-4f8e-a5d5-9abbb3ad2720', '0bb237c6-34ea-4114-b563-97fb45c6f42c', 'cc8a14d4-52dd-40d2-a546-23c8c6aebc43', '0c45c8c0-d661-4b44-8266-ae80983ae11b', 'cf2864e9-4740-43a6-b92c-7b33b446b939', '0d0cf456-e903-47e3-bd50-2cc1a4eb99c1', 'cf9915b8-27b9-4c34-a7a9-2ade59647497', '0d181391-c4e9-46c5-8867-de2f339c2404', 'd0f6176f-30b3-49ca-8fe8-bb39f052686f', '0f7476d1-32f4-4357-9e87-ee832e46da05', 'd15d194f-b881-49a4-bb00-38f54a597470', '10532f72-c221-437e-824e-8699be162207', 'd18f5541-b22c-47e6-91c9-9d9b50c3bb2c', '113a6cb2-6ad4-49da-b55d-6517545f3139', 'd216212a-5872-4b66-9ca1-0c31856908db', '11d63ff4-3f0b-4582-85a7-35655c21954d', 'd2693d35-c4a1-48db-9f53-9589ee3e1d7c', '12409a97-8a5f-49e2-8450-3fcd670ca0a5', 'd3b4d0fe-f67e-46a5-b6e3-4ced4a4f07ca', '12647e25-92fd-4c4f-8b2f-967579913c27', 'd6f89ec6-0f49-4c54-a456-2a8bdbe6552d', '127b5ae0-a767-4ea4-9426-da13efb07103', 'd714c733-9c09-40a0-b54b-ab30f9444db3', '1426b845-171c-489a-be03-e29d6ba4ef73', 'd86fa561-a100-4510-a88a-96f7a52ff27c', '147cd77a-eaac-4af1-b03e-d95b9e3355e1', 'd8cbdb94-2111-4bcc-961c-3211c175eb03', '15ac1c1f-88e7-481e-9fcf-ef560f74f600', 'd97ed3e1-08af-4924-9adc-845d8001d034', '15ea2bcd-3caa-4b89-bc76-08f9308b2995', 'da982a8d-8986-4b0e-90d5-294ae49d1cbe', '171ae8f6-104b-4919-87c4-ed214a8d1c3d', 'dcbb1683-fed3-4016-9101-258ce9cf96ac', '1725d346-d990-469b-98fb-0455e2ef5b4e', 'df3422b9-255d-4ab3-af73-8834c4847af7', '172ddb07-c5fb-430e-bf14-ae37dce21a12', 'df6065f4-7c48-4a6f-8b9a-f39c3e62f402', '18bf1fb6-35b4-43ed-b463-b283d5e588f4', 'e25af105-fa48-48f9-ab5a-7d9adccf774a', '18d0829f-063d-4e92-a34e-9a997f5d6984', 'e372be0e-3cc3-41e6-bb1e-bc16139613e3', '1b065624-9b4b-4118-9bcc-5600e65d9d8b', 'e4be5349-91dc-4429-946f-1babc75aee1e', '1b723576-8563-42a4-9237-abaf91958f26', 'e4ffbd7f-7e86-4306-a10e-dc232cfe57b6', '1bcb0dc1-cfcc-42cb-b2c0-5ceaa868d775', 'e534fcac-d032-4e8c-9f05-65279a3ce0ab', '1c16ff90-1dc6-46cb-9803-3d6ed58e5688', 'e58843ca-9096-4bdf-b490-9e988635eb1c', '1c3bf896-fada-4260-a619-47a9986d50a5', 'e625603a-2ba2-4b38-83cc-bb2113abdc7f', '1ccd3d62-47c7-4570-bfae-41ce79c7bb56', 'e64286a2-c208-410a-b325-0d78b6c18b1f', '1d5f0729-afcb-4636-827c-8610db02d326', 'e6d132cc-b5b7-426e-ad66-464e331ff747', '1e2afb64-c846-4773-b744-3a1b1617d695', 'e82f938f-f4f2-4001-95fe-e783ab6d2d09', '1f94876d-5da1-4f24-b786-d4a4b6e99c73', 'e88ab716-c4bc-44af-8394-b5488083a1b3', '1fa6de09-f344-4624-8256-8488058600cd', 'e8fa700c-8194-4c86-ab83-d575547bc626', '20c67baa-308d-46a5-9b40-111f0b2186f3', 'e9f3d079-f497-40e0-a555-31834ae78639', '20fbb21d-4d80-4fa4-beae-6a0c27351a33', 'ec3c5435-bb24-42da-a706-17c39692bb5a', '2176f775-3b96-4813-808d-627d03f56801', 'ed8b9bb7-b560-4ef6-b21b-a1a0838e1dd0', '21a5e034-e9a4-4f03-8327-567deddb730a', 'ed9d424c-1c87-4ab4-b139-6fb1bb46dabc', '22a27e33-06d4-48e6-9145-069707b3706f', 'edb643e2-e685-462c-84a5-07038b7b445b', '23ddc204-56dd-4ad6-b60e-350e4f8aeb58', 'edde72c2-bc27-43f1-8468-a522bea66ccc', '23eb593e-53b6-4347-aadd-a360733c71d6', 'eded4b6c-61d4-4e65-b6ee-4e7aaaeec1c6', '25ab35d4-07fd-46dd-8d51-1bac44a84aab', 'eec63979-db6d-406e-bcae-0677dcf71d96', '261b1742-1538-452e-a863-c9a2f8abe5d4', 'efb9aab7-9d10-4b61-ba9f-eb484067239a', '27da38e7-ffd6-48b6-af02-de16ab715893', 'f03df520-78cd-4996-81cb-f995948ce2c7', '2a09e209-5d72-4286-be90-9daef28e1ddf', 'f043f12b-fc37-447d-b07d-22d4ebfb4675', '2a1c62a2-b9b0-47d3-bbf4-caaeffb487b0', 'f044555c-db66-4b0a-987a-383978c1db28', '2ac8cda2-9141-4f11-b5a0-386868607633', 'f1645869-d0c2-49e9-b24a-a05dfc852efa', '2b1e23db-80fb-4e46-9e9c-1634dc754e90', 'f17261e0-445d-482a-b194-0adf68624380', '2b260348-5f0b-4566-a8c2-20c719f89703', 'f1ca53b0-93ec-4676-9bb4-7098e005ca12', '2b8b09a1-0053-4a53-94f6-ed5d1767d624', 'f2ff0e8f-3bd3-4f6e-958c-053ebadd8878', '2c17c007-7b36-42d9-946b-25e1f91d1342', 'f3dcf405-f7d8-4fae-9914-86fd217231fa', '2c32efa2-e01d-4b8c-9811-4073e110a5e7', 'f452d08d-150b-430c-8d79-4b14b36c4950', '2d062abc-474a-43f5-862d-ac0daf11bda0', 'f47fab3c-b06d-46a5-99c7-66545bee8461', '2d97966a-0c01-44ed-ba44-3705037329e4', 'f5349134-334f-4f8b-b2cd-9ba8929eaa6a', '2e99943d-d95b-496d-88e3-69c510eac234', 'f68a1d74-3026-4f6b-9e4f-09107278ddfe', '2f14c257-c399-4d3b-a690-3270f072f743', 'f75b4869-f37e-4274-a0fc-3df9fa5cafd3', '2f3742c1-4775-4348-9496-dc802accfcf3', 'f773aefb-a1db-4058-b0c4-a3e7849ab9d1', '2f950259-30fe-4d7a-94cb-5a4460a30f98', 'f89bfcf1-d692-4236-b8de-fe1ad785a6de', '31680cad-d73f-4192-996b-38a839745d39', 'f93f571d-16d6-446b-adbc-416d04f2b8cc', '328700ff-d209-41b9-a925-0de7e7b32542', 'f9f97065-ae81-49fd-831e-39baaec0cb56', '328ffc1b-d760-471b-8257-50f5ca68a322', 'fa5b9883-8ca1-4bdc-882c-8a7fbd5cb648', '32950cf7-43a2-4e6a-8f01-45f9d971b3a3', 'fb752442-f6d3-4020-875b-86c85da86109', '3323bad6-99d3-4f76-9c0a-79990c9c45ac', 'fbad12c8-cd2d-4e39-8bee-6deaadd3b64e', '339c7ac8-e66a-41d1-9365-82f68db40ec0', 'fc438edb-0716-4b93-a3c3-dbe9568ea2b1', '34d2bc73-4ddb-4548-85b8-cdfb628dd2d0', 'fd2a04e8-3ec8-4eb4-9eca-5695ead02192', '3714227d-13de-4c93-9c39-c028423b0780', 'fde204ab-5ac9-4f63-baa6-01d57deeba9f', '373b4bf0-d658-4a51-9afe-4f9a9074fa99', 'fe06a684-fe76-4179-b88b-2099ebef5af8', '37c204b5-765e-46ff-9f1c-822decb68705', 'ff4404d2-3416-4d5e-9a3b-e4ac74ed6545', '389f8888-c667-40f1-bf89-a0ab6908d5c1', '38a770a8-7d75-49a3-851c-bcb70aedef78', '399a05c7-4c5f-4b5e-87e1-28eb886d6864', '399a2ff2-da15-4b8e-be32-fc4684ef0082', '3aab1732-f42d-44c2-b74c-aef9ed4fceac', '3b0658c9-1b60-4a79-b4b4-019fb74a8c36', '3b06b944-579f-467e-ba9d-d78319a47004', '3b7c1384-31c7-48b7-90b4-9ed3a50b2a5a', '3b9a9cc0-9ebc-4628-b7f3-76a411c5fbca', '3bd6cba8-6d78-4fcf-8d72-cd5cf21ee059', '3cf2a732-9f4d-42a2-bbf4-a1d1c62ed3bc', '3d36a48a-e1b8-4433-bbd2-315f35a45ae6', '3e44148e-9cb6-449b-b7ae-662eae7bc6e9', '3e9cdf75-c858-4511-94f5-8d457864a572', '3ef66c88-5d5a-4474-9c21-9e3092a95e94', '407d260c-445a-446f-ba42-507a214f3af1', '417e15a9-c276-44ab-a337-6edf269e1167', '438d66ff-087b-47ba-a88c-43016a332484', '4395c9ed-a988-4d41-b578-9f6784af1393', '44a9a5f5-3524-48a1-9d99-8dae8a972f90', '46b2c5a2-7951-434a-aab7-ef451ab48691', '487f1384-4708-4ba0-b4da-32104bf79638', '49406784-b26c-435a-9331-f462b709e81a', '4a4d8954-8f3f-4154-9517-b461219f0a45', '4a7cf0ed-fe19-427d-913a-814cf076871a', '4b3163b1-752e-46da-81b4-cfacc7928680', '4b4c8de5-f620-4a97-b519-7c008014a76f', '4b65bc52-acd4-4b79-8bd8-51389a9f6282', '4b7f11ed-0982-42be-931b-6ce4c5dcae1f', '4c60c1b2-1118-446f-b238-5f781a5aab6e', '4d02f495-db0a-46a8-89e1-b206bc8948e6', '4d255bb4-5069-45ee-b609-725704a1d768', '4d7a6cfa-f31d-49ba-b026-80e5d239e05e', '4e93d4b0-a14f-486c-a66a-ce58a9b384ad', '4ec7a2e1-dccf-4560-abd1-958645760b6e', '4f52a504-a6df-4022-9283-8381c33192bc', '4fc26bab-086f-41ae-a562-e88d12265df6', '505a9985-70d3-4c5b-aabe-64d06f350cd4', '529c8434-284d-44fe-8cd8-a14de2ac340a', '52f978b8-c166-4afb-a4b9-d7a518374df6', '5429b2b9-3d96-4653-bc72-4c944015bda7', '55cae66c-0fe0-4f51-b024-ba81d2157524', '567f911e-fec4-4197-b1f2-fcfb39bfa04e', '57615d6d-e0d8-429b-a046-1768f2dbba3e', '579d46ef-f051-48f6-ae53-52fd4fbafc93', '57ae8e01-a329-4759-bb27-3226f679a6a4', '57e383db-5154-4486-9738-0d12a90f462f', '58cc1540-6d0c-4bd3-96ff-e797208719c3', '5aabf26b-1377-420a-bc65-47c570fc7a73', '5d48ddfa-3ab7-47cc-802c-3e27566357af', '5d535153-4b45-41ea-9a72-f52a6d9192b6', '60a6ae8d-3536-45a5-9352-72b5ed4ccc18', '61081533-ffdf-45bf-af0f-8bf66212edd0', '63a27745-24ca-4fc0-b42f-5c5f6169e601', '641350f2-8e59-440c-b213-01b5b94f29df', '652c9e99-5a45-43e4-bf3f-611c68994cda', '6588916b-653b-4be0-9f9e-39a7a27d9ecb', '66112f84-e598-4569-b735-af64c71301bf', '6894b678-86d1-482d-93c9-8d517414ad44', '69c040f9-2048-4b7c-9153-5fa57cdbf5ef', '6ef1cb0d-03ec-4800-980e-694bc903be03', '6fa4ffaa-8b09-4588-8485-457f3046f88e', '6fb7bb13-f660-4051-8ef0-69b6f1c80ed5', '702b9fee-7f2c-4dd8-b4c7-7ae3181b05db', '70fdb753-b32b-43b9-b083-f88bab3f1fe3', '710c9921-0e87-4e12-aed3-2f35805ba20a', '725f6cfb-f295-4f09-bc69-3646ced686d8', '72934627-f00a-4b37-96e9-2449a9647be1', '73d700dc-034a-4970-8354-bcea24ca3d88', '748d45de-340c-4ea9-9b37-737b93aca70f', '74f399bd-8a08-44a2-9b69-e245ffecc7fd', '75794aca-8eca-409f-bc2d-18b14d737179', '75c7e4c2-4e98-457f-bcdf-7206b2e9c1e6', '76419ef4-56e6-4690-800e-962fb995b579', '76c8f416-847e-4790-8f87-8c7f528d871a', '77411520-8497-44f7-8f7f-261653b1fd76', '7768c73b-2450-433e-97e4-e50b67377ebf', '77cef6c7-51c1-4b0e-ac27-0d90d2c8b7a5', '77dbc682-9a53-472a-8c96-c4a8176d0d25', '7877c7e6-b4fd-4ee0-add1-c215bb08bfff', '7958b838-143f-437f-a6b8-f8860063d5f5', '79ab7294-1665-4ebe-ac9b-242a962908a2', '79e0d911-ffb5-4bca-a165-982bc1c5c69d', '7a37ba95-1e82-49af-af05-bd277ac5d666', '7b000d6e-e375-425c-9089-f7150c64d4c9', '7b1694cb-9516-46d1-9c1b-f5bc1552b2ae', '7b7cf37a-08f7-42b6-bfe8-aab41cb8a3f0', '7bef25c6-1b2e-47d2-a195-cf2e81130cee', '7c01da0f-f5ce-4996-b835-b76bbe3e5001', '7c3e4f50-9483-4172-b851-7ce962485848', '7cc0a1ad-8811-47a5-8cb2-1747b589a415', '7e003fa1-a9d5-44d4-87de-6d7a90d6ce45', '7e685a80-7c18-4dac-a3f1-c76486ea91b1', '7fc67674-0eab-497a-87eb-cf68353465b1', '825b18cf-7151-42d7-ab81-c50f8b3cfe33', '8260883c-32fa-4b0a-871c-0fe8ea500a15', '82920c97-ae34-46d9-9ad0-386a451b00c4', '830a8b27-b71a-4cb6-a943-d74dc9b05288', '83d68b94-40b3-4f37-94d0-decd62c32716', '83e9b9f5-27ea-4420-9923-d8f4eb3f814f', '84871b3c-6806-4aca-8854-c0bceb6c0cc5', '84c87108-4558-4bb2-8651-4748270359a5', '84fc4702-2ac6-446b-8933-7e34a2761629', '85654de9-d2cb-4801-ae8f-d2de59e23aef', '861837a7-ead1-4f83-a523-4dec12282506', '872ab539-297c-4ba8-82c3-e3a924c4bd98', '873c4b22-cd7b-4f33-9245-ac618f1393d9', '878cb27c-97e0-4d76-a06a-f930a8272b70', '893bfb6b-1e15-476a-8ebc-bfb9121fa8de', '8ce03cdb-6824-4cb6-a068-0d5cddc1ee5f', '8ce62a7d-f972-4529-bebc-a2fb8d1c8b17', '8dbd8e9d-5530-43c7-9603-2986b0db8e2c', '8dc25685-856c-4484-a7e8-d07b2a634be8', '8de2f8e3-32c0-463d-8605-347434bfb77b', '8f9b4a1e-547e-408d-b231-ca71fd24ac03', '909fc0f6-a483-4d4e-ac60-43358c621369', '90a29461-2b8b-47b0-8518-ec02786bff6d', '91f5e4ee-afbb-417b-9ea3-9de6dd2a2542', '92bb97eb-3ddd-4de9-bd6e-cb391dc98304', '93fdcf0d-f15f-47b9-ab30-4a81c9cb000b', '94b1cb9a-787d-49c3-9372-7fe6df47fb5a', '97760f7a-2204-4c8c-9a17-ea4f4deae0ec', '97937129-8cde-4c50-b3a0-f76b2440e88c', '98380577-42b0-42ec-9dee-6609adb1a1a4', '9843282f-2060-4ce0-a64e-d512cfc5ae7c', '997fc525-f620-4d3f-9415-43f614061b63') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

69. SELECT product_uuid FROM tp_4over_products WHERE categories = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ee59cdb8-5451-4644-bc5a-aa05e930db87' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '07c2c33e-feaf-401f-9343-56f72e184c43' AND t4pgo.option_uuid = '701a440a-e97e-434b-b11a-3539eb559bc8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 ('00747741-f013-400d-9cfb-0066012e70de') AND FP.categories = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('00747741-f013-400d-9cfb-0066012e70de') 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' GROUP BY tp_4over_product_group_option_master.option_group_uuid sec

74. SELECT * FROM product_settings WHERE product_settings.products_id = 352 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

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 ('00747741-f013-400d-9cfb-0066012e70de', '99a1d43d-f785-429d-ad95-da187206a180', '9aa542cc-d824-4303-b0a1-585b7ed2fba8', '9aac4cfb-9176-48cc-81e2-ea60aa1f6f49', '9af25a6e-a011-4972-85f0-8c288b928054', '9b9f1e8e-d202-4b90-b45a-684e92120fa3', '9c9a2e87-a14e-4d04-9e67-39b3fb6b0ad1', '9f77bc07-0890-4534-a24b-0ee00b4f90d5', 'a1ea09a5-3871-4b52-898a-cadbad388710', 'a3a6fcc1-0e4d-4567-8555-363de573dd7c', 'a50549cc-660c-4f36-a6c9-fcb2cb70b7bf', 'a52407a4-18e0-4e9a-964e-e913c9ed974f', 'a537ea74-a374-49cf-a933-62d1fc8f836f', 'a5c5d519-1830-4412-b6fb-52d10a4ad739', 'a6eb881a-740d-4d7c-9fa4-9c81c369e2af', 'a72bc4d2-8571-496b-9074-661455508294', 'a74b6cab-b910-44bf-bc3b-62b7a6c2216b', 'a7b174d0-0379-4556-b69e-9d3d2a75421e', 'a9521d20-f976-4b37-a9cd-e73d113ae03c', 'a9711d26-0646-4d69-bb93-c9fa8e6f1fb3', 'aa7280bc-01d4-44bb-9b7e-214216c7d2d6', 'abb18933-246c-4204-b05b-e40f665eba81', 'abdfed0e-c271-4334-9e8c-22daaee96354', 'ae6d9bc6-86f6-40cb-8983-caf9be98afa6', 'af0fd641-686e-4a26-99a3-723bf30cd0b4', 'b196484a-6600-4517-89a1-37dd02c22cf9', 'b344e31e-517e-4abd-80bc-5ee15ac05284', 'b38cbf1b-3632-4750-8a55-a2a448111b2a', 'b42f460c-5b69-4e2a-a2d8-e6eef4368b46', 'b464a862-d041-4fa0-8e44-c6c819ca5dc7', 'b4b88413-54dd-452d-8f65-8439f55b0e80', 'b4df2527-bc35-4d28-9c81-c0edf21170cf', 'b86ee0a4-62ae-447c-a838-2cee605c5e88', 'b8b1bd03-988b-40d0-ad59-c40f20b84245', 'b9254169-fcff-4bc5-a129-fc0250301e75', 'b955bec5-8f4b-46ad-a0aa-8d75ca71ecd8', 'b969c161-5ed8-48c7-b686-18f2fb315ec3', 'bb451739-550c-4974-b3dd-708360516939', 'bb6b2057-f010-4647-9cdd-398f9b020229', 'bc9a1405-4c1a-41d6-b15e-328f7039305e', 'bda80530-8cab-48f9-ae83-50109bfc4162', 'bdc430af-b4d4-4ebc-90ac-2ac555c69970', 'be128173-5367-48c6-ac1a-87d181ab316d', 'be9e6b82-632e-45df-8bce-ab76e8c9db9a', 'becb1216-d30a-4572-97fd-333f87113775', 'befd1b74-4f93-42e6-943b-025ed709d58b', 'befd329d-b442-4e8b-8053-720576725a04', 'bf8df2f7-84d9-479d-900c-a7bf23c6312d', 'bfc342b1-8dad-42ca-b8a1-d8f87d5e274d', 'bfd12268-f2d9-49d0-8d4f-e55c7b2bbd80', 'bffd1dd0-bef2-4716-ac02-62ee3e4cade3', 'c20e10a3-62dd-4c8b-93b7-a704f3338c06', 'c2d86161-8797-4b1c-b4ed-b59c4a2cf436', '001f1c26-0b38-4294-9a0b-c36d1ff5f369', 'c40a978b-297b-4ac5-909d-d63437eb62be', '003d0669-289b-4727-9271-96f49eea7dfe', 'c6abb2d6-ff6c-4344-a162-3b4ab26e5e77', 'c84ea125-f2d1-475c-960f-4c0e0f235cd4', '009477f2-1b77-4314-9404-51a3d4d57f65', 'c898301a-60f3-4ffb-b06b-88c8c4cf91b3', '015e282a-ce00-40e9-846d-21fbd5800dcb', 'c89ddf4f-20af-4363-99a9-38595f8b6a10', '01d8d07a-d3b7-4737-8ccb-baa3c2c7cf26', 'c8b4b906-d784-4f41-b4b6-1bb887b89405', '030d94e4-e370-4c6c-bae7-a276f63da3bf', 'c8b60743-2a52-4675-aa64-17dbf34e0150', '03169289-f05e-41f0-91fc-da42e8675da9', 'c8ccb0ea-3c47-4e4c-93a2-68228c1a409f', '0348b66a-1803-411b-b920-78e80bedba03', 'c8de379a-6734-4506-b0de-5987c8d0cb16', '05b11a27-8796-48ce-92db-6d87c6905829', 'ca8b7f03-8162-4c9c-82ae-9d3c5760d86d', '05cbd995-163d-4854-8865-583382a5d0fe', 'ca8e28f7-f6bd-4048-bed0-b223ea8c9d9f', '0600e203-2a0c-4c06-8190-21ffb8875a4c', 'cb3b867c-1ed9-4bce-b33d-5c100da95740', '08a00483-c3bc-44c3-a984-2bc4108f8784', 'cb8b9574-7df4-4ef6-a7fe-679d63ad03b2', '095353fa-caca-4d90-aaaf-6c83ce01eb5a', 'cc6a15a1-4a9a-4f8e-a5d5-9abbb3ad2720', '0bb237c6-34ea-4114-b563-97fb45c6f42c', 'cc8a14d4-52dd-40d2-a546-23c8c6aebc43', '0c45c8c0-d661-4b44-8266-ae80983ae11b', 'cf2864e9-4740-43a6-b92c-7b33b446b939', '0d0cf456-e903-47e3-bd50-2cc1a4eb99c1', 'cf9915b8-27b9-4c34-a7a9-2ade59647497', '0d181391-c4e9-46c5-8867-de2f339c2404', 'd0f6176f-30b3-49ca-8fe8-bb39f052686f', '0f7476d1-32f4-4357-9e87-ee832e46da05', 'd15d194f-b881-49a4-bb00-38f54a597470', '10532f72-c221-437e-824e-8699be162207', 'd18f5541-b22c-47e6-91c9-9d9b50c3bb2c', '113a6cb2-6ad4-49da-b55d-6517545f3139', 'd216212a-5872-4b66-9ca1-0c31856908db', '11d63ff4-3f0b-4582-85a7-35655c21954d', 'd2693d35-c4a1-48db-9f53-9589ee3e1d7c', '12409a97-8a5f-49e2-8450-3fcd670ca0a5', 'd3b4d0fe-f67e-46a5-b6e3-4ced4a4f07ca', '12647e25-92fd-4c4f-8b2f-967579913c27', 'd6f89ec6-0f49-4c54-a456-2a8bdbe6552d', '127b5ae0-a767-4ea4-9426-da13efb07103', 'd714c733-9c09-40a0-b54b-ab30f9444db3', '1426b845-171c-489a-be03-e29d6ba4ef73', 'd86fa561-a100-4510-a88a-96f7a52ff27c', '147cd77a-eaac-4af1-b03e-d95b9e3355e1', 'd8cbdb94-2111-4bcc-961c-3211c175eb03', '15ac1c1f-88e7-481e-9fcf-ef560f74f600', 'd97ed3e1-08af-4924-9adc-845d8001d034', '15ea2bcd-3caa-4b89-bc76-08f9308b2995', 'da982a8d-8986-4b0e-90d5-294ae49d1cbe', '171ae8f6-104b-4919-87c4-ed214a8d1c3d', 'dcbb1683-fed3-4016-9101-258ce9cf96ac', '1725d346-d990-469b-98fb-0455e2ef5b4e', 'df3422b9-255d-4ab3-af73-8834c4847af7', '172ddb07-c5fb-430e-bf14-ae37dce21a12', 'df6065f4-7c48-4a6f-8b9a-f39c3e62f402', '18bf1fb6-35b4-43ed-b463-b283d5e588f4', 'e25af105-fa48-48f9-ab5a-7d9adccf774a', '18d0829f-063d-4e92-a34e-9a997f5d6984', 'e372be0e-3cc3-41e6-bb1e-bc16139613e3', '1b065624-9b4b-4118-9bcc-5600e65d9d8b', 'e4be5349-91dc-4429-946f-1babc75aee1e', '1b723576-8563-42a4-9237-abaf91958f26', 'e4ffbd7f-7e86-4306-a10e-dc232cfe57b6', '1bcb0dc1-cfcc-42cb-b2c0-5ceaa868d775', 'e534fcac-d032-4e8c-9f05-65279a3ce0ab', '1c16ff90-1dc6-46cb-9803-3d6ed58e5688', 'e58843ca-9096-4bdf-b490-9e988635eb1c', '1c3bf896-fada-4260-a619-47a9986d50a5', 'e625603a-2ba2-4b38-83cc-bb2113abdc7f', '1ccd3d62-47c7-4570-bfae-41ce79c7bb56', 'e64286a2-c208-410a-b325-0d78b6c18b1f', '1d5f0729-afcb-4636-827c-8610db02d326', 'e6d132cc-b5b7-426e-ad66-464e331ff747', '1e2afb64-c846-4773-b744-3a1b1617d695', 'e82f938f-f4f2-4001-95fe-e783ab6d2d09', '1f94876d-5da1-4f24-b786-d4a4b6e99c73', 'e88ab716-c4bc-44af-8394-b5488083a1b3', '1fa6de09-f344-4624-8256-8488058600cd', 'e8fa700c-8194-4c86-ab83-d575547bc626', '20c67baa-308d-46a5-9b40-111f0b2186f3', 'e9f3d079-f497-40e0-a555-31834ae78639', '20fbb21d-4d80-4fa4-beae-6a0c27351a33', 'ec3c5435-bb24-42da-a706-17c39692bb5a', '2176f775-3b96-4813-808d-627d03f56801', 'ed8b9bb7-b560-4ef6-b21b-a1a0838e1dd0', '21a5e034-e9a4-4f03-8327-567deddb730a', 'ed9d424c-1c87-4ab4-b139-6fb1bb46dabc', '22a27e33-06d4-48e6-9145-069707b3706f', 'edb643e2-e685-462c-84a5-07038b7b445b', '23ddc204-56dd-4ad6-b60e-350e4f8aeb58', 'edde72c2-bc27-43f1-8468-a522bea66ccc', '23eb593e-53b6-4347-aadd-a360733c71d6', 'eded4b6c-61d4-4e65-b6ee-4e7aaaeec1c6', '25ab35d4-07fd-46dd-8d51-1bac44a84aab', 'eec63979-db6d-406e-bcae-0677dcf71d96', '261b1742-1538-452e-a863-c9a2f8abe5d4', 'efb9aab7-9d10-4b61-ba9f-eb484067239a', '27da38e7-ffd6-48b6-af02-de16ab715893', 'f03df520-78cd-4996-81cb-f995948ce2c7', '2a09e209-5d72-4286-be90-9daef28e1ddf', 'f043f12b-fc37-447d-b07d-22d4ebfb4675', '2a1c62a2-b9b0-47d3-bbf4-caaeffb487b0', 'f044555c-db66-4b0a-987a-383978c1db28', '2ac8cda2-9141-4f11-b5a0-386868607633', 'f1645869-d0c2-49e9-b24a-a05dfc852efa', '2b1e23db-80fb-4e46-9e9c-1634dc754e90', 'f17261e0-445d-482a-b194-0adf68624380', '2b260348-5f0b-4566-a8c2-20c719f89703', 'f1ca53b0-93ec-4676-9bb4-7098e005ca12', '2b8b09a1-0053-4a53-94f6-ed5d1767d624', 'f2ff0e8f-3bd3-4f6e-958c-053ebadd8878', '2c17c007-7b36-42d9-946b-25e1f91d1342', 'f3dcf405-f7d8-4fae-9914-86fd217231fa', '2c32efa2-e01d-4b8c-9811-4073e110a5e7', 'f452d08d-150b-430c-8d79-4b14b36c4950', '2d062abc-474a-43f5-862d-ac0daf11bda0', 'f47fab3c-b06d-46a5-99c7-66545bee8461', '2d97966a-0c01-44ed-ba44-3705037329e4', 'f5349134-334f-4f8b-b2cd-9ba8929eaa6a', '2e99943d-d95b-496d-88e3-69c510eac234', 'f68a1d74-3026-4f6b-9e4f-09107278ddfe', '2f14c257-c399-4d3b-a690-3270f072f743', 'f75b4869-f37e-4274-a0fc-3df9fa5cafd3', '2f3742c1-4775-4348-9496-dc802accfcf3', 'f773aefb-a1db-4058-b0c4-a3e7849ab9d1', '2f950259-30fe-4d7a-94cb-5a4460a30f98', 'f89bfcf1-d692-4236-b8de-fe1ad785a6de', '31680cad-d73f-4192-996b-38a839745d39', 'f93f571d-16d6-446b-adbc-416d04f2b8cc', '328700ff-d209-41b9-a925-0de7e7b32542', 'f9f97065-ae81-49fd-831e-39baaec0cb56', '328ffc1b-d760-471b-8257-50f5ca68a322', 'fa5b9883-8ca1-4bdc-882c-8a7fbd5cb648', '32950cf7-43a2-4e6a-8f01-45f9d971b3a3', 'fb752442-f6d3-4020-875b-86c85da86109', '3323bad6-99d3-4f76-9c0a-79990c9c45ac', 'fbad12c8-cd2d-4e39-8bee-6deaadd3b64e', '339c7ac8-e66a-41d1-9365-82f68db40ec0', 'fc438edb-0716-4b93-a3c3-dbe9568ea2b1', '34d2bc73-4ddb-4548-85b8-cdfb628dd2d0', 'fd2a04e8-3ec8-4eb4-9eca-5695ead02192', '3714227d-13de-4c93-9c39-c028423b0780', 'fde204ab-5ac9-4f63-baa6-01d57deeba9f', '373b4bf0-d658-4a51-9afe-4f9a9074fa99', 'fe06a684-fe76-4179-b88b-2099ebef5af8', '37c204b5-765e-46ff-9f1c-822decb68705', 'ff4404d2-3416-4d5e-9a3b-e4ac74ed6545', '389f8888-c667-40f1-bf89-a0ab6908d5c1', '38a770a8-7d75-49a3-851c-bcb70aedef78', '399a05c7-4c5f-4b5e-87e1-28eb886d6864', '399a2ff2-da15-4b8e-be32-fc4684ef0082', '3aab1732-f42d-44c2-b74c-aef9ed4fceac', '3b0658c9-1b60-4a79-b4b4-019fb74a8c36', '3b06b944-579f-467e-ba9d-d78319a47004', '3b7c1384-31c7-48b7-90b4-9ed3a50b2a5a', '3b9a9cc0-9ebc-4628-b7f3-76a411c5fbca', '3bd6cba8-6d78-4fcf-8d72-cd5cf21ee059', '3cf2a732-9f4d-42a2-bbf4-a1d1c62ed3bc', '3d36a48a-e1b8-4433-bbd2-315f35a45ae6', '3e44148e-9cb6-449b-b7ae-662eae7bc6e9', '3e9cdf75-c858-4511-94f5-8d457864a572', '3ef66c88-5d5a-4474-9c21-9e3092a95e94', '407d260c-445a-446f-ba42-507a214f3af1', '417e15a9-c276-44ab-a337-6edf269e1167', '438d66ff-087b-47ba-a88c-43016a332484', '4395c9ed-a988-4d41-b578-9f6784af1393', '44a9a5f5-3524-48a1-9d99-8dae8a972f90', '46b2c5a2-7951-434a-aab7-ef451ab48691', '487f1384-4708-4ba0-b4da-32104bf79638', '49406784-b26c-435a-9331-f462b709e81a', '4a4d8954-8f3f-4154-9517-b461219f0a45', '4a7cf0ed-fe19-427d-913a-814cf076871a', '4b3163b1-752e-46da-81b4-cfacc7928680', '4b4c8de5-f620-4a97-b519-7c008014a76f', '4b65bc52-acd4-4b79-8bd8-51389a9f6282', '4b7f11ed-0982-42be-931b-6ce4c5dcae1f', '4c60c1b2-1118-446f-b238-5f781a5aab6e', '4d02f495-db0a-46a8-89e1-b206bc8948e6', '4d255bb4-5069-45ee-b609-725704a1d768', '4d7a6cfa-f31d-49ba-b026-80e5d239e05e', '4e93d4b0-a14f-486c-a66a-ce58a9b384ad', '4ec7a2e1-dccf-4560-abd1-958645760b6e', '4f52a504-a6df-4022-9283-8381c33192bc', '4fc26bab-086f-41ae-a562-e88d12265df6', '505a9985-70d3-4c5b-aabe-64d06f350cd4', '529c8434-284d-44fe-8cd8-a14de2ac340a', '52f978b8-c166-4afb-a4b9-d7a518374df6', '5429b2b9-3d96-4653-bc72-4c944015bda7', '55cae66c-0fe0-4f51-b024-ba81d2157524', '567f911e-fec4-4197-b1f2-fcfb39bfa04e', '57615d6d-e0d8-429b-a046-1768f2dbba3e', '579d46ef-f051-48f6-ae53-52fd4fbafc93', '57ae8e01-a329-4759-bb27-3226f679a6a4', '57e383db-5154-4486-9738-0d12a90f462f', '58cc1540-6d0c-4bd3-96ff-e797208719c3', '5aabf26b-1377-420a-bc65-47c570fc7a73', '5d48ddfa-3ab7-47cc-802c-3e27566357af', '5d535153-4b45-41ea-9a72-f52a6d9192b6', '60a6ae8d-3536-45a5-9352-72b5ed4ccc18', '61081533-ffdf-45bf-af0f-8bf66212edd0', '63a27745-24ca-4fc0-b42f-5c5f6169e601', '641350f2-8e59-440c-b213-01b5b94f29df', '652c9e99-5a45-43e4-bf3f-611c68994cda', '6588916b-653b-4be0-9f9e-39a7a27d9ecb', '66112f84-e598-4569-b735-af64c71301bf', '6894b678-86d1-482d-93c9-8d517414ad44', '69c040f9-2048-4b7c-9153-5fa57cdbf5ef', '6ef1cb0d-03ec-4800-980e-694bc903be03', '6fa4ffaa-8b09-4588-8485-457f3046f88e', '6fb7bb13-f660-4051-8ef0-69b6f1c80ed5', '702b9fee-7f2c-4dd8-b4c7-7ae3181b05db', '70fdb753-b32b-43b9-b083-f88bab3f1fe3', '710c9921-0e87-4e12-aed3-2f35805ba20a', '725f6cfb-f295-4f09-bc69-3646ced686d8', '72934627-f00a-4b37-96e9-2449a9647be1', '73d700dc-034a-4970-8354-bcea24ca3d88', '748d45de-340c-4ea9-9b37-737b93aca70f', '74f399bd-8a08-44a2-9b69-e245ffecc7fd', '75794aca-8eca-409f-bc2d-18b14d737179', '75c7e4c2-4e98-457f-bcdf-7206b2e9c1e6', '76419ef4-56e6-4690-800e-962fb995b579', '76c8f416-847e-4790-8f87-8c7f528d871a', '77411520-8497-44f7-8f7f-261653b1fd76', '7768c73b-2450-433e-97e4-e50b67377ebf', '77cef6c7-51c1-4b0e-ac27-0d90d2c8b7a5', '77dbc682-9a53-472a-8c96-c4a8176d0d25', '7877c7e6-b4fd-4ee0-add1-c215bb08bfff', '7958b838-143f-437f-a6b8-f8860063d5f5', '79ab7294-1665-4ebe-ac9b-242a962908a2', '79e0d911-ffb5-4bca-a165-982bc1c5c69d', '7a37ba95-1e82-49af-af05-bd277ac5d666', '7b000d6e-e375-425c-9089-f7150c64d4c9', '7b1694cb-9516-46d1-9c1b-f5bc1552b2ae', '7b7cf37a-08f7-42b6-bfe8-aab41cb8a3f0', '7bef25c6-1b2e-47d2-a195-cf2e81130cee', '7c01da0f-f5ce-4996-b835-b76bbe3e5001', '7c3e4f50-9483-4172-b851-7ce962485848', '7cc0a1ad-8811-47a5-8cb2-1747b589a415', '7e003fa1-a9d5-44d4-87de-6d7a90d6ce45', '7e685a80-7c18-4dac-a3f1-c76486ea91b1', '7fc67674-0eab-497a-87eb-cf68353465b1', '825b18cf-7151-42d7-ab81-c50f8b3cfe33', '8260883c-32fa-4b0a-871c-0fe8ea500a15', '82920c97-ae34-46d9-9ad0-386a451b00c4', '830a8b27-b71a-4cb6-a943-d74dc9b05288', '83d68b94-40b3-4f37-94d0-decd62c32716', '83e9b9f5-27ea-4420-9923-d8f4eb3f814f', '84871b3c-6806-4aca-8854-c0bceb6c0cc5', '84c87108-4558-4bb2-8651-4748270359a5', '84fc4702-2ac6-446b-8933-7e34a2761629', '85654de9-d2cb-4801-ae8f-d2de59e23aef', '861837a7-ead1-4f83-a523-4dec12282506', '872ab539-297c-4ba8-82c3-e3a924c4bd98', '873c4b22-cd7b-4f33-9245-ac618f1393d9', '878cb27c-97e0-4d76-a06a-f930a8272b70', '893bfb6b-1e15-476a-8ebc-bfb9121fa8de', '8ce03cdb-6824-4cb6-a068-0d5cddc1ee5f', '8ce62a7d-f972-4529-bebc-a2fb8d1c8b17', '8dbd8e9d-5530-43c7-9603-2986b0db8e2c', '8dc25685-856c-4484-a7e8-d07b2a634be8', '8de2f8e3-32c0-463d-8605-347434bfb77b', '8f9b4a1e-547e-408d-b231-ca71fd24ac03', '909fc0f6-a483-4d4e-ac60-43358c621369', '90a29461-2b8b-47b0-8518-ec02786bff6d', '91f5e4ee-afbb-417b-9ea3-9de6dd2a2542', '92bb97eb-3ddd-4de9-bd6e-cb391dc98304', '93fdcf0d-f15f-47b9-ab30-4a81c9cb000b', '94b1cb9a-787d-49c3-9372-7fe6df47fb5a', '97760f7a-2204-4c8c-9a17-ea4f4deae0ec', '97937129-8cde-4c50-b3a0-f76b2440e88c', '98380577-42b0-42ec-9dee-6609adb1a1a4', '9843282f-2060-4ce0-a64e-d512cfc5ae7c', '997fc525-f620-4d3f-9415-43f614061b63') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

76 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 ('00747741-f013-400d-9cfb-0066012e70de', '99a1d43d-f785-429d-ad95-da187206a180', '9aa542cc-d824-4303-b0a1-585b7ed2fba8', '9aac4cfb-9176-48cc-81e2-ea60aa1f6f49', '9af25a6e-a011-4972-85f0-8c288b928054', '9b9f1e8e-d202-4b90-b45a-684e92120fa3', '9c9a2e87-a14e-4d04-9e67-39b3fb6b0ad1', '9f77bc07-0890-4534-a24b-0ee00b4f90d5', 'a1ea09a5-3871-4b52-898a-cadbad388710', 'a3a6fcc1-0e4d-4567-8555-363de573dd7c', 'a50549cc-660c-4f36-a6c9-fcb2cb70b7bf', 'a52407a4-18e0-4e9a-964e-e913c9ed974f', 'a537ea74-a374-49cf-a933-62d1fc8f836f', 'a5c5d519-1830-4412-b6fb-52d10a4ad739', 'a6eb881a-740d-4d7c-9fa4-9c81c369e2af', 'a72bc4d2-8571-496b-9074-661455508294', 'a74b6cab-b910-44bf-bc3b-62b7a6c2216b', 'a7b174d0-0379-4556-b69e-9d3d2a75421e', 'a9521d20-f976-4b37-a9cd-e73d113ae03c', 'a9711d26-0646-4d69-bb93-c9fa8e6f1fb3', 'aa7280bc-01d4-44bb-9b7e-214216c7d2d6', 'abb18933-246c-4204-b05b-e40f665eba81', 'abdfed0e-c271-4334-9e8c-22daaee96354', 'ae6d9bc6-86f6-40cb-8983-caf9be98afa6', 'af0fd641-686e-4a26-99a3-723bf30cd0b4', 'b196484a-6600-4517-89a1-37dd02c22cf9', 'b344e31e-517e-4abd-80bc-5ee15ac05284', 'b38cbf1b-3632-4750-8a55-a2a448111b2a', 'b42f460c-5b69-4e2a-a2d8-e6eef4368b46', 'b464a862-d041-4fa0-8e44-c6c819ca5dc7', 'b4b88413-54dd-452d-8f65-8439f55b0e80', 'b4df2527-bc35-4d28-9c81-c0edf21170cf', 'b86ee0a4-62ae-447c-a838-2cee605c5e88', 'b8b1bd03-988b-40d0-ad59-c40f20b84245', 'b9254169-fcff-4bc5-a129-fc0250301e75', 'b955bec5-8f4b-46ad-a0aa-8d75ca71ecd8', 'b969c161-5ed8-48c7-b686-18f2fb315ec3', 'bb451739-550c-4974-b3dd-708360516939', 'bb6b2057-f010-4647-9cdd-398f9b020229', 'bc9a1405-4c1a-41d6-b15e-328f7039305e', 'bda80530-8cab-48f9-ae83-50109bfc4162', 'bdc430af-b4d4-4ebc-90ac-2ac555c69970', 'be128173-5367-48c6-ac1a-87d181ab316d', 'be9e6b82-632e-45df-8bce-ab76e8c9db9a', 'becb1216-d30a-4572-97fd-333f87113775', 'befd1b74-4f93-42e6-943b-025ed709d58b', 'befd329d-b442-4e8b-8053-720576725a04', 'bf8df2f7-84d9-479d-900c-a7bf23c6312d', 'bfc342b1-8dad-42ca-b8a1-d8f87d5e274d', 'bfd12268-f2d9-49d0-8d4f-e55c7b2bbd80', 'bffd1dd0-bef2-4716-ac02-62ee3e4cade3', 'c20e10a3-62dd-4c8b-93b7-a704f3338c06', 'c2d86161-8797-4b1c-b4ed-b59c4a2cf436', '001f1c26-0b38-4294-9a0b-c36d1ff5f369', 'c40a978b-297b-4ac5-909d-d63437eb62be', '003d0669-289b-4727-9271-96f49eea7dfe', 'c6abb2d6-ff6c-4344-a162-3b4ab26e5e77', 'c84ea125-f2d1-475c-960f-4c0e0f235cd4', '009477f2-1b77-4314-9404-51a3d4d57f65', 'c898301a-60f3-4ffb-b06b-88c8c4cf91b3', '015e282a-ce00-40e9-846d-21fbd5800dcb', 'c89ddf4f-20af-4363-99a9-38595f8b6a10', '01d8d07a-d3b7-4737-8ccb-baa3c2c7cf26', 'c8b4b906-d784-4f41-b4b6-1bb887b89405', '030d94e4-e370-4c6c-bae7-a276f63da3bf', 'c8b60743-2a52-4675-aa64-17dbf34e0150', '03169289-f05e-41f0-91fc-da42e8675da9', 'c8ccb0ea-3c47-4e4c-93a2-68228c1a409f', '0348b66a-1803-411b-b920-78e80bedba03', 'c8de379a-6734-4506-b0de-5987c8d0cb16', '05b11a27-8796-48ce-92db-6d87c6905829', 'ca8b7f03-8162-4c9c-82ae-9d3c5760d86d', '05cbd995-163d-4854-8865-583382a5d0fe', 'ca8e28f7-f6bd-4048-bed0-b223ea8c9d9f', '0600e203-2a0c-4c06-8190-21ffb8875a4c', 'cb3b867c-1ed9-4bce-b33d-5c100da95740', '08a00483-c3bc-44c3-a984-2bc4108f8784', 'cb8b9574-7df4-4ef6-a7fe-679d63ad03b2', '095353fa-caca-4d90-aaaf-6c83ce01eb5a', 'cc6a15a1-4a9a-4f8e-a5d5-9abbb3ad2720', '0bb237c6-34ea-4114-b563-97fb45c6f42c', 'cc8a14d4-52dd-40d2-a546-23c8c6aebc43', '0c45c8c0-d661-4b44-8266-ae80983ae11b', 'cf2864e9-4740-43a6-b92c-7b33b446b939', '0d0cf456-e903-47e3-bd50-2cc1a4eb99c1', 'cf9915b8-27b9-4c34-a7a9-2ade59647497', '0d181391-c4e9-46c5-8867-de2f339c2404', 'd0f6176f-30b3-49ca-8fe8-bb39f052686f', '0f7476d1-32f4-4357-9e87-ee832e46da05', 'd15d194f-b881-49a4-bb00-38f54a597470', '10532f72-c221-437e-824e-8699be162207', 'd18f5541-b22c-47e6-91c9-9d9b50c3bb2c', '113a6cb2-6ad4-49da-b55d-6517545f3139', 'd216212a-5872-4b66-9ca1-0c31856908db', '11d63ff4-3f0b-4582-85a7-35655c21954d', 'd2693d35-c4a1-48db-9f53-9589ee3e1d7c', '12409a97-8a5f-49e2-8450-3fcd670ca0a5', 'd3b4d0fe-f67e-46a5-b6e3-4ced4a4f07ca', '12647e25-92fd-4c4f-8b2f-967579913c27', 'd6f89ec6-0f49-4c54-a456-2a8bdbe6552d', '127b5ae0-a767-4ea4-9426-da13efb07103', 'd714c733-9c09-40a0-b54b-ab30f9444db3', '1426b845-171c-489a-be03-e29d6ba4ef73', 'd86fa561-a100-4510-a88a-96f7a52ff27c', '147cd77a-eaac-4af1-b03e-d95b9e3355e1', 'd8cbdb94-2111-4bcc-961c-3211c175eb03', '15ac1c1f-88e7-481e-9fcf-ef560f74f600', 'd97ed3e1-08af-4924-9adc-845d8001d034', '15ea2bcd-3caa-4b89-bc76-08f9308b2995', 'da982a8d-8986-4b0e-90d5-294ae49d1cbe', '171ae8f6-104b-4919-87c4-ed214a8d1c3d', 'dcbb1683-fed3-4016-9101-258ce9cf96ac', '1725d346-d990-469b-98fb-0455e2ef5b4e', 'df3422b9-255d-4ab3-af73-8834c4847af7', '172ddb07-c5fb-430e-bf14-ae37dce21a12', 'df6065f4-7c48-4a6f-8b9a-f39c3e62f402', '18bf1fb6-35b4-43ed-b463-b283d5e588f4', 'e25af105-fa48-48f9-ab5a-7d9adccf774a', '18d0829f-063d-4e92-a34e-9a997f5d6984', 'e372be0e-3cc3-41e6-bb1e-bc16139613e3', '1b065624-9b4b-4118-9bcc-5600e65d9d8b', 'e4be5349-91dc-4429-946f-1babc75aee1e', '1b723576-8563-42a4-9237-abaf91958f26', 'e4ffbd7f-7e86-4306-a10e-dc232cfe57b6', '1bcb0dc1-cfcc-42cb-b2c0-5ceaa868d775', 'e534fcac-d032-4e8c-9f05-65279a3ce0ab', '1c16ff90-1dc6-46cb-9803-3d6ed58e5688', 'e58843ca-9096-4bdf-b490-9e988635eb1c', '1c3bf896-fada-4260-a619-47a9986d50a5', 'e625603a-2ba2-4b38-83cc-bb2113abdc7f', '1ccd3d62-47c7-4570-bfae-41ce79c7bb56', 'e64286a2-c208-410a-b325-0d78b6c18b1f', '1d5f0729-afcb-4636-827c-8610db02d326', 'e6d132cc-b5b7-426e-ad66-464e331ff747', '1e2afb64-c846-4773-b744-3a1b1617d695', 'e82f938f-f4f2-4001-95fe-e783ab6d2d09', '1f94876d-5da1-4f24-b786-d4a4b6e99c73', 'e88ab716-c4bc-44af-8394-b5488083a1b3', '1fa6de09-f344-4624-8256-8488058600cd', 'e8fa700c-8194-4c86-ab83-d575547bc626', '20c67baa-308d-46a5-9b40-111f0b2186f3', 'e9f3d079-f497-40e0-a555-31834ae78639', '20fbb21d-4d80-4fa4-beae-6a0c27351a33', 'ec3c5435-bb24-42da-a706-17c39692bb5a', '2176f775-3b96-4813-808d-627d03f56801', 'ed8b9bb7-b560-4ef6-b21b-a1a0838e1dd0', '21a5e034-e9a4-4f03-8327-567deddb730a', 'ed9d424c-1c87-4ab4-b139-6fb1bb46dabc', '22a27e33-06d4-48e6-9145-069707b3706f', 'edb643e2-e685-462c-84a5-07038b7b445b', '23ddc204-56dd-4ad6-b60e-350e4f8aeb58', 'edde72c2-bc27-43f1-8468-a522bea66ccc', '23eb593e-53b6-4347-aadd-a360733c71d6', 'eded4b6c-61d4-4e65-b6ee-4e7aaaeec1c6', '25ab35d4-07fd-46dd-8d51-1bac44a84aab', 'eec63979-db6d-406e-bcae-0677dcf71d96', '261b1742-1538-452e-a863-c9a2f8abe5d4', 'efb9aab7-9d10-4b61-ba9f-eb484067239a', '27da38e7-ffd6-48b6-af02-de16ab715893', 'f03df520-78cd-4996-81cb-f995948ce2c7', '2a09e209-5d72-4286-be90-9daef28e1ddf', 'f043f12b-fc37-447d-b07d-22d4ebfb4675', '2a1c62a2-b9b0-47d3-bbf4-caaeffb487b0', 'f044555c-db66-4b0a-987a-383978c1db28', '2ac8cda2-9141-4f11-b5a0-386868607633', 'f1645869-d0c2-49e9-b24a-a05dfc852efa', '2b1e23db-80fb-4e46-9e9c-1634dc754e90', 'f17261e0-445d-482a-b194-0adf68624380', '2b260348-5f0b-4566-a8c2-20c719f89703', 'f1ca53b0-93ec-4676-9bb4-7098e005ca12', '2b8b09a1-0053-4a53-94f6-ed5d1767d624', 'f2ff0e8f-3bd3-4f6e-958c-053ebadd8878', '2c17c007-7b36-42d9-946b-25e1f91d1342', 'f3dcf405-f7d8-4fae-9914-86fd217231fa', '2c32efa2-e01d-4b8c-9811-4073e110a5e7', 'f452d08d-150b-430c-8d79-4b14b36c4950', '2d062abc-474a-43f5-862d-ac0daf11bda0', 'f47fab3c-b06d-46a5-99c7-66545bee8461', '2d97966a-0c01-44ed-ba44-3705037329e4', 'f5349134-334f-4f8b-b2cd-9ba8929eaa6a', '2e99943d-d95b-496d-88e3-69c510eac234', 'f68a1d74-3026-4f6b-9e4f-09107278ddfe', '2f14c257-c399-4d3b-a690-3270f072f743', 'f75b4869-f37e-4274-a0fc-3df9fa5cafd3', '2f3742c1-4775-4348-9496-dc802accfcf3', 'f773aefb-a1db-4058-b0c4-a3e7849ab9d1', '2f950259-30fe-4d7a-94cb-5a4460a30f98', 'f89bfcf1-d692-4236-b8de-fe1ad785a6de', '31680cad-d73f-4192-996b-38a839745d39', 'f93f571d-16d6-446b-adbc-416d04f2b8cc', '328700ff-d209-41b9-a925-0de7e7b32542', 'f9f97065-ae81-49fd-831e-39baaec0cb56', '328ffc1b-d760-471b-8257-50f5ca68a322', 'fa5b9883-8ca1-4bdc-882c-8a7fbd5cb648', '32950cf7-43a2-4e6a-8f01-45f9d971b3a3', 'fb752442-f6d3-4020-875b-86c85da86109', '3323bad6-99d3-4f76-9c0a-79990c9c45ac', 'fbad12c8-cd2d-4e39-8bee-6deaadd3b64e', '339c7ac8-e66a-41d1-9365-82f68db40ec0', 'fc438edb-0716-4b93-a3c3-dbe9568ea2b1', '34d2bc73-4ddb-4548-85b8-cdfb628dd2d0', 'fd2a04e8-3ec8-4eb4-9eca-5695ead02192', '3714227d-13de-4c93-9c39-c028423b0780', 'fde204ab-5ac9-4f63-baa6-01d57deeba9f', '373b4bf0-d658-4a51-9afe-4f9a9074fa99', 'fe06a684-fe76-4179-b88b-2099ebef5af8', '37c204b5-765e-46ff-9f1c-822decb68705', 'ff4404d2-3416-4d5e-9a3b-e4ac74ed6545', '389f8888-c667-40f1-bf89-a0ab6908d5c1', '38a770a8-7d75-49a3-851c-bcb70aedef78', '399a05c7-4c5f-4b5e-87e1-28eb886d6864', '399a2ff2-da15-4b8e-be32-fc4684ef0082', '3aab1732-f42d-44c2-b74c-aef9ed4fceac', '3b0658c9-1b60-4a79-b4b4-019fb74a8c36', '3b06b944-579f-467e-ba9d-d78319a47004', '3b7c1384-31c7-48b7-90b4-9ed3a50b2a5a', '3b9a9cc0-9ebc-4628-b7f3-76a411c5fbca', '3bd6cba8-6d78-4fcf-8d72-cd5cf21ee059', '3cf2a732-9f4d-42a2-bbf4-a1d1c62ed3bc', '3d36a48a-e1b8-4433-bbd2-315f35a45ae6', '3e44148e-9cb6-449b-b7ae-662eae7bc6e9', '3e9cdf75-c858-4511-94f5-8d457864a572', '3ef66c88-5d5a-4474-9c21-9e3092a95e94', '407d260c-445a-446f-ba42-507a214f3af1', '417e15a9-c276-44ab-a337-6edf269e1167', '438d66ff-087b-47ba-a88c-43016a332484', '4395c9ed-a988-4d41-b578-9f6784af1393', '44a9a5f5-3524-48a1-9d99-8dae8a972f90', '46b2c5a2-7951-434a-aab7-ef451ab48691', '487f1384-4708-4ba0-b4da-32104bf79638', '49406784-b26c-435a-9331-f462b709e81a', '4a4d8954-8f3f-4154-9517-b461219f0a45', '4a7cf0ed-fe19-427d-913a-814cf076871a', '4b3163b1-752e-46da-81b4-cfacc7928680', '4b4c8de5-f620-4a97-b519-7c008014a76f', '4b65bc52-acd4-4b79-8bd8-51389a9f6282', '4b7f11ed-0982-42be-931b-6ce4c5dcae1f', '4c60c1b2-1118-446f-b238-5f781a5aab6e', '4d02f495-db0a-46a8-89e1-b206bc8948e6', '4d255bb4-5069-45ee-b609-725704a1d768', '4d7a6cfa-f31d-49ba-b026-80e5d239e05e', '4e93d4b0-a14f-486c-a66a-ce58a9b384ad', '4ec7a2e1-dccf-4560-abd1-958645760b6e', '4f52a504-a6df-4022-9283-8381c33192bc', '4fc26bab-086f-41ae-a562-e88d12265df6', '505a9985-70d3-4c5b-aabe-64d06f350cd4', '529c8434-284d-44fe-8cd8-a14de2ac340a', '52f978b8-c166-4afb-a4b9-d7a518374df6', '5429b2b9-3d96-4653-bc72-4c944015bda7', '55cae66c-0fe0-4f51-b024-ba81d2157524', '567f911e-fec4-4197-b1f2-fcfb39bfa04e', '57615d6d-e0d8-429b-a046-1768f2dbba3e', '579d46ef-f051-48f6-ae53-52fd4fbafc93', '57ae8e01-a329-4759-bb27-3226f679a6a4', '57e383db-5154-4486-9738-0d12a90f462f', '58cc1540-6d0c-4bd3-96ff-e797208719c3', '5aabf26b-1377-420a-bc65-47c570fc7a73', '5d48ddfa-3ab7-47cc-802c-3e27566357af', '5d535153-4b45-41ea-9a72-f52a6d9192b6', '60a6ae8d-3536-45a5-9352-72b5ed4ccc18', '61081533-ffdf-45bf-af0f-8bf66212edd0', '63a27745-24ca-4fc0-b42f-5c5f6169e601', '641350f2-8e59-440c-b213-01b5b94f29df', '652c9e99-5a45-43e4-bf3f-611c68994cda', '6588916b-653b-4be0-9f9e-39a7a27d9ecb', '66112f84-e598-4569-b735-af64c71301bf', '6894b678-86d1-482d-93c9-8d517414ad44', '69c040f9-2048-4b7c-9153-5fa57cdbf5ef', '6ef1cb0d-03ec-4800-980e-694bc903be03', '6fa4ffaa-8b09-4588-8485-457f3046f88e', '6fb7bb13-f660-4051-8ef0-69b6f1c80ed5', '702b9fee-7f2c-4dd8-b4c7-7ae3181b05db', '70fdb753-b32b-43b9-b083-f88bab3f1fe3', '710c9921-0e87-4e12-aed3-2f35805ba20a', '725f6cfb-f295-4f09-bc69-3646ced686d8', '72934627-f00a-4b37-96e9-2449a9647be1', '73d700dc-034a-4970-8354-bcea24ca3d88', '748d45de-340c-4ea9-9b37-737b93aca70f', '74f399bd-8a08-44a2-9b69-e245ffecc7fd', '75794aca-8eca-409f-bc2d-18b14d737179', '75c7e4c2-4e98-457f-bcdf-7206b2e9c1e6', '76419ef4-56e6-4690-800e-962fb995b579', '76c8f416-847e-4790-8f87-8c7f528d871a', '77411520-8497-44f7-8f7f-261653b1fd76', '7768c73b-2450-433e-97e4-e50b67377ebf', '77cef6c7-51c1-4b0e-ac27-0d90d2c8b7a5', '77dbc682-9a53-472a-8c96-c4a8176d0d25', '7877c7e6-b4fd-4ee0-add1-c215bb08bfff', '7958b838-143f-437f-a6b8-f8860063d5f5', '79ab7294-1665-4ebe-ac9b-242a962908a2', '79e0d911-ffb5-4bca-a165-982bc1c5c69d', '7a37ba95-1e82-49af-af05-bd277ac5d666', '7b000d6e-e375-425c-9089-f7150c64d4c9', '7b1694cb-9516-46d1-9c1b-f5bc1552b2ae', '7b7cf37a-08f7-42b6-bfe8-aab41cb8a3f0', '7bef25c6-1b2e-47d2-a195-cf2e81130cee', '7c01da0f-f5ce-4996-b835-b76bbe3e5001', '7c3e4f50-9483-4172-b851-7ce962485848', '7cc0a1ad-8811-47a5-8cb2-1747b589a415', '7e003fa1-a9d5-44d4-87de-6d7a90d6ce45', '7e685a80-7c18-4dac-a3f1-c76486ea91b1', '7fc67674-0eab-497a-87eb-cf68353465b1', '825b18cf-7151-42d7-ab81-c50f8b3cfe33', '8260883c-32fa-4b0a-871c-0fe8ea500a15', '82920c97-ae34-46d9-9ad0-386a451b00c4', '830a8b27-b71a-4cb6-a943-d74dc9b05288', '83d68b94-40b3-4f37-94d0-decd62c32716', '83e9b9f5-27ea-4420-9923-d8f4eb3f814f', '84871b3c-6806-4aca-8854-c0bceb6c0cc5', '84c87108-4558-4bb2-8651-4748270359a5', '84fc4702-2ac6-446b-8933-7e34a2761629', '85654de9-d2cb-4801-ae8f-d2de59e23aef', '861837a7-ead1-4f83-a523-4dec12282506', '872ab539-297c-4ba8-82c3-e3a924c4bd98', '873c4b22-cd7b-4f33-9245-ac618f1393d9', '878cb27c-97e0-4d76-a06a-f930a8272b70', '893bfb6b-1e15-476a-8ebc-bfb9121fa8de', '8ce03cdb-6824-4cb6-a068-0d5cddc1ee5f', '8ce62a7d-f972-4529-bebc-a2fb8d1c8b17', '8dbd8e9d-5530-43c7-9603-2986b0db8e2c', '8dc25685-856c-4484-a7e8-d07b2a634be8', '8de2f8e3-32c0-463d-8605-347434bfb77b', '8f9b4a1e-547e-408d-b231-ca71fd24ac03', '909fc0f6-a483-4d4e-ac60-43358c621369', '90a29461-2b8b-47b0-8518-ec02786bff6d', '91f5e4ee-afbb-417b-9ea3-9de6dd2a2542', '92bb97eb-3ddd-4de9-bd6e-cb391dc98304', '93fdcf0d-f15f-47b9-ab30-4a81c9cb000b', '94b1cb9a-787d-49c3-9372-7fe6df47fb5a', '97760f7a-2204-4c8c-9a17-ea4f4deae0ec', '97937129-8cde-4c50-b3a0-f76b2440e88c', '98380577-42b0-42ec-9dee-6609adb1a1a4', '9843282f-2060-4ce0-a64e-d512cfc5ae7c', '997fc525-f620-4d3f-9415-43f614061b63') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

77. 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) as P2 ON (P1.pid_1 = P2.pid_2) sec

78. 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 ('00747741-f013-400d-9cfb-0066012e70de', '9aa542cc-d824-4303-b0a1-585b7ed2fba8', 'a1ea09a5-3871-4b52-898a-cadbad388710', 'a9711d26-0646-4d69-bb93-c9fa8e6f1fb3', 'b86ee0a4-62ae-447c-a838-2cee605c5e88', 'b955bec5-8f4b-46ad-a0aa-8d75ca71ecd8', 'c20e10a3-62dd-4c8b-93b7-a704f3338c06', 'c84ea125-f2d1-475c-960f-4c0e0f235cd4', 'c8b4b906-d784-4f41-b4b6-1bb887b89405', '095353fa-caca-4d90-aaaf-6c83ce01eb5a', 'cc8a14d4-52dd-40d2-a546-23c8c6aebc43', 'd15d194f-b881-49a4-bb00-38f54a597470', 'e25af105-fa48-48f9-ab5a-7d9adccf774a', 'e372be0e-3cc3-41e6-bb1e-bc16139613e3', '1c16ff90-1dc6-46cb-9803-3d6ed58e5688', '27da38e7-ffd6-48b6-af02-de16ab715893', 'f043f12b-fc37-447d-b07d-22d4ebfb4675', '3ef66c88-5d5a-4474-9c21-9e3092a95e94', '4fc26bab-086f-41ae-a562-e88d12265df6', '60a6ae8d-3536-45a5-9352-72b5ed4ccc18', '73d700dc-034a-4970-8354-bcea24ca3d88', '7e685a80-7c18-4dac-a3f1-c76486ea91b1', '909fc0f6-a483-4d4e-ac60-43358c621369') AND FP.categories = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

79. 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 ('00747741-f013-400d-9cfb-0066012e70de', '095353fa-caca-4d90-aaaf-6c83ce01eb5a', '1c16ff90-1dc6-46cb-9803-3d6ed58e5688', '27da38e7-ffd6-48b6-af02-de16ab715893', '3ef66c88-5d5a-4474-9c21-9e3092a95e94', '4fc26bab-086f-41ae-a562-e88d12265df6', '60a6ae8d-3536-45a5-9352-72b5ed4ccc18', '73d700dc-034a-4970-8354-bcea24ca3d88', '7e685a80-7c18-4dac-a3f1-c76486ea91b1', '909fc0f6-a483-4d4e-ac60-43358c621369', '9aa542cc-d824-4303-b0a1-585b7ed2fba8', 'a1ea09a5-3871-4b52-898a-cadbad388710', 'a9711d26-0646-4d69-bb93-c9fa8e6f1fb3', 'b86ee0a4-62ae-447c-a838-2cee605c5e88', 'b955bec5-8f4b-46ad-a0aa-8d75ca71ecd8', 'c20e10a3-62dd-4c8b-93b7-a704f3338c06', 'c84ea125-f2d1-475c-960f-4c0e0f235cd4', 'c8b4b906-d784-4f41-b4b6-1bb887b89405', 'cc8a14d4-52dd-40d2-a546-23c8c6aebc43', 'd15d194f-b881-49a4-bb00-38f54a597470', 'e25af105-fa48-48f9-ab5a-7d9adccf774a', 'e372be0e-3cc3-41e6-bb1e-bc16139613e3', 'f043f12b-fc37-447d-b07d-22d4ebfb4675') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

80. 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) as P3 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P2.pid_2 = P3.pid_3) 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

82. SELECT size_id,tp4over_size_title FROM tp_4over_ops_size_mapping WHERE ops_product_id =352 sec

83. 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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

84 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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

86 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ee59cdb8-5451-4644-bc5a-aa05e930db87' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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

88 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ee59cdb8-5451-4644-bc5a-aa05e930db87' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '07c2c33e-feaf-401f-9343-56f72e184c43' AND t4pgo.option_uuid = '701a440a-e97e-434b-b11a-3539eb559bc8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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

90 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ee59cdb8-5451-4644-bc5a-aa05e930db87' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '07c2c33e-feaf-401f-9343-56f72e184c43' AND t4pgo.option_uuid = '701a440a-e97e-434b-b11a-3539eb559bc8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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

92 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

93. SELECT colorspec_uuid FROM tp_product_price WHERE product_uuid IN ('00747741-f013-400d-9cfb-0066012e70de') 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ee59cdb8-5451-4644-bc5a-aa05e930db87' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '07c2c33e-feaf-401f-9343-56f72e184c43' AND t4pgo.option_uuid = '701a440a-e97e-434b-b11a-3539eb559bc8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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

95 72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('00747741-f013-400d-9cfb-0066012e70de') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

96 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ee59cdb8-5451-4644-bc5a-aa05e930db87' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '07c2c33e-feaf-401f-9343-56f72e184c43' AND t4pgo.option_uuid = '701a440a-e97e-434b-b11a-3539eb559bc8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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

98 72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('00747741-f013-400d-9cfb-0066012e70de') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

99. SELECT DISTINCT(option_uuid) FROM tp_4over_product_turnaround_time_price WHERE product_uuid IN ('00747741-f013-400d-9cfb-0066012e70de') AND runsize_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' sec

100. 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 ('00747741-f013-400d-9cfb-0066012e70de') AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' AND tp_4over_product_group_option_master.option_uuid IN ('ad290b77-c9d5-476c-b847-9ad4d25ae14e') sec

101. 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 = '7c108d3c-b2fd-438b-b5a2-98d8b720f577' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ac403654-9705-453a-b978-031095135200' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = 'ee59cdb8-5451-4644-bc5a-aa05e930db87' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '07c2c33e-feaf-401f-9343-56f72e184c43' AND t4pgo.option_uuid = '701a440a-e97e-434b-b11a-3539eb559bc8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = 'c088d9de-bfe6-401d-94f7-5648672a98f8' AND t4pgo.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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 = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' ) 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

102 72. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('00747741-f013-400d-9cfb-0066012e70de') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

103. SELECT product_uuid,runsize_uuid,colorspec_uuid,product_baseprice,can_group_ship FROM tp_product_price WHERE product_uuid = '00747741-f013-400d-9cfb-0066012e70de' sec

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

105. 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 = '00747741-f013-400d-9cfb-0066012e70de' 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', '07c2c33e-feaf-401f-9343-56f72e184c43', '26ca0df3-0682-4f37-8979-409868e2df2d', '38d33954-5a42-4112-a905-215eb827e62c', '87e09691-ef33-4cf4-8f17-48af06ce84f4', 'f80e8179-b264-42ce-9f80-bb258a09a1fe') AND option_uuid IN ('7c108d3c-b2fd-438b-b5a2-98d8b720f577', 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f', 'ac403654-9705-453a-b978-031095135200', 'eff0a08f-a01e-488b-9471-cdf96a36646c', '991b850a-6643-48d3-afa6-bcda4cf58c85', 'ee59cdb8-5451-4644-bc5a-aa05e930db87', '701a440a-e97e-434b-b11a-3539eb559bc8', '3e7618de-abca-4bda-9f97-8b9129e913d8', '32d3c223-f82c-492b-b915-ba065a00862f', 'c088d9de-bfe6-401d-94f7-5648672a98f8', 'ad290b77-c9d5-476c-b847-9ad4d25ae14e') AND startqty <= 1 AND endqty >= 1 sec

106. SELECT * FROM tp_4over_product_turnaround_time_price WHERE product_uuid ='00747741-f013-400d-9cfb-0066012e70de' 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

107. SELECT markup, markup_type FROM tp_4over_category WHERE category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

108. SELECT markup, markup_type FROM tp_move_ops_product_markup WHERE ops_product_id = 352 sec

109. 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 = 'eff0a08f-a01e-488b-9471-cdf96a36646c' AND ops_product_id =352 LIMIT 1 OFFSET 0 sec

110. 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 = '00747741-f013-400d-9cfb-0066012e70de' AND tp_4over_product_group_option_master.category_uuid = '4bf65303-b799-4f45-b3d9-6cc105eb78a4' sec

111. 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 00:46:20' 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

112 74. SELECT * FROM product_settings WHERE product_settings.products_id = 352 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) 4e6cac3cafc2c56af255013fd0f9661e

113 74. SELECT * FROM product_settings WHERE product_settings.products_id = 352 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) 4e6cac3cafc2c56af255013fd0f9661e

114. 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 = 8454 AND products_production_days.attribute_id = 0 AND products_sizes.products_id= 352 AND products_sizes.site_language_id= 1 sec

115. SELECT setting_constant_name, setting_value FROM product_settings WHERE product_settings.products_id = 352 AND product_settings.setting_constant_name = 'DEFAULT_PRODUCTION_DAYS' sec

116. SELECT * FROM product_settings WHERE product_settings.products_id = 352 AND product_settings.setting_constant_name = 'PRODUCT_CUT_OFF_TIME' sec

117 105. 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 = '00747741-f013-400d-9cfb-0066012e70de' 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', '07c2c33e-feaf-401f-9343-56f72e184c43', '26ca0df3-0682-4f37-8979-409868e2df2d', '38d33954-5a42-4112-a905-215eb827e62c', '87e09691-ef33-4cf4-8f17-48af06ce84f4', 'f80e8179-b264-42ce-9f80-bb258a09a1fe') AND option_uuid IN ('7c108d3c-b2fd-438b-b5a2-98d8b720f577', 'fb08b985-401e-4f7a-b32a-35f7a8f7a84f', 'ac403654-9705-453a-b978-031095135200', 'eff0a08f-a01e-488b-9471-cdf96a36646c', '991b850a-6643-48d3-afa6-bcda4cf58c85', 'ee59cdb8-5451-4644-bc5a-aa05e930db87', '701a440a-e97e-434b-b11a-3539eb559bc8', '3e7618de-abca-4bda-9f97-8b9129e913d8', '32d3c223-f82c-492b-b915-ba065a00862f', 'c088d9de-bfe6-401d-94f7-5648672a98f8', 'ad290b77-c9d5-476c-b847-9ad4d25ae14e') AND startqty <= 1 AND endqty >= 1 sec

(Cached) c88d4cae078e2ce9e854460d8e4e1949

118 108. SELECT markup, markup_type FROM tp_move_ops_product_markup WHERE ops_product_id = 352 sec

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

(Cached) 52520048f72321f7fc95c1219427ab6d

120. SELECT * FROM address_book WHERE user_id = 0 sec

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

(Cached) cd3fa65484d94fadd06c251b01a31fd8

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

(Cached) 52520048f72321f7fc95c1219427ab6d

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

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

(Cached) 6eaa3b39c2718890711cfd27fb194775

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

(Cached) 09edf8b51add513de8d19a10ef493375

126. 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

127. 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

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

(Cached) 613b110f15bfd6188f372b9124b62c8e

129 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

130. 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

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

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 132. 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 132. 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 132. 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 132. 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. 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 00:46:20' AND banner_image.banner_end_date >= '2026-06-13 00:46:20')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](352)[[:>:]]' 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

142 141. 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 00:46:20' AND banner_image.banner_end_date >= '2026-06-13 00:46:20')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](352)[[:>:]]' 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

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

(Cached) cfc88bdad1d3c808679011331b88f107

144. 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 = 352 AND products_description.site_language_id = 1 AND products.predefined_product_type IN ('0', '1') sec

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

146. 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` = '73' ) AND product_category.parent_id = '0' ) OR product_category.category_id = 73 AND product_category.status = '1' sec

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

148. SELECT * FROM product_settings WHERE product_settings.products_id = 352 AND product_settings.setting_constant_name = 'PRODUCT_CREATE_HELP_TEMPLATE' sec

149. 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

150. 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 = 352 AND products_description.site_language_id = 1 sec

151. SELECT * FROM product_settings WHERE product_settings.products_id = 352 sec

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

153. 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 = 352 WHERE product_master_option.status = '1' sec

154. 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 = 352 AND products.kit_type_id != '2' AND products_description.site_language_id = 1 AND products.visible = 1 ORDER BY products.products_id ASC sec

155. 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 = 352 sec

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

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

158. SELECT option_id,mask_image_landscape,mask_image_potrait,pages_id,size_id,attribute_id FROM products_mask WHERE product_id = 352 sec

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

(Cached) 5b009b5f388b1340ca0f50e382b3397a

160. 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 = 352 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