14pt Postcards (Postcards)

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/marketing-material/postcards/14pt-postcards/' OR old_url = 'https://uday.fourprintshop.com/marketing-material/postcards/14pt-postcards/' OR old_url = 'https://uday.fourprintshop.com/marketing-material/postcards/14pt-postcards/') ORDER BY url_redirection_id ASC sec

11. SELECT * FROM site_currency WHERE default_currency = '1' sec

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

13. 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 = '14pt-postcards' sec

14. SELECT products.predefined_product_type, products.price_defining_method, products.is_promotional FROM products WHERE products.products_id = 385 sec

15. 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 = 385 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

16. SELECT * FROM products_studio_3d_models WHERE products_studio_3d_models.products_id = 385 AND products_studio_3d_models.status = '1' sec

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

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

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

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

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

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

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

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

25. 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 = 385 sec

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

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

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

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

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

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

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

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

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

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

36. SELECT SQL_CALC_FOUND_ROWS * FROM banner_image_setting sec

(Cached) 3032d2886e227e87f9c8146b7a2b4507

38. SELECT * FROM products WHERE products.products_id = 385 sec

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

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

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

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

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

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

45. SELECT category_uuid FROM tp_4over_category WHERE category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

46. SELECT forover_product_id FROM tp_move_ops_product WHERE ops_product_id = 385 ORDER BY default_selected DESC sec

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

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

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

50. 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 = 22 AND product_category_description.site_language_id = 1 AND product_category.parent_id != 0 sec

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

52. SELECT * FROM products_sizes WHERE products_sizes.products_id = 385 AND products_sizes.visible = '1' AND site_language_id = 1 sec

53. 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 = 385 AND orders_feedback.status like '1' sec

54. 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 = 385 OR duplicate_product_id LIKE '%,385-%') 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

55. 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 = 385 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

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

57. SELECT products.predefined_product_type FROM products WHERE products.products_id = 385 sec

58. 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 '(^|,)(385)(,|$)' AND coupon.created_by = 0 AND '2026-06-13 00:41:59' 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

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

(Cached) 38cd42efff1fff38bed6470c2cfe436b

60. SELECT * FROM tp_move_ops_product WHERE ops_product_id = 385 sec

61. 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 = '104ce900-6cf2-4e76-85cb-7452b649aa0a' AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' GROUP BY option_group_uuid ORDER BY tp_4over_product_group_master.order_by ASC, tp_product_price.product_baseprice ASC sec

62. SELECT * FROM tp_4over_product_options_settings WHERE category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' AND tp_4over_product_options_settings.ops_product_id IN ('0', '385') 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

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

64. SELECT * FROM tp_4over_product_group_orderby_and_quote WHERE ops_product_id IN ('0', '385') AND categoryId = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' GROUP BY ops_product_id,option_group_uuid ORDER BY ops_product_id DESC sec

65. SELECT option_group_uuid,option_group_name FROM tp_4over_product_group_master sec

(Cached) b4f1269419b4ab10b5b7d25eb2c214cf

66. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '04e349a7-2af1-4332-ae0d-5af407c9a279', '06bf338f-0d46-4a54-a869-a9c5b83787b9', '078db3e0-c8bc-492c-b933-ee28a80676d3', '08c209b7-89c9-4720-b74b-f65be7d6fcd6', '0951d79a-77cd-4d04-9ad4-68b60ab88615', '0aa1cfa6-f589-4551-9c30-ddcbe1f487a7', '0b1e1148-3df6-4438-a3fa-abc0ee8adaa2', '0f7c0e19-5bf9-40f7-ab5c-7b1f4bc8710f', '10e81946-686f-46b5-bb17-70c1c219f527', '1524a5c1-ca6a-459d-9f5c-2bc9e852e482', '1636f50b-3250-4f6a-8a98-9419df12f5cd', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '1e2668fc-d325-44cc-8ff6-4a94c28c1959', '1f7b6715-1e3e-438c-8929-d2de0fb6c81e', '1f824a91-d9eb-478e-86fe-010e880b8721', '1fcd785a-5ed1-4fa0-a560-adf244988e56', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '2222f69b-ebd6-4672-b21e-229197bba347', '238da98d-4e6d-440f-93e6-403b5f36e57d', '23dde635-ade1-4665-9dc7-c345bdaae17e', '24898ef7-7649-416d-936a-7a8d986c41bf', '2a220f64-b5b8-4f6f-a587-f3289c1636ff', '2b74a0dc-254b-4143-9c4e-088d3b8339b0', '2c8df5cb-ef0d-401f-b1ae-7673a94da64a', '2d69a570-6ca7-4985-be45-46d60a0bb7cd', '2df58931-1d47-4fa5-a051-8dca51b70edf', '2ee3a5b9-9acc-4270-a1ec-08a0dc77af77', '2ff5a36e-cc74-4a96-a011-1ffc144dee3c', '312a8d2f-e634-4f25-85e2-de96e4f560ee', '323fb851-be12-4316-a780-48457cac653f', '331a50da-fbe0-4da0-9357-93813fc17c72', '34eedfa5-350d-4ea9-b4f3-a33fdad6cd69', '36fa29e0-9314-4a83-be4b-4800e5744d50', '39fe1491-5155-43a9-bca8-238708dc8710', '3a449fbf-e70c-445c-baac-1f5c79ff49a5', '3a78b179-7d2b-467f-9547-8d8f0d22faa5', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '3db85f15-81fb-41b4-ad18-4faba24b07d3', '3f98b902-523d-433a-be70-54c8e6bb2411', '403dccc0-7ed0-4afb-86ca-0ee94f0b6e3b', '43e067b8-b9c6-4c7d-b66c-9ff7e428496d', '450b109c-91b8-47f3-8474-bd35a4fca006', '456c4994-0260-4aab-b1d6-42b6571f8bb8', '469a8376-4eca-4501-be07-e272c595ba89', '46a979f7-3f86-49ad-8b4f-f82e4e31d04d', '46ba4bc2-06b6-47ad-af24-f893f90fafb6', '47608d20-4556-4f17-876e-3a7f2fc2f22e', '483387d6-303d-4adb-ace1-259c4c86590e', '488a39f7-b5b6-4b66-b672-4ac4fb96a50f', '48a7eff0-5305-43cf-9c80-49b4fdae2a5e', '4e426769-9a62-41eb-baef-07e6e70fb036', '4ea37010-3302-494f-8ef6-61bdf17fe712', '4f50589e-ec9c-4a1c-830d-cd7f0a9db58d', '526bfeb2-08ff-4622-be31-42f4f21a9e98', '564b01e5-36f7-4773-8c7f-1d800ed351a1', '590ccf93-b27e-44a1-8143-5edacb956a6a', '5a125b29-f8da-4a0c-9aff-cea2d2ff81cf', '5be64be6-c076-4289-b1d1-d90867b03551', '5d01fdd4-0ad0-441f-bc66-82e217605ede', '65e2c48a-0e2c-42fe-95f9-60e414eef25b', '6805e6a8-86c9-4a26-899f-d1f2e7003fa4', '68b2f921-04fe-46f3-a088-1e18cb8abcc0', '696f1384-7af1-4779-92ed-21af9ce24a4a', '6a59c15b-56be-4987-8a2f-3e086f6481fb', '6b8ba711-ce3a-416c-9e3e-7a3f1b4da4d2', '6c393fe3-b520-4919-ab43-7e65c85491af', '6d420cc9-8a1d-4b84-b02c-af5b83a5e18a', '6d537dd9-d689-4ccd-a328-7c3254abaea9', '6f3c5b57-5bb1-4d26-8b74-1632af74bd04', '6f4b583e-2650-49f6-a62a-3d5474eb89ac', '7013c5c2-884c-4b02-9d3b-cb24ea0952b6', '7051a7f9-e085-43a7-958d-4afdc964ec78', '746ae9b3-5ce2-4d32-8cbf-35d5f8f2848e', '74e29a3c-6377-4339-8de4-5cee51466cad', '7828fe39-f456-48d3-bb10-f1fa42ad0125', '7a6e8717-0c37-4b9e-aad7-a4cd915549c9', '7a9d14f7-1320-4ca9-b00a-9f06b621c668', '7c5e3993-58cb-40c8-aafc-9a0e04d5f4eb', '7cd721a1-266a-4fcb-b2de-3ba603fbe57a', '7e3f612b-0567-4b27-8ec4-fe8f46ec5254', '7eb644a6-36fb-446e-8584-0c3c4b68d557', '8034aec6-50d4-4a6d-ad6e-4df2b692875b', '8085e484-651f-46fb-89e6-cbdef9ccbe13', '82c1e672-9985-436c-8651-5e7a9fb71b59', '82f2acef-85e9-465e-889e-9d3b02ef41c5', '83c33637-fdde-4bd8-b881-f5a0171df060', '84370b14-0315-443d-93b8-74bf955424a0', '853f8ab8-c19c-482c-972f-8dfc7cc31973', '865e44be-48fe-44e0-874a-654c23f2eb49', '87504265-912e-4ea3-9963-a6b6c3e3ce95', '87d78d1f-d7a3-4d17-b12d-b3e1711c2076', '8a7a67a2-3581-4ae9-900e-60be4b613c4d', '8c85e555-747a-4e10-ad4a-2412b5310d6e', '8eb96128-a4de-45aa-96cd-85098a67515b', '9027a4b5-e1d5-4d77-ada0-c8e717d20b96', '912f24c4-2a66-4d44-a361-9a64acf07e07', '913f160c-be3a-41bb-9a0c-88d213e137e4', '95ab0192-f7d3-458b-8570-5870c806adda', '95e0e8ae-1eea-4ef3-9476-5ffb56f68e46', '98841a08-8044-4902-80c4-bd3f337e98b2', '9ad05449-529d-426a-bb1c-a098e9cb32b3', '9fae5679-0aff-48d7-9de3-cdb1f8070cc3', '9fcacc66-568c-4b6f-9ece-c89ce6fe0ad7', 'a37d71a9-8b2b-4363-bddf-b166af848d2a', 'a3d5c3bc-fbf1-4dd1-b966-833d803cb9d3', 'a5ea7625-93da-44f7-9591-526b12cdd684', 'a6fa0055-b9c7-4af2-9f13-1782163ebe09', 'a74e0e93-fa8f-4cf2-a4bf-e91f3b0e7e15', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'a9702612-7a8f-429c-a862-d8d052ec9dba', 'aa761a27-8688-4284-bb99-75f3a637ae4c', 'aa836ad7-8354-4556-b9da-4816d0be8342', 'aac142ce-df6f-47c7-be00-6400aaedf507', 'b70cc108-727d-44d2-956d-3ebf3406cf4c', 'b8a4826c-0876-49c4-b079-117b44bab3c3', 'b8c1d39e-2d03-4736-9998-f9c5abc7e679', 'b8fb58d5-acff-4d3d-921e-2441606f5e88', 'b9706040-6bba-4e22-87d4-35f84b96dfd9', 'ba28ad3b-4ef4-4a1a-b62b-ed35a52c63d6', 'bf37568c-c4af-49ae-835e-adbb5fe9cd7d', 'c051b397-6356-405b-a575-b8a74e87b908', 'c06640fd-2fcc-44dc-9c19-8d49bdfae514', 'c0a720d1-05a8-412c-9c9f-14c4b23b1087', 'c2db05cd-f4b9-4403-9148-f51d17db4453', 'c85e1c28-41dd-46bb-8042-82c92d983693', 'c93c00a6-7072-4c78-a690-fa1ffb45c16c', 'c9d92115-5a04-4df3-b3c3-25710175eecc', 'ca482753-a3b3-406a-8d6c-4e0ecf348001', 'cc362691-13ec-4560-bba5-cd10293096ca', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'cce2438a-a283-4057-bebc-df3f3591be0c', 'cf7eacfb-9306-4001-9b67-f35d55554e51', 'd094551a-d95f-4aac-8381-06092a6e3d41', 'd20529fe-02fd-4f14-941f-d095ee140ade', 'd32c44ea-9470-43d0-a778-03b7e019b792', 'db5d08cc-eaa2-46df-ba65-bffece5360a1', 'de5f42c8-4963-4ba3-8f76-cc65bfb24f69', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'dfa37d9c-ed6b-4da8-bed5-af51133fc15b', 'dfc6f51d-5d92-4c8c-b6d5-31b0e10be3af', 'dfe0f8ac-67f1-455e-b012-bd1bbf19e9b5', 'e5284f2f-77d0-4741-af35-f972587ed3ea', 'e5810dae-c9d2-4d99-9617-0e312168b9db', 'e7ea42c5-367b-48fb-9412-eb6ed3d5cc62', 'e9f4bd6b-604b-4826-b9df-1ca66d2fcb14', 'ea1cee90-e0ab-458f-9469-c206434664c0', 'ed5cd63a-6e22-41e8-9143-b8d8588f83dc', 'ef23f613-e034-430d-9045-629c26a103a3', 'efecabc5-628e-4b4a-b9ac-b87d37f87897', 'f04281a8-878a-4f27-9cd1-4294c8bbeecf', 'f07e3340-94a9-4b14-9f23-2fb10a22442f', 'f14149d6-2673-45a9-ab6d-5d79b367438b', 'f2010071-314d-434b-b418-fc87f63ded07', 'f2e202ca-9bc4-49fa-9e20-356782cbd4f6', 'f3c55098-5f51-41e8-83f3-631f8ed48cab', 'f607f753-609c-467c-bd96-181ece3990de', 'fd0dd9f0-4ea1-48d0-8a6a-74773dd1e518', '007bf86d-59ce-4e40-8e8c-fbdbf6d6550e', '00ff92fd-5c28-49a4-a65d-0f7b1d51efa8', '010cd59c-48c4-4e89-98f8-4acb1e2ff445') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

67. SELECT colorspec_uuid FROM tp_product_price WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '04e349a7-2af1-4332-ae0d-5af407c9a279', '06bf338f-0d46-4a54-a869-a9c5b83787b9', '078db3e0-c8bc-492c-b933-ee28a80676d3', '08c209b7-89c9-4720-b74b-f65be7d6fcd6', '0951d79a-77cd-4d04-9ad4-68b60ab88615', '0aa1cfa6-f589-4551-9c30-ddcbe1f487a7', '0b1e1148-3df6-4438-a3fa-abc0ee8adaa2', '0f7c0e19-5bf9-40f7-ab5c-7b1f4bc8710f', '10e81946-686f-46b5-bb17-70c1c219f527', '1524a5c1-ca6a-459d-9f5c-2bc9e852e482', '1636f50b-3250-4f6a-8a98-9419df12f5cd', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '1e2668fc-d325-44cc-8ff6-4a94c28c1959', '1f7b6715-1e3e-438c-8929-d2de0fb6c81e', '1f824a91-d9eb-478e-86fe-010e880b8721', '1fcd785a-5ed1-4fa0-a560-adf244988e56', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '2222f69b-ebd6-4672-b21e-229197bba347', '238da98d-4e6d-440f-93e6-403b5f36e57d', '23dde635-ade1-4665-9dc7-c345bdaae17e', '24898ef7-7649-416d-936a-7a8d986c41bf', '2a220f64-b5b8-4f6f-a587-f3289c1636ff', '2b74a0dc-254b-4143-9c4e-088d3b8339b0', '2c8df5cb-ef0d-401f-b1ae-7673a94da64a', '2d69a570-6ca7-4985-be45-46d60a0bb7cd', '2df58931-1d47-4fa5-a051-8dca51b70edf', '2ee3a5b9-9acc-4270-a1ec-08a0dc77af77', '2ff5a36e-cc74-4a96-a011-1ffc144dee3c', '312a8d2f-e634-4f25-85e2-de96e4f560ee', '323fb851-be12-4316-a780-48457cac653f', '331a50da-fbe0-4da0-9357-93813fc17c72', '34eedfa5-350d-4ea9-b4f3-a33fdad6cd69', '36fa29e0-9314-4a83-be4b-4800e5744d50', '39fe1491-5155-43a9-bca8-238708dc8710', '3a449fbf-e70c-445c-baac-1f5c79ff49a5', '3a78b179-7d2b-467f-9547-8d8f0d22faa5', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '3db85f15-81fb-41b4-ad18-4faba24b07d3', '3f98b902-523d-433a-be70-54c8e6bb2411', '403dccc0-7ed0-4afb-86ca-0ee94f0b6e3b', '43e067b8-b9c6-4c7d-b66c-9ff7e428496d', '450b109c-91b8-47f3-8474-bd35a4fca006', '456c4994-0260-4aab-b1d6-42b6571f8bb8', '469a8376-4eca-4501-be07-e272c595ba89', '46a979f7-3f86-49ad-8b4f-f82e4e31d04d', '46ba4bc2-06b6-47ad-af24-f893f90fafb6', '47608d20-4556-4f17-876e-3a7f2fc2f22e', '483387d6-303d-4adb-ace1-259c4c86590e', '488a39f7-b5b6-4b66-b672-4ac4fb96a50f', '48a7eff0-5305-43cf-9c80-49b4fdae2a5e', '4e426769-9a62-41eb-baef-07e6e70fb036', '4ea37010-3302-494f-8ef6-61bdf17fe712', '4f50589e-ec9c-4a1c-830d-cd7f0a9db58d', '526bfeb2-08ff-4622-be31-42f4f21a9e98', '564b01e5-36f7-4773-8c7f-1d800ed351a1', '590ccf93-b27e-44a1-8143-5edacb956a6a', '5a125b29-f8da-4a0c-9aff-cea2d2ff81cf', '5be64be6-c076-4289-b1d1-d90867b03551', '5d01fdd4-0ad0-441f-bc66-82e217605ede', '65e2c48a-0e2c-42fe-95f9-60e414eef25b', '6805e6a8-86c9-4a26-899f-d1f2e7003fa4', '68b2f921-04fe-46f3-a088-1e18cb8abcc0', '696f1384-7af1-4779-92ed-21af9ce24a4a', '6a59c15b-56be-4987-8a2f-3e086f6481fb', '6b8ba711-ce3a-416c-9e3e-7a3f1b4da4d2', '6c393fe3-b520-4919-ab43-7e65c85491af', '6d420cc9-8a1d-4b84-b02c-af5b83a5e18a', '6d537dd9-d689-4ccd-a328-7c3254abaea9', '6f3c5b57-5bb1-4d26-8b74-1632af74bd04', '6f4b583e-2650-49f6-a62a-3d5474eb89ac', '7013c5c2-884c-4b02-9d3b-cb24ea0952b6', '7051a7f9-e085-43a7-958d-4afdc964ec78', '746ae9b3-5ce2-4d32-8cbf-35d5f8f2848e', '74e29a3c-6377-4339-8de4-5cee51466cad', '7828fe39-f456-48d3-bb10-f1fa42ad0125', '7a6e8717-0c37-4b9e-aad7-a4cd915549c9', '7a9d14f7-1320-4ca9-b00a-9f06b621c668', '7c5e3993-58cb-40c8-aafc-9a0e04d5f4eb', '7cd721a1-266a-4fcb-b2de-3ba603fbe57a', '7e3f612b-0567-4b27-8ec4-fe8f46ec5254', '7eb644a6-36fb-446e-8584-0c3c4b68d557', '8034aec6-50d4-4a6d-ad6e-4df2b692875b', '8085e484-651f-46fb-89e6-cbdef9ccbe13', '82c1e672-9985-436c-8651-5e7a9fb71b59', '82f2acef-85e9-465e-889e-9d3b02ef41c5', '83c33637-fdde-4bd8-b881-f5a0171df060', '84370b14-0315-443d-93b8-74bf955424a0', '853f8ab8-c19c-482c-972f-8dfc7cc31973', '865e44be-48fe-44e0-874a-654c23f2eb49', '87504265-912e-4ea3-9963-a6b6c3e3ce95', '87d78d1f-d7a3-4d17-b12d-b3e1711c2076', '8a7a67a2-3581-4ae9-900e-60be4b613c4d', '8c85e555-747a-4e10-ad4a-2412b5310d6e', '8eb96128-a4de-45aa-96cd-85098a67515b', '9027a4b5-e1d5-4d77-ada0-c8e717d20b96', '912f24c4-2a66-4d44-a361-9a64acf07e07', '913f160c-be3a-41bb-9a0c-88d213e137e4', '95ab0192-f7d3-458b-8570-5870c806adda', '95e0e8ae-1eea-4ef3-9476-5ffb56f68e46', '98841a08-8044-4902-80c4-bd3f337e98b2', '9ad05449-529d-426a-bb1c-a098e9cb32b3', '9fae5679-0aff-48d7-9de3-cdb1f8070cc3', '9fcacc66-568c-4b6f-9ece-c89ce6fe0ad7', 'a37d71a9-8b2b-4363-bddf-b166af848d2a', 'a3d5c3bc-fbf1-4dd1-b966-833d803cb9d3', 'a5ea7625-93da-44f7-9591-526b12cdd684', 'a6fa0055-b9c7-4af2-9f13-1782163ebe09', 'a74e0e93-fa8f-4cf2-a4bf-e91f3b0e7e15', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'a9702612-7a8f-429c-a862-d8d052ec9dba', 'aa761a27-8688-4284-bb99-75f3a637ae4c', 'aa836ad7-8354-4556-b9da-4816d0be8342', 'aac142ce-df6f-47c7-be00-6400aaedf507', 'b70cc108-727d-44d2-956d-3ebf3406cf4c', 'b8a4826c-0876-49c4-b079-117b44bab3c3', 'b8c1d39e-2d03-4736-9998-f9c5abc7e679', 'b8fb58d5-acff-4d3d-921e-2441606f5e88', 'b9706040-6bba-4e22-87d4-35f84b96dfd9', 'ba28ad3b-4ef4-4a1a-b62b-ed35a52c63d6', 'bf37568c-c4af-49ae-835e-adbb5fe9cd7d', 'c051b397-6356-405b-a575-b8a74e87b908', 'c06640fd-2fcc-44dc-9c19-8d49bdfae514', 'c0a720d1-05a8-412c-9c9f-14c4b23b1087', 'c2db05cd-f4b9-4403-9148-f51d17db4453', 'c85e1c28-41dd-46bb-8042-82c92d983693', 'c93c00a6-7072-4c78-a690-fa1ffb45c16c', 'c9d92115-5a04-4df3-b3c3-25710175eecc', 'ca482753-a3b3-406a-8d6c-4e0ecf348001', 'cc362691-13ec-4560-bba5-cd10293096ca', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'cce2438a-a283-4057-bebc-df3f3591be0c', 'cf7eacfb-9306-4001-9b67-f35d55554e51', 'd094551a-d95f-4aac-8381-06092a6e3d41', 'd20529fe-02fd-4f14-941f-d095ee140ade', 'd32c44ea-9470-43d0-a778-03b7e019b792', 'db5d08cc-eaa2-46df-ba65-bffece5360a1', 'de5f42c8-4963-4ba3-8f76-cc65bfb24f69', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'dfa37d9c-ed6b-4da8-bed5-af51133fc15b', 'dfc6f51d-5d92-4c8c-b6d5-31b0e10be3af', 'dfe0f8ac-67f1-455e-b012-bd1bbf19e9b5', 'e5284f2f-77d0-4741-af35-f972587ed3ea', 'e5810dae-c9d2-4d99-9617-0e312168b9db', 'e7ea42c5-367b-48fb-9412-eb6ed3d5cc62', 'e9f4bd6b-604b-4826-b9df-1ca66d2fcb14', 'ea1cee90-e0ab-458f-9469-c206434664c0', 'ed5cd63a-6e22-41e8-9143-b8d8588f83dc', 'ef23f613-e034-430d-9045-629c26a103a3', 'efecabc5-628e-4b4a-b9ac-b87d37f87897', 'f04281a8-878a-4f27-9cd1-4294c8bbeecf', 'f07e3340-94a9-4b14-9f23-2fb10a22442f', 'f14149d6-2673-45a9-ab6d-5d79b367438b', 'f2010071-314d-434b-b418-fc87f63ded07', 'f2e202ca-9bc4-49fa-9e20-356782cbd4f6', 'f3c55098-5f51-41e8-83f3-631f8ed48cab', 'f607f753-609c-467c-bd96-181ece3990de', 'fd0dd9f0-4ea1-48d0-8a6a-74773dd1e518', '007bf86d-59ce-4e40-8e8c-fbdbf6d6550e', '00ff92fd-5c28-49a4-a65d-0f7b1d51efa8', '010cd59c-48c4-4e89-98f8-4acb1e2ff445') GROUP BY colorspec_uuid sec

68. SELECT * FROM tp_4over_product_option_rules WHERE category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' AND status = '1' sec

69 66. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '04e349a7-2af1-4332-ae0d-5af407c9a279', '06bf338f-0d46-4a54-a869-a9c5b83787b9', '078db3e0-c8bc-492c-b933-ee28a80676d3', '08c209b7-89c9-4720-b74b-f65be7d6fcd6', '0951d79a-77cd-4d04-9ad4-68b60ab88615', '0aa1cfa6-f589-4551-9c30-ddcbe1f487a7', '0b1e1148-3df6-4438-a3fa-abc0ee8adaa2', '0f7c0e19-5bf9-40f7-ab5c-7b1f4bc8710f', '10e81946-686f-46b5-bb17-70c1c219f527', '1524a5c1-ca6a-459d-9f5c-2bc9e852e482', '1636f50b-3250-4f6a-8a98-9419df12f5cd', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '1e2668fc-d325-44cc-8ff6-4a94c28c1959', '1f7b6715-1e3e-438c-8929-d2de0fb6c81e', '1f824a91-d9eb-478e-86fe-010e880b8721', '1fcd785a-5ed1-4fa0-a560-adf244988e56', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '2222f69b-ebd6-4672-b21e-229197bba347', '238da98d-4e6d-440f-93e6-403b5f36e57d', '23dde635-ade1-4665-9dc7-c345bdaae17e', '24898ef7-7649-416d-936a-7a8d986c41bf', '2a220f64-b5b8-4f6f-a587-f3289c1636ff', '2b74a0dc-254b-4143-9c4e-088d3b8339b0', '2c8df5cb-ef0d-401f-b1ae-7673a94da64a', '2d69a570-6ca7-4985-be45-46d60a0bb7cd', '2df58931-1d47-4fa5-a051-8dca51b70edf', '2ee3a5b9-9acc-4270-a1ec-08a0dc77af77', '2ff5a36e-cc74-4a96-a011-1ffc144dee3c', '312a8d2f-e634-4f25-85e2-de96e4f560ee', '323fb851-be12-4316-a780-48457cac653f', '331a50da-fbe0-4da0-9357-93813fc17c72', '34eedfa5-350d-4ea9-b4f3-a33fdad6cd69', '36fa29e0-9314-4a83-be4b-4800e5744d50', '39fe1491-5155-43a9-bca8-238708dc8710', '3a449fbf-e70c-445c-baac-1f5c79ff49a5', '3a78b179-7d2b-467f-9547-8d8f0d22faa5', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '3db85f15-81fb-41b4-ad18-4faba24b07d3', '3f98b902-523d-433a-be70-54c8e6bb2411', '403dccc0-7ed0-4afb-86ca-0ee94f0b6e3b', '43e067b8-b9c6-4c7d-b66c-9ff7e428496d', '450b109c-91b8-47f3-8474-bd35a4fca006', '456c4994-0260-4aab-b1d6-42b6571f8bb8', '469a8376-4eca-4501-be07-e272c595ba89', '46a979f7-3f86-49ad-8b4f-f82e4e31d04d', '46ba4bc2-06b6-47ad-af24-f893f90fafb6', '47608d20-4556-4f17-876e-3a7f2fc2f22e', '483387d6-303d-4adb-ace1-259c4c86590e', '488a39f7-b5b6-4b66-b672-4ac4fb96a50f', '48a7eff0-5305-43cf-9c80-49b4fdae2a5e', '4e426769-9a62-41eb-baef-07e6e70fb036', '4ea37010-3302-494f-8ef6-61bdf17fe712', '4f50589e-ec9c-4a1c-830d-cd7f0a9db58d', '526bfeb2-08ff-4622-be31-42f4f21a9e98', '564b01e5-36f7-4773-8c7f-1d800ed351a1', '590ccf93-b27e-44a1-8143-5edacb956a6a', '5a125b29-f8da-4a0c-9aff-cea2d2ff81cf', '5be64be6-c076-4289-b1d1-d90867b03551', '5d01fdd4-0ad0-441f-bc66-82e217605ede', '65e2c48a-0e2c-42fe-95f9-60e414eef25b', '6805e6a8-86c9-4a26-899f-d1f2e7003fa4', '68b2f921-04fe-46f3-a088-1e18cb8abcc0', '696f1384-7af1-4779-92ed-21af9ce24a4a', '6a59c15b-56be-4987-8a2f-3e086f6481fb', '6b8ba711-ce3a-416c-9e3e-7a3f1b4da4d2', '6c393fe3-b520-4919-ab43-7e65c85491af', '6d420cc9-8a1d-4b84-b02c-af5b83a5e18a', '6d537dd9-d689-4ccd-a328-7c3254abaea9', '6f3c5b57-5bb1-4d26-8b74-1632af74bd04', '6f4b583e-2650-49f6-a62a-3d5474eb89ac', '7013c5c2-884c-4b02-9d3b-cb24ea0952b6', '7051a7f9-e085-43a7-958d-4afdc964ec78', '746ae9b3-5ce2-4d32-8cbf-35d5f8f2848e', '74e29a3c-6377-4339-8de4-5cee51466cad', '7828fe39-f456-48d3-bb10-f1fa42ad0125', '7a6e8717-0c37-4b9e-aad7-a4cd915549c9', '7a9d14f7-1320-4ca9-b00a-9f06b621c668', '7c5e3993-58cb-40c8-aafc-9a0e04d5f4eb', '7cd721a1-266a-4fcb-b2de-3ba603fbe57a', '7e3f612b-0567-4b27-8ec4-fe8f46ec5254', '7eb644a6-36fb-446e-8584-0c3c4b68d557', '8034aec6-50d4-4a6d-ad6e-4df2b692875b', '8085e484-651f-46fb-89e6-cbdef9ccbe13', '82c1e672-9985-436c-8651-5e7a9fb71b59', '82f2acef-85e9-465e-889e-9d3b02ef41c5', '83c33637-fdde-4bd8-b881-f5a0171df060', '84370b14-0315-443d-93b8-74bf955424a0', '853f8ab8-c19c-482c-972f-8dfc7cc31973', '865e44be-48fe-44e0-874a-654c23f2eb49', '87504265-912e-4ea3-9963-a6b6c3e3ce95', '87d78d1f-d7a3-4d17-b12d-b3e1711c2076', '8a7a67a2-3581-4ae9-900e-60be4b613c4d', '8c85e555-747a-4e10-ad4a-2412b5310d6e', '8eb96128-a4de-45aa-96cd-85098a67515b', '9027a4b5-e1d5-4d77-ada0-c8e717d20b96', '912f24c4-2a66-4d44-a361-9a64acf07e07', '913f160c-be3a-41bb-9a0c-88d213e137e4', '95ab0192-f7d3-458b-8570-5870c806adda', '95e0e8ae-1eea-4ef3-9476-5ffb56f68e46', '98841a08-8044-4902-80c4-bd3f337e98b2', '9ad05449-529d-426a-bb1c-a098e9cb32b3', '9fae5679-0aff-48d7-9de3-cdb1f8070cc3', '9fcacc66-568c-4b6f-9ece-c89ce6fe0ad7', 'a37d71a9-8b2b-4363-bddf-b166af848d2a', 'a3d5c3bc-fbf1-4dd1-b966-833d803cb9d3', 'a5ea7625-93da-44f7-9591-526b12cdd684', 'a6fa0055-b9c7-4af2-9f13-1782163ebe09', 'a74e0e93-fa8f-4cf2-a4bf-e91f3b0e7e15', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'a9702612-7a8f-429c-a862-d8d052ec9dba', 'aa761a27-8688-4284-bb99-75f3a637ae4c', 'aa836ad7-8354-4556-b9da-4816d0be8342', 'aac142ce-df6f-47c7-be00-6400aaedf507', 'b70cc108-727d-44d2-956d-3ebf3406cf4c', 'b8a4826c-0876-49c4-b079-117b44bab3c3', 'b8c1d39e-2d03-4736-9998-f9c5abc7e679', 'b8fb58d5-acff-4d3d-921e-2441606f5e88', 'b9706040-6bba-4e22-87d4-35f84b96dfd9', 'ba28ad3b-4ef4-4a1a-b62b-ed35a52c63d6', 'bf37568c-c4af-49ae-835e-adbb5fe9cd7d', 'c051b397-6356-405b-a575-b8a74e87b908', 'c06640fd-2fcc-44dc-9c19-8d49bdfae514', 'c0a720d1-05a8-412c-9c9f-14c4b23b1087', 'c2db05cd-f4b9-4403-9148-f51d17db4453', 'c85e1c28-41dd-46bb-8042-82c92d983693', 'c93c00a6-7072-4c78-a690-fa1ffb45c16c', 'c9d92115-5a04-4df3-b3c3-25710175eecc', 'ca482753-a3b3-406a-8d6c-4e0ecf348001', 'cc362691-13ec-4560-bba5-cd10293096ca', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'cce2438a-a283-4057-bebc-df3f3591be0c', 'cf7eacfb-9306-4001-9b67-f35d55554e51', 'd094551a-d95f-4aac-8381-06092a6e3d41', 'd20529fe-02fd-4f14-941f-d095ee140ade', 'd32c44ea-9470-43d0-a778-03b7e019b792', 'db5d08cc-eaa2-46df-ba65-bffece5360a1', 'de5f42c8-4963-4ba3-8f76-cc65bfb24f69', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'dfa37d9c-ed6b-4da8-bed5-af51133fc15b', 'dfc6f51d-5d92-4c8c-b6d5-31b0e10be3af', 'dfe0f8ac-67f1-455e-b012-bd1bbf19e9b5', 'e5284f2f-77d0-4741-af35-f972587ed3ea', 'e5810dae-c9d2-4d99-9617-0e312168b9db', 'e7ea42c5-367b-48fb-9412-eb6ed3d5cc62', 'e9f4bd6b-604b-4826-b9df-1ca66d2fcb14', 'ea1cee90-e0ab-458f-9469-c206434664c0', 'ed5cd63a-6e22-41e8-9143-b8d8588f83dc', 'ef23f613-e034-430d-9045-629c26a103a3', 'efecabc5-628e-4b4a-b9ac-b87d37f87897', 'f04281a8-878a-4f27-9cd1-4294c8bbeecf', 'f07e3340-94a9-4b14-9f23-2fb10a22442f', 'f14149d6-2673-45a9-ab6d-5d79b367438b', 'f2010071-314d-434b-b418-fc87f63ded07', 'f2e202ca-9bc4-49fa-9e20-356782cbd4f6', 'f3c55098-5f51-41e8-83f3-631f8ed48cab', 'f607f753-609c-467c-bd96-181ece3990de', 'fd0dd9f0-4ea1-48d0-8a6a-74773dd1e518', '007bf86d-59ce-4e40-8e8c-fbdbf6d6550e', '00ff92fd-5c28-49a4-a65d-0f7b1d51efa8', '010cd59c-48c4-4e89-98f8-4acb1e2ff445') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

70. SELECT product_uuid FROM tp_4over_products WHERE categories = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' And status = '1' sec

71. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'd864aba7-b3ca-439d-9401-4bf4987f152c' AND t4pgo.option_uuid = '16ebe401-5398-422d-8cb0-f3adbb82deb5' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '17fc2260-9acc-405d-9fc7-3ef3ac293b09' AND t4pgo.option_uuid = '70efd00a-4e8b-432e-9864-fa4d50318d72' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P11 INNER JOIN (SELECT t4pgo.product_uuid as pid_12 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '254afeea-1fd1-4efb-b5fb-c9c3bf4c13d2' AND t4pgo.option_uuid = '58689abb-25c0-461c-a4c3-a80b627d6649' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P12 INNER JOIN (SELECT t4pgo.product_uuid as pid_13 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '05d933cb-0474-4e5a-bece-42504c6860fd' AND t4pgo.option_uuid = '3e5e9bdd-d78a-4c28-a41d-fe1407925ca6' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P13 INNER JOIN (SELECT t4pgo.product_uuid as pid_14 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd4476dbd-f414-44b9-b66f-b9d485a42e70' AND t4pgo.option_uuid = '16c931fd-61ef-448b-801c-ecbf2a5d166f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P14 INNER JOIN (SELECT t4pgo.product_uuid as pid_15 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'f80e8179-b264-42ce-9f80-bb258a09a1fe' AND t4pgo.option_uuid = '50979118-b3a2-4556-9f46-d1da268f2354' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P15 INNER JOIN (SELECT t4pgo.product_uuid as pid_16 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'ed16daf6-77e4-4133-8d65-3947d5d19f52' AND t4pgo.option_uuid = '04f333df-18a7-4ff0-b6e9-e2f401a6d150' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P16 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 (P1.pid_1 = P12.pid_12) AND (P1.pid_1 = P13.pid_13) AND (P1.pid_1 = P14.pid_14) AND (P1.pid_1 = P15.pid_15) AND (P1.pid_1 = P16.pid_16) 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 (P2.pid_2 = P12.pid_12) AND (P2.pid_2 = P13.pid_13) AND (P2.pid_2 = P14.pid_14) AND (P2.pid_2 = P15.pid_15) AND (P2.pid_2 = P16.pid_16) 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 (P3.pid_3 = P12.pid_12) AND (P3.pid_3 = P13.pid_13) AND (P3.pid_3 = P14.pid_14) AND (P3.pid_3 = P15.pid_15) AND (P3.pid_3 = P16.pid_16) 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 (P4.pid_4 = P12.pid_12) AND (P4.pid_4 = P13.pid_13) AND (P4.pid_4 = P14.pid_14) AND (P4.pid_4 = P15.pid_15) AND (P4.pid_4 = P16.pid_16) 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 (P5.pid_5 = P12.pid_12) AND (P5.pid_5 = P13.pid_13) AND (P5.pid_5 = P14.pid_14) AND (P5.pid_5 = P15.pid_15) AND (P5.pid_5 = P16.pid_16) 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 (P6.pid_6 = P12.pid_12) AND (P6.pid_6 = P13.pid_13) AND (P6.pid_6 = P14.pid_14) AND (P6.pid_6 = P15.pid_15) AND (P6.pid_6 = P16.pid_16) 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 (P7.pid_7 = P12.pid_12) AND (P7.pid_7 = P13.pid_13) AND (P7.pid_7 = P14.pid_14) AND (P7.pid_7 = P15.pid_15) AND (P7.pid_7 = P16.pid_16) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P8.pid_8 = P11.pid_11) AND (P8.pid_8 = P12.pid_12) AND (P8.pid_8 = P13.pid_13) AND (P8.pid_8 = P14.pid_14) AND (P8.pid_8 = P15.pid_15) AND (P8.pid_8 = P16.pid_16) AND (P9.pid_9 = P10.pid_10) AND (P9.pid_9 = P11.pid_11) AND (P9.pid_9 = P12.pid_12) AND (P9.pid_9 = P13.pid_13) AND (P9.pid_9 = P14.pid_14) AND (P9.pid_9 = P15.pid_15) AND (P9.pid_9 = P16.pid_16) AND (P10.pid_10 = P11.pid_11) AND (P10.pid_10 = P12.pid_12) AND (P10.pid_10 = P13.pid_13) AND (P10.pid_10 = P14.pid_14) AND (P10.pid_10 = P15.pid_15) AND (P10.pid_10 = P16.pid_16) AND (P11.pid_11 = P12.pid_12) AND (P11.pid_11 = P13.pid_13) AND (P11.pid_11 = P14.pid_14) AND (P11.pid_11 = P15.pid_15) AND (P11.pid_11 = P16.pid_16) AND (P12.pid_12 = P13.pid_13) AND (P12.pid_12 = P14.pid_14) AND (P12.pid_12 = P15.pid_15) AND (P12.pid_12 = P16.pid_16) AND (P13.pid_13 = P14.pid_14) AND (P13.pid_13 = P15.pid_15) AND (P13.pid_13 = P16.pid_16) AND (P14.pid_14 = P15.pid_15) AND (P14.pid_14 = P16.pid_16) AND (P15.pid_15 = P16.pid_16) sec

72. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND FP.categories = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

74. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' GROUP BY tp_4over_product_group_option_master.option_group_uuid sec

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

76 66. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '04e349a7-2af1-4332-ae0d-5af407c9a279', '06bf338f-0d46-4a54-a869-a9c5b83787b9', '078db3e0-c8bc-492c-b933-ee28a80676d3', '08c209b7-89c9-4720-b74b-f65be7d6fcd6', '0951d79a-77cd-4d04-9ad4-68b60ab88615', '0aa1cfa6-f589-4551-9c30-ddcbe1f487a7', '0b1e1148-3df6-4438-a3fa-abc0ee8adaa2', '0f7c0e19-5bf9-40f7-ab5c-7b1f4bc8710f', '10e81946-686f-46b5-bb17-70c1c219f527', '1524a5c1-ca6a-459d-9f5c-2bc9e852e482', '1636f50b-3250-4f6a-8a98-9419df12f5cd', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '1e2668fc-d325-44cc-8ff6-4a94c28c1959', '1f7b6715-1e3e-438c-8929-d2de0fb6c81e', '1f824a91-d9eb-478e-86fe-010e880b8721', '1fcd785a-5ed1-4fa0-a560-adf244988e56', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '2222f69b-ebd6-4672-b21e-229197bba347', '238da98d-4e6d-440f-93e6-403b5f36e57d', '23dde635-ade1-4665-9dc7-c345bdaae17e', '24898ef7-7649-416d-936a-7a8d986c41bf', '2a220f64-b5b8-4f6f-a587-f3289c1636ff', '2b74a0dc-254b-4143-9c4e-088d3b8339b0', '2c8df5cb-ef0d-401f-b1ae-7673a94da64a', '2d69a570-6ca7-4985-be45-46d60a0bb7cd', '2df58931-1d47-4fa5-a051-8dca51b70edf', '2ee3a5b9-9acc-4270-a1ec-08a0dc77af77', '2ff5a36e-cc74-4a96-a011-1ffc144dee3c', '312a8d2f-e634-4f25-85e2-de96e4f560ee', '323fb851-be12-4316-a780-48457cac653f', '331a50da-fbe0-4da0-9357-93813fc17c72', '34eedfa5-350d-4ea9-b4f3-a33fdad6cd69', '36fa29e0-9314-4a83-be4b-4800e5744d50', '39fe1491-5155-43a9-bca8-238708dc8710', '3a449fbf-e70c-445c-baac-1f5c79ff49a5', '3a78b179-7d2b-467f-9547-8d8f0d22faa5', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '3db85f15-81fb-41b4-ad18-4faba24b07d3', '3f98b902-523d-433a-be70-54c8e6bb2411', '403dccc0-7ed0-4afb-86ca-0ee94f0b6e3b', '43e067b8-b9c6-4c7d-b66c-9ff7e428496d', '450b109c-91b8-47f3-8474-bd35a4fca006', '456c4994-0260-4aab-b1d6-42b6571f8bb8', '469a8376-4eca-4501-be07-e272c595ba89', '46a979f7-3f86-49ad-8b4f-f82e4e31d04d', '46ba4bc2-06b6-47ad-af24-f893f90fafb6', '47608d20-4556-4f17-876e-3a7f2fc2f22e', '483387d6-303d-4adb-ace1-259c4c86590e', '488a39f7-b5b6-4b66-b672-4ac4fb96a50f', '48a7eff0-5305-43cf-9c80-49b4fdae2a5e', '4e426769-9a62-41eb-baef-07e6e70fb036', '4ea37010-3302-494f-8ef6-61bdf17fe712', '4f50589e-ec9c-4a1c-830d-cd7f0a9db58d', '526bfeb2-08ff-4622-be31-42f4f21a9e98', '564b01e5-36f7-4773-8c7f-1d800ed351a1', '590ccf93-b27e-44a1-8143-5edacb956a6a', '5a125b29-f8da-4a0c-9aff-cea2d2ff81cf', '5be64be6-c076-4289-b1d1-d90867b03551', '5d01fdd4-0ad0-441f-bc66-82e217605ede', '65e2c48a-0e2c-42fe-95f9-60e414eef25b', '6805e6a8-86c9-4a26-899f-d1f2e7003fa4', '68b2f921-04fe-46f3-a088-1e18cb8abcc0', '696f1384-7af1-4779-92ed-21af9ce24a4a', '6a59c15b-56be-4987-8a2f-3e086f6481fb', '6b8ba711-ce3a-416c-9e3e-7a3f1b4da4d2', '6c393fe3-b520-4919-ab43-7e65c85491af', '6d420cc9-8a1d-4b84-b02c-af5b83a5e18a', '6d537dd9-d689-4ccd-a328-7c3254abaea9', '6f3c5b57-5bb1-4d26-8b74-1632af74bd04', '6f4b583e-2650-49f6-a62a-3d5474eb89ac', '7013c5c2-884c-4b02-9d3b-cb24ea0952b6', '7051a7f9-e085-43a7-958d-4afdc964ec78', '746ae9b3-5ce2-4d32-8cbf-35d5f8f2848e', '74e29a3c-6377-4339-8de4-5cee51466cad', '7828fe39-f456-48d3-bb10-f1fa42ad0125', '7a6e8717-0c37-4b9e-aad7-a4cd915549c9', '7a9d14f7-1320-4ca9-b00a-9f06b621c668', '7c5e3993-58cb-40c8-aafc-9a0e04d5f4eb', '7cd721a1-266a-4fcb-b2de-3ba603fbe57a', '7e3f612b-0567-4b27-8ec4-fe8f46ec5254', '7eb644a6-36fb-446e-8584-0c3c4b68d557', '8034aec6-50d4-4a6d-ad6e-4df2b692875b', '8085e484-651f-46fb-89e6-cbdef9ccbe13', '82c1e672-9985-436c-8651-5e7a9fb71b59', '82f2acef-85e9-465e-889e-9d3b02ef41c5', '83c33637-fdde-4bd8-b881-f5a0171df060', '84370b14-0315-443d-93b8-74bf955424a0', '853f8ab8-c19c-482c-972f-8dfc7cc31973', '865e44be-48fe-44e0-874a-654c23f2eb49', '87504265-912e-4ea3-9963-a6b6c3e3ce95', '87d78d1f-d7a3-4d17-b12d-b3e1711c2076', '8a7a67a2-3581-4ae9-900e-60be4b613c4d', '8c85e555-747a-4e10-ad4a-2412b5310d6e', '8eb96128-a4de-45aa-96cd-85098a67515b', '9027a4b5-e1d5-4d77-ada0-c8e717d20b96', '912f24c4-2a66-4d44-a361-9a64acf07e07', '913f160c-be3a-41bb-9a0c-88d213e137e4', '95ab0192-f7d3-458b-8570-5870c806adda', '95e0e8ae-1eea-4ef3-9476-5ffb56f68e46', '98841a08-8044-4902-80c4-bd3f337e98b2', '9ad05449-529d-426a-bb1c-a098e9cb32b3', '9fae5679-0aff-48d7-9de3-cdb1f8070cc3', '9fcacc66-568c-4b6f-9ece-c89ce6fe0ad7', 'a37d71a9-8b2b-4363-bddf-b166af848d2a', 'a3d5c3bc-fbf1-4dd1-b966-833d803cb9d3', 'a5ea7625-93da-44f7-9591-526b12cdd684', 'a6fa0055-b9c7-4af2-9f13-1782163ebe09', 'a74e0e93-fa8f-4cf2-a4bf-e91f3b0e7e15', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'a9702612-7a8f-429c-a862-d8d052ec9dba', 'aa761a27-8688-4284-bb99-75f3a637ae4c', 'aa836ad7-8354-4556-b9da-4816d0be8342', 'aac142ce-df6f-47c7-be00-6400aaedf507', 'b70cc108-727d-44d2-956d-3ebf3406cf4c', 'b8a4826c-0876-49c4-b079-117b44bab3c3', 'b8c1d39e-2d03-4736-9998-f9c5abc7e679', 'b8fb58d5-acff-4d3d-921e-2441606f5e88', 'b9706040-6bba-4e22-87d4-35f84b96dfd9', 'ba28ad3b-4ef4-4a1a-b62b-ed35a52c63d6', 'bf37568c-c4af-49ae-835e-adbb5fe9cd7d', 'c051b397-6356-405b-a575-b8a74e87b908', 'c06640fd-2fcc-44dc-9c19-8d49bdfae514', 'c0a720d1-05a8-412c-9c9f-14c4b23b1087', 'c2db05cd-f4b9-4403-9148-f51d17db4453', 'c85e1c28-41dd-46bb-8042-82c92d983693', 'c93c00a6-7072-4c78-a690-fa1ffb45c16c', 'c9d92115-5a04-4df3-b3c3-25710175eecc', 'ca482753-a3b3-406a-8d6c-4e0ecf348001', 'cc362691-13ec-4560-bba5-cd10293096ca', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'cce2438a-a283-4057-bebc-df3f3591be0c', 'cf7eacfb-9306-4001-9b67-f35d55554e51', 'd094551a-d95f-4aac-8381-06092a6e3d41', 'd20529fe-02fd-4f14-941f-d095ee140ade', 'd32c44ea-9470-43d0-a778-03b7e019b792', 'db5d08cc-eaa2-46df-ba65-bffece5360a1', 'de5f42c8-4963-4ba3-8f76-cc65bfb24f69', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'dfa37d9c-ed6b-4da8-bed5-af51133fc15b', 'dfc6f51d-5d92-4c8c-b6d5-31b0e10be3af', 'dfe0f8ac-67f1-455e-b012-bd1bbf19e9b5', 'e5284f2f-77d0-4741-af35-f972587ed3ea', 'e5810dae-c9d2-4d99-9617-0e312168b9db', 'e7ea42c5-367b-48fb-9412-eb6ed3d5cc62', 'e9f4bd6b-604b-4826-b9df-1ca66d2fcb14', 'ea1cee90-e0ab-458f-9469-c206434664c0', 'ed5cd63a-6e22-41e8-9143-b8d8588f83dc', 'ef23f613-e034-430d-9045-629c26a103a3', 'efecabc5-628e-4b4a-b9ac-b87d37f87897', 'f04281a8-878a-4f27-9cd1-4294c8bbeecf', 'f07e3340-94a9-4b14-9f23-2fb10a22442f', 'f14149d6-2673-45a9-ab6d-5d79b367438b', 'f2010071-314d-434b-b418-fc87f63ded07', 'f2e202ca-9bc4-49fa-9e20-356782cbd4f6', 'f3c55098-5f51-41e8-83f3-631f8ed48cab', 'f607f753-609c-467c-bd96-181ece3990de', 'fd0dd9f0-4ea1-48d0-8a6a-74773dd1e518', '007bf86d-59ce-4e40-8e8c-fbdbf6d6550e', '00ff92fd-5c28-49a4-a65d-0f7b1d51efa8', '010cd59c-48c4-4e89-98f8-4acb1e2ff445') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

77. SELECT DISTINCT product_uuid FROM (SELECT t4pgo.product_uuid FROM tp_4over_product_group_option_master as t4pgo LEFT JOIN tp_4over_products as FP ON FP.product_uuid = t4pgo.product_uuid WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND FP.status = '1' AND FP.categories = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as product_data 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '04e349a7-2af1-4332-ae0d-5af407c9a279', '06bf338f-0d46-4a54-a869-a9c5b83787b9', '078db3e0-c8bc-492c-b933-ee28a80676d3', '08c209b7-89c9-4720-b74b-f65be7d6fcd6', '0951d79a-77cd-4d04-9ad4-68b60ab88615', '0aa1cfa6-f589-4551-9c30-ddcbe1f487a7', '0b1e1148-3df6-4438-a3fa-abc0ee8adaa2', '0f7c0e19-5bf9-40f7-ab5c-7b1f4bc8710f', '10e81946-686f-46b5-bb17-70c1c219f527', '1524a5c1-ca6a-459d-9f5c-2bc9e852e482', '1636f50b-3250-4f6a-8a98-9419df12f5cd', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '1e2668fc-d325-44cc-8ff6-4a94c28c1959', '1f7b6715-1e3e-438c-8929-d2de0fb6c81e', '1f824a91-d9eb-478e-86fe-010e880b8721', '1fcd785a-5ed1-4fa0-a560-adf244988e56', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '2222f69b-ebd6-4672-b21e-229197bba347', '238da98d-4e6d-440f-93e6-403b5f36e57d', '23dde635-ade1-4665-9dc7-c345bdaae17e', '24898ef7-7649-416d-936a-7a8d986c41bf', '2a220f64-b5b8-4f6f-a587-f3289c1636ff', '2b74a0dc-254b-4143-9c4e-088d3b8339b0', '2c8df5cb-ef0d-401f-b1ae-7673a94da64a', '2d69a570-6ca7-4985-be45-46d60a0bb7cd', '2df58931-1d47-4fa5-a051-8dca51b70edf', '2ee3a5b9-9acc-4270-a1ec-08a0dc77af77', '2ff5a36e-cc74-4a96-a011-1ffc144dee3c', '312a8d2f-e634-4f25-85e2-de96e4f560ee', '323fb851-be12-4316-a780-48457cac653f', '331a50da-fbe0-4da0-9357-93813fc17c72', '34eedfa5-350d-4ea9-b4f3-a33fdad6cd69', '36fa29e0-9314-4a83-be4b-4800e5744d50', '39fe1491-5155-43a9-bca8-238708dc8710', '3a449fbf-e70c-445c-baac-1f5c79ff49a5', '3a78b179-7d2b-467f-9547-8d8f0d22faa5', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '3db85f15-81fb-41b4-ad18-4faba24b07d3', '3f98b902-523d-433a-be70-54c8e6bb2411', '403dccc0-7ed0-4afb-86ca-0ee94f0b6e3b', '43e067b8-b9c6-4c7d-b66c-9ff7e428496d', '450b109c-91b8-47f3-8474-bd35a4fca006', '456c4994-0260-4aab-b1d6-42b6571f8bb8', '469a8376-4eca-4501-be07-e272c595ba89', '46a979f7-3f86-49ad-8b4f-f82e4e31d04d', '46ba4bc2-06b6-47ad-af24-f893f90fafb6', '47608d20-4556-4f17-876e-3a7f2fc2f22e', '483387d6-303d-4adb-ace1-259c4c86590e', '488a39f7-b5b6-4b66-b672-4ac4fb96a50f', '48a7eff0-5305-43cf-9c80-49b4fdae2a5e', '4e426769-9a62-41eb-baef-07e6e70fb036', '4ea37010-3302-494f-8ef6-61bdf17fe712', '4f50589e-ec9c-4a1c-830d-cd7f0a9db58d', '526bfeb2-08ff-4622-be31-42f4f21a9e98', '564b01e5-36f7-4773-8c7f-1d800ed351a1', '590ccf93-b27e-44a1-8143-5edacb956a6a', '5a125b29-f8da-4a0c-9aff-cea2d2ff81cf', '5d01fdd4-0ad0-441f-bc66-82e217605ede', '65e2c48a-0e2c-42fe-95f9-60e414eef25b', '68b2f921-04fe-46f3-a088-1e18cb8abcc0', '696f1384-7af1-4779-92ed-21af9ce24a4a', '6a59c15b-56be-4987-8a2f-3e086f6481fb', '6f3c5b57-5bb1-4d26-8b74-1632af74bd04', '7013c5c2-884c-4b02-9d3b-cb24ea0952b6', '7051a7f9-e085-43a7-958d-4afdc964ec78', '74e29a3c-6377-4339-8de4-5cee51466cad', '7828fe39-f456-48d3-bb10-f1fa42ad0125', '7a6e8717-0c37-4b9e-aad7-a4cd915549c9', '7a9d14f7-1320-4ca9-b00a-9f06b621c668', '7c5e3993-58cb-40c8-aafc-9a0e04d5f4eb', '7cd721a1-266a-4fcb-b2de-3ba603fbe57a', '7e3f612b-0567-4b27-8ec4-fe8f46ec5254', '7eb644a6-36fb-446e-8584-0c3c4b68d557', '8034aec6-50d4-4a6d-ad6e-4df2b692875b', '8085e484-651f-46fb-89e6-cbdef9ccbe13', '82c1e672-9985-436c-8651-5e7a9fb71b59', '82f2acef-85e9-465e-889e-9d3b02ef41c5', '83c33637-fdde-4bd8-b881-f5a0171df060', '84370b14-0315-443d-93b8-74bf955424a0', '853f8ab8-c19c-482c-972f-8dfc7cc31973', '865e44be-48fe-44e0-874a-654c23f2eb49', '87504265-912e-4ea3-9963-a6b6c3e3ce95', '87d78d1f-d7a3-4d17-b12d-b3e1711c2076', '8a7a67a2-3581-4ae9-900e-60be4b613c4d', '8c85e555-747a-4e10-ad4a-2412b5310d6e', '8eb96128-a4de-45aa-96cd-85098a67515b', '9027a4b5-e1d5-4d77-ada0-c8e717d20b96', '912f24c4-2a66-4d44-a361-9a64acf07e07', '913f160c-be3a-41bb-9a0c-88d213e137e4', '95ab0192-f7d3-458b-8570-5870c806adda', '95e0e8ae-1eea-4ef3-9476-5ffb56f68e46', '98841a08-8044-4902-80c4-bd3f337e98b2', '9ad05449-529d-426a-bb1c-a098e9cb32b3', '9fae5679-0aff-48d7-9de3-cdb1f8070cc3', '9fcacc66-568c-4b6f-9ece-c89ce6fe0ad7', 'a37d71a9-8b2b-4363-bddf-b166af848d2a', 'a3d5c3bc-fbf1-4dd1-b966-833d803cb9d3', 'a5ea7625-93da-44f7-9591-526b12cdd684', 'a6fa0055-b9c7-4af2-9f13-1782163ebe09', 'a74e0e93-fa8f-4cf2-a4bf-e91f3b0e7e15', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'a9702612-7a8f-429c-a862-d8d052ec9dba', 'aa761a27-8688-4284-bb99-75f3a637ae4c', 'aa836ad7-8354-4556-b9da-4816d0be8342', 'aac142ce-df6f-47c7-be00-6400aaedf507', 'b70cc108-727d-44d2-956d-3ebf3406cf4c', 'b8a4826c-0876-49c4-b079-117b44bab3c3', 'b8c1d39e-2d03-4736-9998-f9c5abc7e679', 'b8fb58d5-acff-4d3d-921e-2441606f5e88', 'b9706040-6bba-4e22-87d4-35f84b96dfd9', 'ba28ad3b-4ef4-4a1a-b62b-ed35a52c63d6', 'bf37568c-c4af-49ae-835e-adbb5fe9cd7d', 'c051b397-6356-405b-a575-b8a74e87b908', 'c06640fd-2fcc-44dc-9c19-8d49bdfae514', 'c0a720d1-05a8-412c-9c9f-14c4b23b1087', 'c2db05cd-f4b9-4403-9148-f51d17db4453', 'c85e1c28-41dd-46bb-8042-82c92d983693', 'c93c00a6-7072-4c78-a690-fa1ffb45c16c', 'c9d92115-5a04-4df3-b3c3-25710175eecc', 'ca482753-a3b3-406a-8d6c-4e0ecf348001', 'cc362691-13ec-4560-bba5-cd10293096ca', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'cce2438a-a283-4057-bebc-df3f3591be0c', 'cf7eacfb-9306-4001-9b67-f35d55554e51', 'd094551a-d95f-4aac-8381-06092a6e3d41', 'd20529fe-02fd-4f14-941f-d095ee140ade', 'd32c44ea-9470-43d0-a778-03b7e019b792', 'db5d08cc-eaa2-46df-ba65-bffece5360a1', 'de5f42c8-4963-4ba3-8f76-cc65bfb24f69', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'dfa37d9c-ed6b-4da8-bed5-af51133fc15b', 'dfc6f51d-5d92-4c8c-b6d5-31b0e10be3af', 'dfe0f8ac-67f1-455e-b012-bd1bbf19e9b5', 'e5284f2f-77d0-4741-af35-f972587ed3ea', 'e5810dae-c9d2-4d99-9617-0e312168b9db', 'e7ea42c5-367b-48fb-9412-eb6ed3d5cc62', 'e9f4bd6b-604b-4826-b9df-1ca66d2fcb14', 'ea1cee90-e0ab-458f-9469-c206434664c0', 'ed5cd63a-6e22-41e8-9143-b8d8588f83dc', 'ef23f613-e034-430d-9045-629c26a103a3', 'efecabc5-628e-4b4a-b9ac-b87d37f87897', 'f04281a8-878a-4f27-9cd1-4294c8bbeecf', 'f07e3340-94a9-4b14-9f23-2fb10a22442f', 'f14149d6-2673-45a9-ab6d-5d79b367438b', 'f2010071-314d-434b-b418-fc87f63ded07', 'f2e202ca-9bc4-49fa-9e20-356782cbd4f6', 'f3c55098-5f51-41e8-83f3-631f8ed48cab', 'f607f753-609c-467c-bd96-181ece3990de', 'fd0dd9f0-4ea1-48d0-8a6a-74773dd1e518', '007bf86d-59ce-4e40-8e8c-fbdbf6d6550e', '00ff92fd-5c28-49a4-a65d-0f7b1d51efa8', '010cd59c-48c4-4e89-98f8-4acb1e2ff445') AND FP.categories = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' 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 ('007bf86d-59ce-4e40-8e8c-fbdbf6d6550e', '00ff92fd-5c28-49a4-a65d-0f7b1d51efa8', '010cd59c-48c4-4e89-98f8-4acb1e2ff445', '04e349a7-2af1-4332-ae0d-5af407c9a279', '06bf338f-0d46-4a54-a869-a9c5b83787b9', '078db3e0-c8bc-492c-b933-ee28a80676d3', '08c209b7-89c9-4720-b74b-f65be7d6fcd6', '0951d79a-77cd-4d04-9ad4-68b60ab88615', '0aa1cfa6-f589-4551-9c30-ddcbe1f487a7', '0b1e1148-3df6-4438-a3fa-abc0ee8adaa2', '0f7c0e19-5bf9-40f7-ab5c-7b1f4bc8710f', '104ce900-6cf2-4e76-85cb-7452b649aa0a', '10e81946-686f-46b5-bb17-70c1c219f527', '1524a5c1-ca6a-459d-9f5c-2bc9e852e482', '1636f50b-3250-4f6a-8a98-9419df12f5cd', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '1e2668fc-d325-44cc-8ff6-4a94c28c1959', '1f7b6715-1e3e-438c-8929-d2de0fb6c81e', '1f824a91-d9eb-478e-86fe-010e880b8721', '1fcd785a-5ed1-4fa0-a560-adf244988e56', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '2222f69b-ebd6-4672-b21e-229197bba347', '238da98d-4e6d-440f-93e6-403b5f36e57d', '23dde635-ade1-4665-9dc7-c345bdaae17e', '24898ef7-7649-416d-936a-7a8d986c41bf', '2a220f64-b5b8-4f6f-a587-f3289c1636ff', '2b74a0dc-254b-4143-9c4e-088d3b8339b0', '2c8df5cb-ef0d-401f-b1ae-7673a94da64a', '2d69a570-6ca7-4985-be45-46d60a0bb7cd', '2df58931-1d47-4fa5-a051-8dca51b70edf', '2ee3a5b9-9acc-4270-a1ec-08a0dc77af77', '2ff5a36e-cc74-4a96-a011-1ffc144dee3c', '312a8d2f-e634-4f25-85e2-de96e4f560ee', '323fb851-be12-4316-a780-48457cac653f', '331a50da-fbe0-4da0-9357-93813fc17c72', '34eedfa5-350d-4ea9-b4f3-a33fdad6cd69', '36fa29e0-9314-4a83-be4b-4800e5744d50', '39fe1491-5155-43a9-bca8-238708dc8710', '3a449fbf-e70c-445c-baac-1f5c79ff49a5', '3a78b179-7d2b-467f-9547-8d8f0d22faa5', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '3db85f15-81fb-41b4-ad18-4faba24b07d3', '3f98b902-523d-433a-be70-54c8e6bb2411', '403dccc0-7ed0-4afb-86ca-0ee94f0b6e3b', '43e067b8-b9c6-4c7d-b66c-9ff7e428496d', '450b109c-91b8-47f3-8474-bd35a4fca006', '456c4994-0260-4aab-b1d6-42b6571f8bb8', '469a8376-4eca-4501-be07-e272c595ba89', '46a979f7-3f86-49ad-8b4f-f82e4e31d04d', '46ba4bc2-06b6-47ad-af24-f893f90fafb6', '47608d20-4556-4f17-876e-3a7f2fc2f22e', '483387d6-303d-4adb-ace1-259c4c86590e', '488a39f7-b5b6-4b66-b672-4ac4fb96a50f', '48a7eff0-5305-43cf-9c80-49b4fdae2a5e', '4e426769-9a62-41eb-baef-07e6e70fb036', '4ea37010-3302-494f-8ef6-61bdf17fe712', '4f50589e-ec9c-4a1c-830d-cd7f0a9db58d', '526bfeb2-08ff-4622-be31-42f4f21a9e98', '564b01e5-36f7-4773-8c7f-1d800ed351a1', '590ccf93-b27e-44a1-8143-5edacb956a6a', '5a125b29-f8da-4a0c-9aff-cea2d2ff81cf', '5d01fdd4-0ad0-441f-bc66-82e217605ede', '65e2c48a-0e2c-42fe-95f9-60e414eef25b', '68b2f921-04fe-46f3-a088-1e18cb8abcc0', '696f1384-7af1-4779-92ed-21af9ce24a4a', '6a59c15b-56be-4987-8a2f-3e086f6481fb', '6f3c5b57-5bb1-4d26-8b74-1632af74bd04', '7013c5c2-884c-4b02-9d3b-cb24ea0952b6', '7051a7f9-e085-43a7-958d-4afdc964ec78', '74e29a3c-6377-4339-8de4-5cee51466cad', '7828fe39-f456-48d3-bb10-f1fa42ad0125', '7a6e8717-0c37-4b9e-aad7-a4cd915549c9', '7a9d14f7-1320-4ca9-b00a-9f06b621c668', '7c5e3993-58cb-40c8-aafc-9a0e04d5f4eb', '7cd721a1-266a-4fcb-b2de-3ba603fbe57a', '7e3f612b-0567-4b27-8ec4-fe8f46ec5254', '7eb644a6-36fb-446e-8584-0c3c4b68d557', '8034aec6-50d4-4a6d-ad6e-4df2b692875b', '8085e484-651f-46fb-89e6-cbdef9ccbe13', '82c1e672-9985-436c-8651-5e7a9fb71b59', '82f2acef-85e9-465e-889e-9d3b02ef41c5', '83c33637-fdde-4bd8-b881-f5a0171df060', '84370b14-0315-443d-93b8-74bf955424a0', '853f8ab8-c19c-482c-972f-8dfc7cc31973', '865e44be-48fe-44e0-874a-654c23f2eb49', '87504265-912e-4ea3-9963-a6b6c3e3ce95', '87d78d1f-d7a3-4d17-b12d-b3e1711c2076', '8a7a67a2-3581-4ae9-900e-60be4b613c4d', '8c85e555-747a-4e10-ad4a-2412b5310d6e', '8eb96128-a4de-45aa-96cd-85098a67515b', '9027a4b5-e1d5-4d77-ada0-c8e717d20b96', '912f24c4-2a66-4d44-a361-9a64acf07e07', '913f160c-be3a-41bb-9a0c-88d213e137e4', '95ab0192-f7d3-458b-8570-5870c806adda', '95e0e8ae-1eea-4ef3-9476-5ffb56f68e46', '98841a08-8044-4902-80c4-bd3f337e98b2', '9ad05449-529d-426a-bb1c-a098e9cb32b3', '9fae5679-0aff-48d7-9de3-cdb1f8070cc3', '9fcacc66-568c-4b6f-9ece-c89ce6fe0ad7', 'a37d71a9-8b2b-4363-bddf-b166af848d2a', 'a3d5c3bc-fbf1-4dd1-b966-833d803cb9d3', 'a5ea7625-93da-44f7-9591-526b12cdd684', 'a6fa0055-b9c7-4af2-9f13-1782163ebe09', 'a74e0e93-fa8f-4cf2-a4bf-e91f3b0e7e15', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'a9702612-7a8f-429c-a862-d8d052ec9dba', 'aa761a27-8688-4284-bb99-75f3a637ae4c', 'aa836ad7-8354-4556-b9da-4816d0be8342', 'aac142ce-df6f-47c7-be00-6400aaedf507', 'b70cc108-727d-44d2-956d-3ebf3406cf4c', 'b8a4826c-0876-49c4-b079-117b44bab3c3', 'b8c1d39e-2d03-4736-9998-f9c5abc7e679', 'b8fb58d5-acff-4d3d-921e-2441606f5e88', 'b9706040-6bba-4e22-87d4-35f84b96dfd9', 'ba28ad3b-4ef4-4a1a-b62b-ed35a52c63d6', 'bf37568c-c4af-49ae-835e-adbb5fe9cd7d', 'c051b397-6356-405b-a575-b8a74e87b908', 'c06640fd-2fcc-44dc-9c19-8d49bdfae514', 'c0a720d1-05a8-412c-9c9f-14c4b23b1087', 'c2db05cd-f4b9-4403-9148-f51d17db4453', 'c85e1c28-41dd-46bb-8042-82c92d983693', 'c93c00a6-7072-4c78-a690-fa1ffb45c16c', 'c9d92115-5a04-4df3-b3c3-25710175eecc', 'ca482753-a3b3-406a-8d6c-4e0ecf348001', 'cc362691-13ec-4560-bba5-cd10293096ca', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'cce2438a-a283-4057-bebc-df3f3591be0c', 'cf7eacfb-9306-4001-9b67-f35d55554e51', 'd094551a-d95f-4aac-8381-06092a6e3d41', 'd20529fe-02fd-4f14-941f-d095ee140ade', 'd32c44ea-9470-43d0-a778-03b7e019b792', 'db5d08cc-eaa2-46df-ba65-bffece5360a1', 'de5f42c8-4963-4ba3-8f76-cc65bfb24f69', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'dfa37d9c-ed6b-4da8-bed5-af51133fc15b', 'dfc6f51d-5d92-4c8c-b6d5-31b0e10be3af', 'dfe0f8ac-67f1-455e-b012-bd1bbf19e9b5', 'e5284f2f-77d0-4741-af35-f972587ed3ea', 'e5810dae-c9d2-4d99-9617-0e312168b9db', 'e7ea42c5-367b-48fb-9412-eb6ed3d5cc62', 'e9f4bd6b-604b-4826-b9df-1ca66d2fcb14', 'ea1cee90-e0ab-458f-9469-c206434664c0', 'ed5cd63a-6e22-41e8-9143-b8d8588f83dc', 'ef23f613-e034-430d-9045-629c26a103a3', 'efecabc5-628e-4b4a-b9ac-b87d37f87897', 'f04281a8-878a-4f27-9cd1-4294c8bbeecf', 'f07e3340-94a9-4b14-9f23-2fb10a22442f', 'f14149d6-2673-45a9-ab6d-5d79b367438b', 'f2010071-314d-434b-b418-fc87f63ded07', 'f2e202ca-9bc4-49fa-9e20-356782cbd4f6', 'f3c55098-5f51-41e8-83f3-631f8ed48cab', 'f607f753-609c-467c-bd96-181ece3990de', 'fd0dd9f0-4ea1-48d0-8a6a-74773dd1e518') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P2 ON (P1.pid_1 = P2.pid_2) sec

81. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '04e349a7-2af1-4332-ae0d-5af407c9a279', '06bf338f-0d46-4a54-a869-a9c5b83787b9', '078db3e0-c8bc-492c-b933-ee28a80676d3', '08c209b7-89c9-4720-b74b-f65be7d6fcd6', '0951d79a-77cd-4d04-9ad4-68b60ab88615', '0aa1cfa6-f589-4551-9c30-ddcbe1f487a7', '0b1e1148-3df6-4438-a3fa-abc0ee8adaa2', '10e81946-686f-46b5-bb17-70c1c219f527', '1524a5c1-ca6a-459d-9f5c-2bc9e852e482', '1636f50b-3250-4f6a-8a98-9419df12f5cd', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '1e2668fc-d325-44cc-8ff6-4a94c28c1959', '1f7b6715-1e3e-438c-8929-d2de0fb6c81e', '1fcd785a-5ed1-4fa0-a560-adf244988e56', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '2222f69b-ebd6-4672-b21e-229197bba347', '238da98d-4e6d-440f-93e6-403b5f36e57d', '23dde635-ade1-4665-9dc7-c345bdaae17e', '24898ef7-7649-416d-936a-7a8d986c41bf', '2a220f64-b5b8-4f6f-a587-f3289c1636ff', '2b74a0dc-254b-4143-9c4e-088d3b8339b0', '2c8df5cb-ef0d-401f-b1ae-7673a94da64a', '2d69a570-6ca7-4985-be45-46d60a0bb7cd', '2ee3a5b9-9acc-4270-a1ec-08a0dc77af77', '2ff5a36e-cc74-4a96-a011-1ffc144dee3c', '312a8d2f-e634-4f25-85e2-de96e4f560ee', '323fb851-be12-4316-a780-48457cac653f', '331a50da-fbe0-4da0-9357-93813fc17c72', '34eedfa5-350d-4ea9-b4f3-a33fdad6cd69', '39fe1491-5155-43a9-bca8-238708dc8710', '3a449fbf-e70c-445c-baac-1f5c79ff49a5', '3a78b179-7d2b-467f-9547-8d8f0d22faa5', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '3db85f15-81fb-41b4-ad18-4faba24b07d3', '3f98b902-523d-433a-be70-54c8e6bb2411', '403dccc0-7ed0-4afb-86ca-0ee94f0b6e3b', '43e067b8-b9c6-4c7d-b66c-9ff7e428496d', '450b109c-91b8-47f3-8474-bd35a4fca006', '469a8376-4eca-4501-be07-e272c595ba89', '46a979f7-3f86-49ad-8b4f-f82e4e31d04d', '46ba4bc2-06b6-47ad-af24-f893f90fafb6', '47608d20-4556-4f17-876e-3a7f2fc2f22e', '483387d6-303d-4adb-ace1-259c4c86590e', '48a7eff0-5305-43cf-9c80-49b4fdae2a5e', '4e426769-9a62-41eb-baef-07e6e70fb036', '4ea37010-3302-494f-8ef6-61bdf17fe712', '4f50589e-ec9c-4a1c-830d-cd7f0a9db58d', '526bfeb2-08ff-4622-be31-42f4f21a9e98', '564b01e5-36f7-4773-8c7f-1d800ed351a1', '590ccf93-b27e-44a1-8143-5edacb956a6a', '5a125b29-f8da-4a0c-9aff-cea2d2ff81cf', '5be64be6-c076-4289-b1d1-d90867b03551', '5d01fdd4-0ad0-441f-bc66-82e217605ede', '65e2c48a-0e2c-42fe-95f9-60e414eef25b', '6805e6a8-86c9-4a26-899f-d1f2e7003fa4', '68b2f921-04fe-46f3-a088-1e18cb8abcc0', '696f1384-7af1-4779-92ed-21af9ce24a4a', '6a59c15b-56be-4987-8a2f-3e086f6481fb', '6b8ba711-ce3a-416c-9e3e-7a3f1b4da4d2', '6c393fe3-b520-4919-ab43-7e65c85491af', '6d420cc9-8a1d-4b84-b02c-af5b83a5e18a', '6d537dd9-d689-4ccd-a328-7c3254abaea9', '6f4b583e-2650-49f6-a62a-3d5474eb89ac', '7013c5c2-884c-4b02-9d3b-cb24ea0952b6', '7051a7f9-e085-43a7-958d-4afdc964ec78', '74e29a3c-6377-4339-8de4-5cee51466cad', '7828fe39-f456-48d3-bb10-f1fa42ad0125', '7a6e8717-0c37-4b9e-aad7-a4cd915549c9', '7a9d14f7-1320-4ca9-b00a-9f06b621c668', '7c5e3993-58cb-40c8-aafc-9a0e04d5f4eb', '7cd721a1-266a-4fcb-b2de-3ba603fbe57a', '7e3f612b-0567-4b27-8ec4-fe8f46ec5254', '7eb644a6-36fb-446e-8584-0c3c4b68d557', '8034aec6-50d4-4a6d-ad6e-4df2b692875b', '8085e484-651f-46fb-89e6-cbdef9ccbe13', '82f2acef-85e9-465e-889e-9d3b02ef41c5', '83c33637-fdde-4bd8-b881-f5a0171df060', '84370b14-0315-443d-93b8-74bf955424a0', '865e44be-48fe-44e0-874a-654c23f2eb49', '87504265-912e-4ea3-9963-a6b6c3e3ce95', '87d78d1f-d7a3-4d17-b12d-b3e1711c2076', '8a7a67a2-3581-4ae9-900e-60be4b613c4d', '8c85e555-747a-4e10-ad4a-2412b5310d6e', '8eb96128-a4de-45aa-96cd-85098a67515b', '9027a4b5-e1d5-4d77-ada0-c8e717d20b96', '912f24c4-2a66-4d44-a361-9a64acf07e07', '913f160c-be3a-41bb-9a0c-88d213e137e4', '95ab0192-f7d3-458b-8570-5870c806adda', '95e0e8ae-1eea-4ef3-9476-5ffb56f68e46', '98841a08-8044-4902-80c4-bd3f337e98b2', '9ad05449-529d-426a-bb1c-a098e9cb32b3', '9fae5679-0aff-48d7-9de3-cdb1f8070cc3', '9fcacc66-568c-4b6f-9ece-c89ce6fe0ad7', 'a37d71a9-8b2b-4363-bddf-b166af848d2a', 'a3d5c3bc-fbf1-4dd1-b966-833d803cb9d3', 'a5ea7625-93da-44f7-9591-526b12cdd684', 'a74e0e93-fa8f-4cf2-a4bf-e91f3b0e7e15', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'a9702612-7a8f-429c-a862-d8d052ec9dba', 'aa761a27-8688-4284-bb99-75f3a637ae4c', 'aa836ad7-8354-4556-b9da-4816d0be8342', 'aac142ce-df6f-47c7-be00-6400aaedf507', 'b8a4826c-0876-49c4-b079-117b44bab3c3', 'b8fb58d5-acff-4d3d-921e-2441606f5e88', 'b9706040-6bba-4e22-87d4-35f84b96dfd9', 'ba28ad3b-4ef4-4a1a-b62b-ed35a52c63d6', 'bf37568c-c4af-49ae-835e-adbb5fe9cd7d', 'c051b397-6356-405b-a575-b8a74e87b908', 'c06640fd-2fcc-44dc-9c19-8d49bdfae514', 'c0a720d1-05a8-412c-9c9f-14c4b23b1087', 'c2db05cd-f4b9-4403-9148-f51d17db4453', 'c85e1c28-41dd-46bb-8042-82c92d983693', 'c93c00a6-7072-4c78-a690-fa1ffb45c16c', 'c9d92115-5a04-4df3-b3c3-25710175eecc', 'ca482753-a3b3-406a-8d6c-4e0ecf348001', 'cc362691-13ec-4560-bba5-cd10293096ca', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'cce2438a-a283-4057-bebc-df3f3591be0c', 'cf7eacfb-9306-4001-9b67-f35d55554e51', 'd094551a-d95f-4aac-8381-06092a6e3d41', 'd20529fe-02fd-4f14-941f-d095ee140ade', 'd32c44ea-9470-43d0-a778-03b7e019b792', 'db5d08cc-eaa2-46df-ba65-bffece5360a1', 'de5f42c8-4963-4ba3-8f76-cc65bfb24f69', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'dfa37d9c-ed6b-4da8-bed5-af51133fc15b', 'dfc6f51d-5d92-4c8c-b6d5-31b0e10be3af', 'dfe0f8ac-67f1-455e-b012-bd1bbf19e9b5', 'e5284f2f-77d0-4741-af35-f972587ed3ea', 'e5810dae-c9d2-4d99-9617-0e312168b9db', 'e7ea42c5-367b-48fb-9412-eb6ed3d5cc62', 'e9f4bd6b-604b-4826-b9df-1ca66d2fcb14', 'ea1cee90-e0ab-458f-9469-c206434664c0', 'ed5cd63a-6e22-41e8-9143-b8d8588f83dc', 'ef23f613-e034-430d-9045-629c26a103a3', 'efecabc5-628e-4b4a-b9ac-b87d37f87897', 'f04281a8-878a-4f27-9cd1-4294c8bbeecf', 'f07e3340-94a9-4b14-9f23-2fb10a22442f', 'f14149d6-2673-45a9-ab6d-5d79b367438b', 'f2010071-314d-434b-b418-fc87f63ded07', 'f2e202ca-9bc4-49fa-9e20-356782cbd4f6', 'f3c55098-5f51-41e8-83f3-631f8ed48cab', 'f607f753-609c-467c-bd96-181ece3990de', 'fd0dd9f0-4ea1-48d0-8a6a-74773dd1e518', '007bf86d-59ce-4e40-8e8c-fbdbf6d6550e', '00ff92fd-5c28-49a4-a65d-0f7b1d51efa8', '010cd59c-48c4-4e89-98f8-4acb1e2ff445') AND FP.categories = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

82. 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 ('007bf86d-59ce-4e40-8e8c-fbdbf6d6550e', '00ff92fd-5c28-49a4-a65d-0f7b1d51efa8', '010cd59c-48c4-4e89-98f8-4acb1e2ff445', '04e349a7-2af1-4332-ae0d-5af407c9a279', '06bf338f-0d46-4a54-a869-a9c5b83787b9', '078db3e0-c8bc-492c-b933-ee28a80676d3', '08c209b7-89c9-4720-b74b-f65be7d6fcd6', '0951d79a-77cd-4d04-9ad4-68b60ab88615', '0aa1cfa6-f589-4551-9c30-ddcbe1f487a7', '0b1e1148-3df6-4438-a3fa-abc0ee8adaa2', '104ce900-6cf2-4e76-85cb-7452b649aa0a', '10e81946-686f-46b5-bb17-70c1c219f527', '1524a5c1-ca6a-459d-9f5c-2bc9e852e482', '1636f50b-3250-4f6a-8a98-9419df12f5cd', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '1e2668fc-d325-44cc-8ff6-4a94c28c1959', '1f7b6715-1e3e-438c-8929-d2de0fb6c81e', '1fcd785a-5ed1-4fa0-a560-adf244988e56', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '2222f69b-ebd6-4672-b21e-229197bba347', '238da98d-4e6d-440f-93e6-403b5f36e57d', '23dde635-ade1-4665-9dc7-c345bdaae17e', '24898ef7-7649-416d-936a-7a8d986c41bf', '2a220f64-b5b8-4f6f-a587-f3289c1636ff', '2b74a0dc-254b-4143-9c4e-088d3b8339b0', '2c8df5cb-ef0d-401f-b1ae-7673a94da64a', '2d69a570-6ca7-4985-be45-46d60a0bb7cd', '2ee3a5b9-9acc-4270-a1ec-08a0dc77af77', '2ff5a36e-cc74-4a96-a011-1ffc144dee3c', '312a8d2f-e634-4f25-85e2-de96e4f560ee', '323fb851-be12-4316-a780-48457cac653f', '331a50da-fbe0-4da0-9357-93813fc17c72', '34eedfa5-350d-4ea9-b4f3-a33fdad6cd69', '39fe1491-5155-43a9-bca8-238708dc8710', '3a449fbf-e70c-445c-baac-1f5c79ff49a5', '3a78b179-7d2b-467f-9547-8d8f0d22faa5', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '3db85f15-81fb-41b4-ad18-4faba24b07d3', '3f98b902-523d-433a-be70-54c8e6bb2411', '403dccc0-7ed0-4afb-86ca-0ee94f0b6e3b', '43e067b8-b9c6-4c7d-b66c-9ff7e428496d', '450b109c-91b8-47f3-8474-bd35a4fca006', '469a8376-4eca-4501-be07-e272c595ba89', '46a979f7-3f86-49ad-8b4f-f82e4e31d04d', '46ba4bc2-06b6-47ad-af24-f893f90fafb6', '47608d20-4556-4f17-876e-3a7f2fc2f22e', '483387d6-303d-4adb-ace1-259c4c86590e', '48a7eff0-5305-43cf-9c80-49b4fdae2a5e', '4e426769-9a62-41eb-baef-07e6e70fb036', '4ea37010-3302-494f-8ef6-61bdf17fe712', '4f50589e-ec9c-4a1c-830d-cd7f0a9db58d', '526bfeb2-08ff-4622-be31-42f4f21a9e98', '564b01e5-36f7-4773-8c7f-1d800ed351a1', '590ccf93-b27e-44a1-8143-5edacb956a6a', '5a125b29-f8da-4a0c-9aff-cea2d2ff81cf', '5d01fdd4-0ad0-441f-bc66-82e217605ede', '65e2c48a-0e2c-42fe-95f9-60e414eef25b', '68b2f921-04fe-46f3-a088-1e18cb8abcc0', '696f1384-7af1-4779-92ed-21af9ce24a4a', '6a59c15b-56be-4987-8a2f-3e086f6481fb', '7013c5c2-884c-4b02-9d3b-cb24ea0952b6', '7051a7f9-e085-43a7-958d-4afdc964ec78', '74e29a3c-6377-4339-8de4-5cee51466cad', '7828fe39-f456-48d3-bb10-f1fa42ad0125', '7a6e8717-0c37-4b9e-aad7-a4cd915549c9', '7a9d14f7-1320-4ca9-b00a-9f06b621c668', '7c5e3993-58cb-40c8-aafc-9a0e04d5f4eb', '7cd721a1-266a-4fcb-b2de-3ba603fbe57a', '7e3f612b-0567-4b27-8ec4-fe8f46ec5254', '7eb644a6-36fb-446e-8584-0c3c4b68d557', '8034aec6-50d4-4a6d-ad6e-4df2b692875b', '8085e484-651f-46fb-89e6-cbdef9ccbe13', '82f2acef-85e9-465e-889e-9d3b02ef41c5', '83c33637-fdde-4bd8-b881-f5a0171df060', '84370b14-0315-443d-93b8-74bf955424a0', '865e44be-48fe-44e0-874a-654c23f2eb49', '87504265-912e-4ea3-9963-a6b6c3e3ce95', '87d78d1f-d7a3-4d17-b12d-b3e1711c2076', '8a7a67a2-3581-4ae9-900e-60be4b613c4d', '8c85e555-747a-4e10-ad4a-2412b5310d6e', '8eb96128-a4de-45aa-96cd-85098a67515b', '9027a4b5-e1d5-4d77-ada0-c8e717d20b96', '912f24c4-2a66-4d44-a361-9a64acf07e07', '913f160c-be3a-41bb-9a0c-88d213e137e4', '95ab0192-f7d3-458b-8570-5870c806adda', '95e0e8ae-1eea-4ef3-9476-5ffb56f68e46', '98841a08-8044-4902-80c4-bd3f337e98b2', '9ad05449-529d-426a-bb1c-a098e9cb32b3', '9fae5679-0aff-48d7-9de3-cdb1f8070cc3', '9fcacc66-568c-4b6f-9ece-c89ce6fe0ad7', 'a37d71a9-8b2b-4363-bddf-b166af848d2a', 'a3d5c3bc-fbf1-4dd1-b966-833d803cb9d3', 'a5ea7625-93da-44f7-9591-526b12cdd684', 'a74e0e93-fa8f-4cf2-a4bf-e91f3b0e7e15', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'a9702612-7a8f-429c-a862-d8d052ec9dba', 'aa761a27-8688-4284-bb99-75f3a637ae4c', 'aa836ad7-8354-4556-b9da-4816d0be8342', 'aac142ce-df6f-47c7-be00-6400aaedf507', 'b8a4826c-0876-49c4-b079-117b44bab3c3', 'b8fb58d5-acff-4d3d-921e-2441606f5e88', 'b9706040-6bba-4e22-87d4-35f84b96dfd9', 'ba28ad3b-4ef4-4a1a-b62b-ed35a52c63d6', 'bf37568c-c4af-49ae-835e-adbb5fe9cd7d', 'c051b397-6356-405b-a575-b8a74e87b908', 'c06640fd-2fcc-44dc-9c19-8d49bdfae514', 'c0a720d1-05a8-412c-9c9f-14c4b23b1087', 'c2db05cd-f4b9-4403-9148-f51d17db4453', 'c85e1c28-41dd-46bb-8042-82c92d983693', 'c93c00a6-7072-4c78-a690-fa1ffb45c16c', 'c9d92115-5a04-4df3-b3c3-25710175eecc', 'ca482753-a3b3-406a-8d6c-4e0ecf348001', 'cc362691-13ec-4560-bba5-cd10293096ca', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'cce2438a-a283-4057-bebc-df3f3591be0c', 'cf7eacfb-9306-4001-9b67-f35d55554e51', 'd094551a-d95f-4aac-8381-06092a6e3d41', 'd20529fe-02fd-4f14-941f-d095ee140ade', 'd32c44ea-9470-43d0-a778-03b7e019b792', 'db5d08cc-eaa2-46df-ba65-bffece5360a1', 'de5f42c8-4963-4ba3-8f76-cc65bfb24f69', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'dfa37d9c-ed6b-4da8-bed5-af51133fc15b', 'dfc6f51d-5d92-4c8c-b6d5-31b0e10be3af', 'dfe0f8ac-67f1-455e-b012-bd1bbf19e9b5', 'e5284f2f-77d0-4741-af35-f972587ed3ea', 'e5810dae-c9d2-4d99-9617-0e312168b9db', 'e7ea42c5-367b-48fb-9412-eb6ed3d5cc62', 'e9f4bd6b-604b-4826-b9df-1ca66d2fcb14', 'ea1cee90-e0ab-458f-9469-c206434664c0', 'ed5cd63a-6e22-41e8-9143-b8d8588f83dc', 'ef23f613-e034-430d-9045-629c26a103a3', 'efecabc5-628e-4b4a-b9ac-b87d37f87897', 'f04281a8-878a-4f27-9cd1-4294c8bbeecf', 'f07e3340-94a9-4b14-9f23-2fb10a22442f', 'f14149d6-2673-45a9-ab6d-5d79b367438b', 'f2010071-314d-434b-b418-fc87f63ded07', 'f2e202ca-9bc4-49fa-9e20-356782cbd4f6', 'f3c55098-5f51-41e8-83f3-631f8ed48cab', 'f607f753-609c-467c-bd96-181ece3990de', 'fd0dd9f0-4ea1-48d0-8a6a-74773dd1e518') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

83. SELECT size_id,tp4over_size_title FROM tp_4over_ops_size_mapping WHERE ops_product_id =385 sec

84. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P3 ON (P1.pid_1 = P2.pid_2) AND (P1.pid_1 = P3.pid_3) AND (P2.pid_2 = P3.pid_3) sec

85. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '450b109c-91b8-47f3-8474-bd35a4fca006', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'f14149d6-2673-45a9-ab6d-5d79b367438b') AND FP.categories = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

86. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '450b109c-91b8-47f3-8474-bd35a4fca006', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'f14149d6-2673-45a9-ab6d-5d79b367438b') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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

88 86. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '200fd0ca-de2c-4d89-8576-3214bb3b72bd', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', '450b109c-91b8-47f3-8474-bd35a4fca006', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'cc4133ff-c9e5-44fc-bd29-0ebb5e918b89', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'f14149d6-2673-45a9-ab6d-5d79b367438b') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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

90. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'f14149d6-2673-45a9-ab6d-5d79b367438b') AND FP.categories = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

91. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a', '1c868874-e4e8-4ed3-9a26-ae2c586bae69', '3aab6c02-335b-4e13-bc6c-8dc1cd79155a', 'a7bdbca4-b55f-4dfc-840a-6edfa22507af', 'deb402f6-aabe-4745-9448-5836706b5f4f', 'f14149d6-2673-45a9-ab6d-5d79b367438b') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

92. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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

93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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

95 93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

96. SELECT colorspec_uuid FROM tp_product_price WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') GROUP BY colorspec_uuid 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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

98 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

99 93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

100. SELECT DISTINCT pid_1 FROM (SELECT t4pgo.product_uuid as pid_1 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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

101 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

102 93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

103. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'd864aba7-b3ca-439d-9401-4bf4987f152c' AND t4pgo.option_uuid = '16ebe401-5398-422d-8cb0-f3adbb82deb5' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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

104 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

105 93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

106. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'd864aba7-b3ca-439d-9401-4bf4987f152c' AND t4pgo.option_uuid = '16ebe401-5398-422d-8cb0-f3adbb82deb5' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '17fc2260-9acc-405d-9fc7-3ef3ac293b09' AND t4pgo.option_uuid = '70efd00a-4e8b-432e-9864-fa4d50318d72' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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

107 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

108 93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

109. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'd864aba7-b3ca-439d-9401-4bf4987f152c' AND t4pgo.option_uuid = '16ebe401-5398-422d-8cb0-f3adbb82deb5' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '17fc2260-9acc-405d-9fc7-3ef3ac293b09' AND t4pgo.option_uuid = '70efd00a-4e8b-432e-9864-fa4d50318d72' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P11 INNER JOIN (SELECT t4pgo.product_uuid as pid_12 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '254afeea-1fd1-4efb-b5fb-c9c3bf4c13d2' AND t4pgo.option_uuid = '58689abb-25c0-461c-a4c3-a80b627d6649' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P12 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 (P1.pid_1 = P12.pid_12) 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 (P2.pid_2 = P12.pid_12) 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 (P3.pid_3 = P12.pid_12) 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 (P4.pid_4 = P12.pid_12) 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 (P5.pid_5 = P12.pid_12) 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 (P6.pid_6 = P12.pid_12) 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 (P7.pid_7 = P12.pid_12) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P8.pid_8 = P11.pid_11) AND (P8.pid_8 = P12.pid_12) AND (P9.pid_9 = P10.pid_10) AND (P9.pid_9 = P11.pid_11) AND (P9.pid_9 = P12.pid_12) AND (P10.pid_10 = P11.pid_11) AND (P10.pid_10 = P12.pid_12) AND (P11.pid_11 = P12.pid_12) sec

110 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

111 93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

112. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'd864aba7-b3ca-439d-9401-4bf4987f152c' AND t4pgo.option_uuid = '16ebe401-5398-422d-8cb0-f3adbb82deb5' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '17fc2260-9acc-405d-9fc7-3ef3ac293b09' AND t4pgo.option_uuid = '70efd00a-4e8b-432e-9864-fa4d50318d72' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P11 INNER JOIN (SELECT t4pgo.product_uuid as pid_12 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '254afeea-1fd1-4efb-b5fb-c9c3bf4c13d2' AND t4pgo.option_uuid = '58689abb-25c0-461c-a4c3-a80b627d6649' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P12 INNER JOIN (SELECT t4pgo.product_uuid as pid_13 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '05d933cb-0474-4e5a-bece-42504c6860fd' AND t4pgo.option_uuid = '3e5e9bdd-d78a-4c28-a41d-fe1407925ca6' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P13 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 (P1.pid_1 = P12.pid_12) AND (P1.pid_1 = P13.pid_13) 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 (P2.pid_2 = P12.pid_12) AND (P2.pid_2 = P13.pid_13) 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 (P3.pid_3 = P12.pid_12) AND (P3.pid_3 = P13.pid_13) 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 (P4.pid_4 = P12.pid_12) AND (P4.pid_4 = P13.pid_13) 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 (P5.pid_5 = P12.pid_12) AND (P5.pid_5 = P13.pid_13) 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 (P6.pid_6 = P12.pid_12) AND (P6.pid_6 = P13.pid_13) 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 (P7.pid_7 = P12.pid_12) AND (P7.pid_7 = P13.pid_13) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P8.pid_8 = P11.pid_11) AND (P8.pid_8 = P12.pid_12) AND (P8.pid_8 = P13.pid_13) AND (P9.pid_9 = P10.pid_10) AND (P9.pid_9 = P11.pid_11) AND (P9.pid_9 = P12.pid_12) AND (P9.pid_9 = P13.pid_13) AND (P10.pid_10 = P11.pid_11) AND (P10.pid_10 = P12.pid_12) AND (P10.pid_10 = P13.pid_13) AND (P11.pid_11 = P12.pid_12) AND (P11.pid_11 = P13.pid_13) AND (P12.pid_12 = P13.pid_13) sec

113 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

114 93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

115. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'd864aba7-b3ca-439d-9401-4bf4987f152c' AND t4pgo.option_uuid = '16ebe401-5398-422d-8cb0-f3adbb82deb5' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '17fc2260-9acc-405d-9fc7-3ef3ac293b09' AND t4pgo.option_uuid = '70efd00a-4e8b-432e-9864-fa4d50318d72' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P11 INNER JOIN (SELECT t4pgo.product_uuid as pid_12 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '254afeea-1fd1-4efb-b5fb-c9c3bf4c13d2' AND t4pgo.option_uuid = '58689abb-25c0-461c-a4c3-a80b627d6649' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P12 INNER JOIN (SELECT t4pgo.product_uuid as pid_13 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '05d933cb-0474-4e5a-bece-42504c6860fd' AND t4pgo.option_uuid = '3e5e9bdd-d78a-4c28-a41d-fe1407925ca6' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P13 INNER JOIN (SELECT t4pgo.product_uuid as pid_14 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd4476dbd-f414-44b9-b66f-b9d485a42e70' AND t4pgo.option_uuid = '16c931fd-61ef-448b-801c-ecbf2a5d166f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P14 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 (P1.pid_1 = P12.pid_12) AND (P1.pid_1 = P13.pid_13) AND (P1.pid_1 = P14.pid_14) 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 (P2.pid_2 = P12.pid_12) AND (P2.pid_2 = P13.pid_13) AND (P2.pid_2 = P14.pid_14) 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 (P3.pid_3 = P12.pid_12) AND (P3.pid_3 = P13.pid_13) AND (P3.pid_3 = P14.pid_14) 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 (P4.pid_4 = P12.pid_12) AND (P4.pid_4 = P13.pid_13) AND (P4.pid_4 = P14.pid_14) 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 (P5.pid_5 = P12.pid_12) AND (P5.pid_5 = P13.pid_13) AND (P5.pid_5 = P14.pid_14) 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 (P6.pid_6 = P12.pid_12) AND (P6.pid_6 = P13.pid_13) AND (P6.pid_6 = P14.pid_14) 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 (P7.pid_7 = P12.pid_12) AND (P7.pid_7 = P13.pid_13) AND (P7.pid_7 = P14.pid_14) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P8.pid_8 = P11.pid_11) AND (P8.pid_8 = P12.pid_12) AND (P8.pid_8 = P13.pid_13) AND (P8.pid_8 = P14.pid_14) AND (P9.pid_9 = P10.pid_10) AND (P9.pid_9 = P11.pid_11) AND (P9.pid_9 = P12.pid_12) AND (P9.pid_9 = P13.pid_13) AND (P9.pid_9 = P14.pid_14) AND (P10.pid_10 = P11.pid_11) AND (P10.pid_10 = P12.pid_12) AND (P10.pid_10 = P13.pid_13) AND (P10.pid_10 = P14.pid_14) AND (P11.pid_11 = P12.pid_12) AND (P11.pid_11 = P13.pid_13) AND (P11.pid_11 = P14.pid_14) AND (P12.pid_12 = P13.pid_13) AND (P12.pid_12 = P14.pid_14) AND (P13.pid_13 = P14.pid_14) sec

116 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

117. SELECT DISTINCT(option_uuid) FROM tp_4over_product_turnaround_time_price WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND runsize_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' sec

118. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' AND tp_4over_product_group_option_master.option_uuid IN ('50979118-b3a2-4556-9f46-d1da268f2354', '9f85d0c4-d344-4088-a719-86f8f84d504d', 'ad290b77-c9d5-476c-b847-9ad4d25ae14e') sec

119. 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 = 'b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb' AND t4pgo.option_uuid = '2e53e1ae-5a15-42a2-8661-c1f8663f00bc' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'b19d4ac3-2d48-40c0-9729-e35af6846271' AND t4pgo.option_uuid = '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '34f407f8-0b50-4227-9378-10fddefbe596' AND t4pgo.option_uuid = '265ef6d8-e93a-4f72-81f5-391adb603874' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '88c28e92-7c8c-4c05-9908-dcd495e0957a' AND t4pgo.option_uuid = '991b850a-6643-48d3-afa6-bcda4cf58c85' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '5fffd29b-af78-41af-a216-7cdaf8d55177' AND t4pgo.option_uuid = 'ee567ae7-d0e9-47ca-830a-b172c097b44f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'c438d655-d2dd-486b-93d5-47b1f3edee19' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P6 INNER JOIN (SELECT t4pgo.product_uuid as pid_7 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '26ca0df3-0682-4f37-8979-409868e2df2d' AND t4pgo.option_uuid = '3e7618de-abca-4bda-9f97-8b9129e913d8' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P7 INNER JOIN (SELECT t4pgo.product_uuid as pid_8 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '38d33954-5a42-4112-a905-215eb827e62c' AND t4pgo.option_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P8 INNER JOIN (SELECT t4pgo.product_uuid as pid_9 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '87e09691-ef33-4cf4-8f17-48af06ce84f4' AND t4pgo.option_uuid = '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = 'd864aba7-b3ca-439d-9401-4bf4987f152c' AND t4pgo.option_uuid = '16ebe401-5398-422d-8cb0-f3adbb82deb5' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) 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 = '17fc2260-9acc-405d-9fc7-3ef3ac293b09' AND t4pgo.option_uuid = '70efd00a-4e8b-432e-9864-fa4d50318d72' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P11 INNER JOIN (SELECT t4pgo.product_uuid as pid_12 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '254afeea-1fd1-4efb-b5fb-c9c3bf4c13d2' AND t4pgo.option_uuid = '58689abb-25c0-461c-a4c3-a80b627d6649' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P12 INNER JOIN (SELECT t4pgo.product_uuid as pid_13 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = '05d933cb-0474-4e5a-bece-42504c6860fd' AND t4pgo.option_uuid = '3e5e9bdd-d78a-4c28-a41d-fe1407925ca6' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P13 INNER JOIN (SELECT t4pgo.product_uuid as pid_14 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'd4476dbd-f414-44b9-b66f-b9d485a42e70' AND t4pgo.option_uuid = '16c931fd-61ef-448b-801c-ecbf2a5d166f' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P14 INNER JOIN (SELECT t4pgo.product_uuid as pid_15 FROM tp_4over_product_group_option_master as t4pgo WHERE t4pgo.option_group_uuid = 'f80e8179-b264-42ce-9f80-bb258a09a1fe' AND t4pgo.option_uuid = '50979118-b3a2-4556-9f46-d1da268f2354' AND t4pgo.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' ) as P15 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 (P1.pid_1 = P12.pid_12) AND (P1.pid_1 = P13.pid_13) AND (P1.pid_1 = P14.pid_14) AND (P1.pid_1 = P15.pid_15) 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 (P2.pid_2 = P12.pid_12) AND (P2.pid_2 = P13.pid_13) AND (P2.pid_2 = P14.pid_14) AND (P2.pid_2 = P15.pid_15) 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 (P3.pid_3 = P12.pid_12) AND (P3.pid_3 = P13.pid_13) AND (P3.pid_3 = P14.pid_14) AND (P3.pid_3 = P15.pid_15) 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 (P4.pid_4 = P12.pid_12) AND (P4.pid_4 = P13.pid_13) AND (P4.pid_4 = P14.pid_14) AND (P4.pid_4 = P15.pid_15) 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 (P5.pid_5 = P12.pid_12) AND (P5.pid_5 = P13.pid_13) AND (P5.pid_5 = P14.pid_14) AND (P5.pid_5 = P15.pid_15) 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 (P6.pid_6 = P12.pid_12) AND (P6.pid_6 = P13.pid_13) AND (P6.pid_6 = P14.pid_14) AND (P6.pid_6 = P15.pid_15) 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 (P7.pid_7 = P12.pid_12) AND (P7.pid_7 = P13.pid_13) AND (P7.pid_7 = P14.pid_14) AND (P7.pid_7 = P15.pid_15) AND (P8.pid_8 = P9.pid_9) AND (P8.pid_8 = P10.pid_10) AND (P8.pid_8 = P11.pid_11) AND (P8.pid_8 = P12.pid_12) AND (P8.pid_8 = P13.pid_13) AND (P8.pid_8 = P14.pid_14) AND (P8.pid_8 = P15.pid_15) AND (P9.pid_9 = P10.pid_10) AND (P9.pid_9 = P11.pid_11) AND (P9.pid_9 = P12.pid_12) AND (P9.pid_9 = P13.pid_13) AND (P9.pid_9 = P14.pid_14) AND (P9.pid_9 = P15.pid_15) AND (P10.pid_10 = P11.pid_11) AND (P10.pid_10 = P12.pid_12) AND (P10.pid_10 = P13.pid_13) AND (P10.pid_10 = P14.pid_14) AND (P10.pid_10 = P15.pid_15) AND (P11.pid_11 = P12.pid_12) AND (P11.pid_11 = P13.pid_13) AND (P11.pid_11 = P14.pid_14) AND (P11.pid_11 = P15.pid_15) AND (P12.pid_12 = P13.pid_13) AND (P12.pid_12 = P14.pid_14) AND (P12.pid_12 = P15.pid_15) AND (P13.pid_13 = P14.pid_14) AND (P13.pid_13 = P15.pid_15) AND (P14.pid_14 = P15.pid_15) sec

120 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

121 93. 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 ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

122 73. SELECT DISTINCT(product_uuid) FROM `tp_product_price` WHERE product_uuid IN ('104ce900-6cf2-4e76-85cb-7452b649aa0a') AND colorspec_uuid = '32d3c223-f82c-492b-b915-ba065a00862f' sec

123. SELECT product_uuid,runsize_uuid,colorspec_uuid,product_baseprice,can_group_ship FROM tp_product_price WHERE product_uuid = '104ce900-6cf2-4e76-85cb-7452b649aa0a' sec

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

125. 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 = '104ce900-6cf2-4e76-85cb-7452b649aa0a' AND product_option_group_uuid IN ('b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb', 'b19d4ac3-2d48-40c0-9729-e35af6846271', '34f407f8-0b50-4227-9378-10fddefbe596', '88c28e92-7c8c-4c05-9908-dcd495e0957a', '5fffd29b-af78-41af-a216-7cdaf8d55177', '24865ffa-793d-43ea-b3b1-d1b5cf22268d', '26ca0df3-0682-4f37-8979-409868e2df2d', '38d33954-5a42-4112-a905-215eb827e62c', '87e09691-ef33-4cf4-8f17-48af06ce84f4', 'd864aba7-b3ca-439d-9401-4bf4987f152c', '17fc2260-9acc-405d-9fc7-3ef3ac293b09', '254afeea-1fd1-4efb-b5fb-c9c3bf4c13d2', '05d933cb-0474-4e5a-bece-42504c6860fd', 'd4476dbd-f414-44b9-b66f-b9d485a42e70', 'f80e8179-b264-42ce-9f80-bb258a09a1fe') AND option_uuid IN ('2e53e1ae-5a15-42a2-8661-c1f8663f00bc', '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858', '265ef6d8-e93a-4f72-81f5-391adb603874', '991b850a-6643-48d3-afa6-bcda4cf58c85', 'ee567ae7-d0e9-47ca-830a-b172c097b44f', 'c438d655-d2dd-486b-93d5-47b1f3edee19', '3e7618de-abca-4bda-9f97-8b9129e913d8', '32d3c223-f82c-492b-b915-ba065a00862f', '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93', '16ebe401-5398-422d-8cb0-f3adbb82deb5', '70efd00a-4e8b-432e-9864-fa4d50318d72', '58689abb-25c0-461c-a4c3-a80b627d6649', '3e5e9bdd-d78a-4c28-a41d-fe1407925ca6', '16c931fd-61ef-448b-801c-ecbf2a5d166f', '50979118-b3a2-4556-9f46-d1da268f2354') AND startqty <= 100 AND endqty >= 100 sec

126. SELECT * FROM tp_4over_product_turnaround_time_price WHERE product_uuid ='104ce900-6cf2-4e76-85cb-7452b649aa0a' And option_uuid ='50979118-b3a2-4556-9f46-d1da268f2354' And colorspec_uuid ='32d3c223-f82c-492b-b915-ba065a00862f' And runsize_uuid ='8a3a0fd1-38ae-49a0-8736-3fedadc3dc93' sec

127. SELECT markup, markup_type FROM tp_4over_category WHERE category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

128. SELECT markup, markup_type FROM tp_move_ops_product_markup WHERE ops_product_id = 385 sec

129. 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 = '265ef6d8-e93a-4f72-81f5-391adb603874' AND ops_product_id =385 LIMIT 1 OFFSET 0 sec

130. 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 = '104ce900-6cf2-4e76-85cb-7452b649aa0a' AND tp_4over_product_group_option_master.category_uuid = '6f4148e7-3842-4d8b-99f8-6d31c2f71883' sec

131. 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:42:00' 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

132 75. SELECT * FROM product_settings WHERE product_settings.products_id = 385 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) 23ba4fe5868711d98f9741b70cf6d058

133 75. SELECT * FROM product_settings WHERE product_settings.products_id = 385 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) 23ba4fe5868711d98f9741b70cf6d058

134. 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 = 8648 AND products_production_days.attribute_id = 0 AND products_sizes.products_id= 385 AND products_sizes.site_language_id= 1 sec

135. SELECT setting_constant_name, setting_value FROM product_settings WHERE product_settings.products_id = 385 AND product_settings.setting_constant_name = 'DEFAULT_PRODUCTION_DAYS' sec

136. SELECT * FROM product_settings WHERE product_settings.products_id = 385 AND product_settings.setting_constant_name = 'PRODUCT_CUT_OFF_TIME' sec

137 125. 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 = '104ce900-6cf2-4e76-85cb-7452b649aa0a' AND product_option_group_uuid IN ('b6f8d6b4-9909-4cd7-bbc0-b65b6e6460eb', 'b19d4ac3-2d48-40c0-9729-e35af6846271', '34f407f8-0b50-4227-9378-10fddefbe596', '88c28e92-7c8c-4c05-9908-dcd495e0957a', '5fffd29b-af78-41af-a216-7cdaf8d55177', '24865ffa-793d-43ea-b3b1-d1b5cf22268d', '26ca0df3-0682-4f37-8979-409868e2df2d', '38d33954-5a42-4112-a905-215eb827e62c', '87e09691-ef33-4cf4-8f17-48af06ce84f4', 'd864aba7-b3ca-439d-9401-4bf4987f152c', '17fc2260-9acc-405d-9fc7-3ef3ac293b09', '254afeea-1fd1-4efb-b5fb-c9c3bf4c13d2', '05d933cb-0474-4e5a-bece-42504c6860fd', 'd4476dbd-f414-44b9-b66f-b9d485a42e70', 'f80e8179-b264-42ce-9f80-bb258a09a1fe') AND option_uuid IN ('2e53e1ae-5a15-42a2-8661-c1f8663f00bc', '9b7272e0-d6c8-4c3c-8e97-d3a1bcdab858', '265ef6d8-e93a-4f72-81f5-391adb603874', '991b850a-6643-48d3-afa6-bcda4cf58c85', 'ee567ae7-d0e9-47ca-830a-b172c097b44f', 'c438d655-d2dd-486b-93d5-47b1f3edee19', '3e7618de-abca-4bda-9f97-8b9129e913d8', '32d3c223-f82c-492b-b915-ba065a00862f', '8a3a0fd1-38ae-49a0-8736-3fedadc3dc93', '16ebe401-5398-422d-8cb0-f3adbb82deb5', '70efd00a-4e8b-432e-9864-fa4d50318d72', '58689abb-25c0-461c-a4c3-a80b627d6649', '3e5e9bdd-d78a-4c28-a41d-fe1407925ca6', '16c931fd-61ef-448b-801c-ecbf2a5d166f', '50979118-b3a2-4556-9f46-d1da268f2354') AND startqty <= 100 AND endqty >= 100 sec

(Cached) b17fec117b4025fcef3e483facbb8457

138 128. SELECT markup, markup_type FROM tp_move_ops_product_markup WHERE ops_product_id = 385 sec

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

(Cached) 52520048f72321f7fc95c1219427ab6d

140. SELECT * FROM address_book WHERE user_id = 0 sec

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

(Cached) cd3fa65484d94fadd06c251b01a31fd8

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

(Cached) 52520048f72321f7fc95c1219427ab6d

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

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

(Cached) 6eaa3b39c2718890711cfd27fb194775

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

(Cached) 09edf8b51add513de8d19a10ef493375

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

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

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

(Cached) 613b110f15bfd6188f372b9124b62c8e

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

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

151 34. 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

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

153 34. 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

154 152. 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

155 34. 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

156 152. 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

157 34. 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

158 152. 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

159 34. 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

160 152. 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

161. 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:42:01' AND banner_image.banner_end_date >= '2026-06-13 00:42:01')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](385)[[:>:]]' 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

162 161. 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:42:01' AND banner_image.banner_end_date >= '2026-06-13 00:42:01')) AND banner_available_to ='1' AND banner_image.banner_pages REGEXP '[[:<:]](385)[[:>:]]' 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

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

(Cached) cfc88bdad1d3c808679011331b88f107

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

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

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

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

168. SELECT * FROM product_settings WHERE product_settings.products_id = 385 AND product_settings.setting_constant_name = 'PRODUCT_CREATE_HELP_TEMPLATE' sec

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

170. 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 = 385 AND products_description.site_language_id = 1 sec

171. SELECT * FROM product_settings WHERE product_settings.products_id = 385 sec

172 51. SELECT * FROM products_sizes WHERE `products_sizes`.`products_id`=385 AND `products_sizes`.`visible`='1' AND `products_sizes`.site_language_id=1 ORDER BY `products_sizes`.`sort_order` ASC sec

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

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

175. 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 = 385 sec

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

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

178. SELECT option_id,mask_image_landscape,mask_image_potrait,pages_id,size_id,attribute_id FROM products_mask WHERE product_id = 385 sec

179 14. SELECT products.predefined_product_type, products.price_defining_method, products.is_promotional FROM products WHERE products.products_id = 385 sec

(Cached) ff378a7923f59932df1bf186f80538d0

180. 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 = 385 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