SELECT 
  products.*, 
  product_descriptions.*, 
  MIN(
    IF(
      product_prices.percentage_discount = 0, 
      product_prices.price, 
      product_prices.price - (
        product_prices.price * product_prices.percentage_discount
      )/ 100
    )
  ) as price, 
  GROUP_CONCAT(
    CASE WHEN (
      products_categories.link_type = 'M'
    ) THEN CONCAT(
      products_categories.category_id, 
      'M'
    ) ELSE products_categories.category_id END 
    ORDER BY 
      categories.storefront_id IN (0, 1) DESC, 
      (
        products_categories.link_type = 'M'
      ) DESC, 
      products_categories.category_position ASC, 
      products_categories.category_id ASC
  ) as category_ids, 
  popularity.total as popularity, 
  company_descr.i18n_company as company_name, 
  cd.terms, 
  seo_names.name as seo_name, 
  seo_names.path as seo_path, 
  company_descriptions.company_description, 
  discussion.type as discussion_type 
FROM 
  products 
  LEFT JOIN product_prices ON product_prices.product_id = products.product_id 
  AND product_prices.lower_limit = 1 
  AND product_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN product_descriptions ON product_descriptions.product_id = products.product_id 
  AND product_descriptions.lang_code = 'en' 
  LEFT JOIN company_descriptions as company_descr ON company_descr.company_id = products.company_id 
  AND company_descr.lang_code = 'en' 
  LEFT JOIN companies as companies ON companies.company_id = products.company_id 
  INNER JOIN products_categories ON products_categories.product_id = products.product_id 
  INNER JOIN categories ON categories.category_id = products_categories.category_id 
  AND categories.storefront_id IN (0, 1) 
  AND (
    categories.usergroup_ids = '' 
    OR FIND_IN_SET(0, categories.usergroup_ids) 
    OR FIND_IN_SET(1, categories.usergroup_ids)
  ) 
  AND (
    products.usergroup_ids = '' 
    OR FIND_IN_SET(0, products.usergroup_ids) 
    OR FIND_IN_SET(1, products.usergroup_ids)
  ) 
  AND categories.status IN ('A', 'H') 
  AND products.status IN ('A', 'H') 
  LEFT JOIN product_popularity as popularity ON popularity.product_id = products.product_id 
  LEFT JOIN company_descriptions AS cd ON cd.company_id = products.company_id 
  AND cd.lang_code = 'en' 
  LEFT JOIN seo_names ON seo_names.object_id = 43453 
  AND seo_names.type = 'p' 
  AND seo_names.dispatch = '' 
  AND seo_names.lang_code = 'en' 
  LEFT JOIN company_descriptions AS company_descriptions ON company_descriptions.company_id = products.company_id 
  AND company_descriptions.lang_code = 'en' 
  LEFT JOIN discussion ON discussion.object_id = products.product_id 
  AND discussion.object_type = 'P' 
WHERE 
  products.product_id = 43453 
  AND (
    companies.status IN ('A') 
    OR products.company_id = 0
  ) 
GROUP BY 
  products.product_id

Query time 0.00188

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "9.06"
    },
    "grouping_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "products",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "status",
              "idx_company_id",
              "idx_usergroup_ids"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "4K"
            },
            "used_columns": [
              "product_id",
              "product_code",
              "product_type",
              "status",
              "company_id",
              "list_price",
              "amount",
              "weight",
              "length",
              "width",
              "height",
              "shipping_freight",
              "low_avail_limit",
              "timestamp",
              "updated_timestamp",
              "usergroup_ids",
              "is_edp",
              "edp_shipping",
              "unlimited_download",
              "tracking",
              "free_shipping",
              "zero_price_action",
              "is_pbp",
              "is_op",
              "is_oper",
              "is_returnable",
              "return_period",
              "avail_since",
              "out_of_stock_actions",
              "localization",
              "min_qty",
              "max_qty",
              "qty_step",
              "list_qty_count",
              "tax_ids",
              "age_verification",
              "age_limit",
              "options_type",
              "exceptions_type",
              "details_layout",
              "shipping_params",
              "weight_lbs",
              "weight_oz",
              "product_tax_code",
              "deleted_at",
              "archived_at",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "popularity",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "total"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "32"
            },
            "used_columns": [
              "product_id",
              "total"
            ]
          }
        },
        {
          "table": {
            "table_name": "cd",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id",
              "lang_code"
            ],
            "key_length": "10",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "terms"
            ]
          }
        },
        {
          "table": {
            "table_name": "product_prices",
            "access_type": "ref",
            "possible_keys": [
              "usergroup",
              "product_id",
              "lower_limit",
              "usergroup_id"
            ],
            "key": "product_id",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.30",
              "eval_cost": "0.10",
              "prefix_cost": "0.40",
              "data_read_per_join": "24"
            },
            "used_columns": [
              "product_id",
              "price",
              "percentage_discount",
              "lower_limit",
              "usergroup_id"
            ],
            "attached_condition": "<if>(is_not_null_compl(product_prices), ((`goimagine`.`product_prices`.`lower_limit` = 1) and (`goimagine`.`product_prices`.`usergroup_id` in (0,0,1))), true)"
          }
        },
        {
          "table": {
            "table_name": "product_descriptions",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "product_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id",
              "lang_code"
            ],
            "key_length": "11",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.64",
              "eval_cost": "0.10",
              "prefix_cost": "1.14",
              "data_read_per_join": "5K"
            },
            "used_columns": [
              "product_id",
              "lang_code",
              "product",
              "shortname",
              "short_description",
              "full_description",
              "meta_keywords",
              "meta_description",
              "search_words",
              "page_title",
              "age_warning_message",
              "promo_text",
              "cls_stop_words",
              "how_its_made",
              "custom_header"
            ]
          }
        },
        {
          "table": {
            "table_name": "company_descr",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id",
              "lang_code"
            ],
            "key_length": "10",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.91",
              "eval_cost": "0.10",
              "prefix_cost": "2.14",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "i18n_company"
            ]
          }
        },
        {
          "table": {
            "table_name": "companies",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id"
            ],
            "key_length": "4",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.68",
              "eval_cost": "0.10",
              "prefix_cost": "2.92",
              "data_read_per_join": "14K"
            },
            "used_columns": [
              "company_id",
              "status"
            ],
            "attached_condition": "<if>(found_match(companies), ((`goimagine`.`companies`.`status` = 'A') or false), true)"
          }
        },
        {
          "table": {
            "table_name": "products_categories",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "pt"
            ],
            "key": "pt",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 8,
            "rows_produced_per_join": 8,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "2.00",
              "eval_cost": "0.80",
              "prefix_cost": "5.72",
              "data_read_per_join": "128"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type",
              "category_position"
            ]
          }
        },
        {
          "table": {
            "table_name": "categories",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "goimagine.products_categories.category_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "2.00",
              "eval_cost": "0.04",
              "prefix_cost": "8.52",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "category_id",
              "usergroup_ids",
              "status",
              "storefront_id"
            ],
            "attached_condition": "((`goimagine`.`categories`.`storefront_id` in (0,1)) and ((`goimagine`.`categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`goimagine`.`categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`goimagine`.`categories`.`usergroup_ids`))) and (`goimagine`.`categories`.`status` in ('A','H')))"
          }
        },
        {
          "table": {
            "table_name": "seo_names",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "dispatch"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "type",
              "dispatch",
              "lang_code"
            ],
            "key_length": "206",
            "ref": [
              "const",
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.34",
              "eval_cost": "0.04",
              "prefix_cost": "8.90",
              "data_read_per_join": "694"
            },
            "used_columns": [
              "name",
              "object_id",
              "type",
              "dispatch",
              "path",
              "lang_code"
            ]
          }
        },
        {
          "table": {
            "table_name": "company_descriptions",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id",
              "lang_code"
            ],
            "key_length": "10",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.05",
              "eval_cost": "0.04",
              "prefix_cost": "8.99",
              "data_read_per_join": "710"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "company_description"
            ]
          }
        },
        {
          "table": {
            "table_name": "discussion",
            "access_type": "const",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type"
            ],
            "key_length": "6",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.03",
              "eval_cost": "0.04",
              "prefix_cost": "9.06",
              "data_read_per_join": "9"
            },
            "used_columns": [
              "object_id",
              "object_type",
              "type"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id product_code product_type status company_id list_price amount weight length width height shipping_freight low_avail_limit timestamp updated_timestamp usergroup_ids is_edp edp_shipping unlimited_download tracking free_shipping zero_price_action is_pbp is_op is_oper is_returnable return_period avail_since out_of_stock_actions localization min_qty max_qty qty_step list_qty_count tax_ids age_verification age_limit options_type exceptions_type details_layout shipping_params weight_lbs weight_oz product_tax_code deleted_at archived_at position lang_code product shortname short_description full_description meta_keywords meta_description search_words page_title age_warning_message promo_text cls_stop_words how_its_made custom_header price category_ids popularity company_name terms seo_name seo_path company_description discussion_type
43453 bec0239 P A 239 140.00 10 0.000 0 0 0 0.00 0 1598819831 1674032100 0 N N N B N R N N N Y 10 0 N 0 5 0 0 N 0 P F a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 0.000 2147483647 en Fine Art Canvas Photograph of a Stream with a Tranquil Waterfall among this Section of a Utah Slot Canyon Fine Art Photograph of a Stream with a Tranquil Waterfall among this Section of a Utah Slot Canyon. <p><b> <br>Image title: </b>&nbsp; &nbsp; Gentle Falls<br><br>Fine Art Canvas Photograph of a Stream with a Tranquil Waterfall among this Section of a Utah Slot Canyon. One of my major photography themes is the subject of water. I prefer to have a longer exposure which creates a sense of movement in the water.</p><p>All photographs are original and photographed by artist Bob Estrin. This unique art decor print will complete and enrich your home design, it will perfectly blend in with your interior and become a charming piece for your living room, bedroom, kitchen, hallway or office.<br></p><p></p><p><strong><strong><em>Gallery wrapped canvas photographs sizes available</em></strong><em>: </em></strong></p><p><em>16" x 24", 20"x 30", 24" x 36", and 32" x 48" ready to hang<br><br></em></p><p><strong><em>Print deta</em><em>ils</em></strong><em><strong>:</strong></em> <br></p><p>&nbsp; • &nbsp; Canvas gallery wrapped photographs come with deep sides (1.25" deep sides)<br>&nbsp; • &nbsp; Printed on a large format printer using artist-grade canvas with a luster finish<br>&nbsp; • &nbsp; See canvas related photo shown above for quality product features and construction<br>&nbsp; • &nbsp; Fade resistant pigmented archival inks<br>&nbsp; • &nbsp; The backside of the canvas photographs has a protective dust cover with built-in hanging hardware and ready to hang<br>&nbsp; • &nbsp; The canvas photograph will look similar to the canvas image shown above with the image wrapped onto the 1.25 inch deep sides<br>&nbsp; • &nbsp; Includes printed artist signed Certificate of Authenticity and artist biography sent separately<br>&nbsp; • &nbsp; Optional frame available in black or walnut finish upon request</p><p><b>Print on paper option (Not on canvas):</b> This photograph is also available to be printed on photography paper in a variety of sizes.&nbsp; Click on the following link to purchase canvas photograph or for additional information <a href="https://goimagine.com/art/photography/photographs-for-bob-estrins-photography-images-en/">(Print on Paper Link)</a> <br></p> gallery wrapped, canvas, canvas wrapped, wall art, print, art print, photography, photograph, gift, home decor, artwork, gallery, wrap, water, babbling, brook, driftwood, stick, log, wet, fall, dripping, drop, waterfall, rock, river, canyon, slot, mountai One of my major photography themes is the subject of water. I prefer to have a longer exposure which creates a sense of movement in the water. gallery wrapped, canvas, canvas wrapped, wall art, print, decoration, art print, photography, photograph, gift, gift for, home decor, art decor, photographs, gallery, wrap, water, babbling, brook, driftwood, stick, log, wet, Fine Art Canvas Photograph of a Stream with a Tranquil Waterfall among this Section of a Utah Slot Canyon. <p>Photographs ship out in 4-5 business days with UPS tracking</p> <p>Two of my great passions in life are travel and photography. Through my photography, I seek to document my personal experiences, to capture scenes and events as I see them and to share with others the beauty and diversity of the world I've seen.I grew up in a Northwest suburb of Chicago and became fascinated with photography at an early age. This led to my first 35mm camera purchase in 1971 for a high school black & white photography class. This eventually progressed to my receiving my Bachelor of Arts degree in professional photography from Southern Illinois University. <br></p> <p>After working in the photography field a few years, I chose to go back to school to learn computer programming and worked for many years as a Programmer/Analyst and System Analyst. My frequent visits and family connection to Arizona assisted in my decision to move to Arizona in 1999.With the beauty of the Southwest all around me, I have recaptured my passion for photography.&nbsp; </p> <p>It is my goal as an artist and photographer to encourage this closer examination of ordinary things by presenting them in an unusual context. While my photographic subjects vary widely, I find myself repeatedly drawn to landscapes and objects from the past such as cars and ghost towns as well as the influence of man on both of these. fine photograph is not only the creation of the original camera exposure but also the result of significant technical and aesthetic consideration while making the final print. This allows me to not only record a literal moment in time, but rather the emotion or experience of the moment. </p> <p>Photography is the medium of choice for my creative expression. I am still excited about the power and magic of photography and its ability to capture my unique selective perception of the moment in a form that I can share with others. Estrin displays his art around Arizona at venues including solo exhibitions at the ASU Gammage Auditorium, Boyce Thompson Arboretum, Tucson Jewish Community Center gallery and at the Peoria and Gilbert Arizona libraries. &nbsp;His art has been exhibited at the West Valley Art Museum and the Arizona Art Museum for Youth. Estrin’s art is collected by individuals as well as found in city and corporate collections. He has been featured in the Arizona Republic newspaper and selected as Phoenix Magazine’s artist of the month. </p> <p></p> 140.00000000 30M,212,618,907,619,612,620,921 4384 Bob Estrin Photography <p><strong>Make things better:&nbsp;</strong> I appreciate your business and that you have selected my artwork for your walls among the many choices you have.&nbsp; If you encounter any issues or problems, contact me thru Goimagine and receive a response within 24 hours.&nbsp; In most cases, I can fix the issue immediately.&nbsp; <br></p> <p><strong>Return policy for matted prints and individual paper prints:</strong></p> <p>Refunds will only be issued within 30 days of shipment delivery, minus all shipping costs, upon return of item/items in original condition.&nbsp; Return shipping is at the customer's expense. <br></p> <p><strong>Return policy for Canvas, Aluminum or Framed photographs:&nbsp; </strong>For these types of custom photographs returns are not available since they are made to order.&nbsp; <br></p> <p><strong>Cancellation Policy for Canvas, Aluminum and Framed photographs:&nbsp; </strong>These types of photographs cannot be canceled once the custom photograph is started to be produced even if the product is not yet completed or shipped out.&nbsp; The customer can contact the store to see if cancellation is possible if the creation of the customized product has not been started yet.<br><br><strong>Product arrives damaged or defective (All products):&nbsp; </strong>Notify the store of a damaged or defective product within 7 days of arrival for Return Merchandise Authorization.&nbsp; A replacement will be sent when the item is returned.&nbsp; <br></p> <p><strong>Shipping:</strong>&nbsp; Most items ship out in 1 - 3 days.&nbsp; Canvas and framed photographs ship out in 4-5 days.<strong><br><br>Contact Email:</strong>&nbsp; <span class="gI">photographyartwork1@gmail.com</span>&nbsp; This contact method will support sending attachments or images.<br></p> <p></p> fine-art-canvas-photograph-of-a-stream-with-a-tranquil-waterfall-among-this-section-of-a-utah-slot-canyon 23/30 <p>Unique fine art photography directly from the artist Bob Estrin to enrich your home design needs. Bob Estrin's photography will perfectly blend in with your interior and become a charming piece for your living room, bedroom, kitchen, hallway or office.</p> <p><strong>Sample video below </strong>of Bob walking in a slot canyon in Utah.</p> <p><a href="http://www.bobestrin.com/picts/mvi-7007_xctuqb4q.mov" target="_blank" class="editor-rtfLink"><strong>Click here to view the video</strong></a></p> <p><strong>Customer Comments:<br><br>"</strong>B<span class="expandable-text a-text-quote"><span class="expandable-expanded-text">ob’s prints are of the highest quality and an incredible value. Excellent materials and execution. Customer service is wonderful. I made a mistake with my order and Bob quickly resolved it for me and was more than fair. If you purchase a print from Bob you will be very happy you did!</span> </span><span class="expandable-action expandable-reduce-action"><span class="a-declarative" data-action="reduce-text" data-reduce-text="{}">" </span> </span> </p> <p>"Amazing work, had some questions from the seller wrote back very timely. I'm so very lucky to have your photo in my house."</p> <p>"We love the photograph and get lots of compliments when customers come into our business."</p> <p>&nbsp;"Beautiful panoramic photograph by Bob, so beautiful on the wall with my wilderness theme. Highly recommend!! Great customer service as well."</p> <p>"A beautiful photograph of original Bristle Pine Cone tree very pleased with the size and nicely matted; also happy to get to know the photographer in his bio included with the purchase. An absolute satisfied sale."</p> <p>"Got this as a gift for my Ma. She absolutely loved it! The photograph is hauntingly beautiful, and it stands out so well in her living room!"</p> <p><strong>Artist Bio</strong></p> <p>Two of my great passions in life are travel and photography. Through my photography, I seek to document my personal experiences, capture scenes and events as I see them, and share with others the beauty and diversity of the world I've seen.</p> <p>I grew up in a Northwest suburb of Chicago and became fascinated with photography at an early age. This led to my first 35mm camera purchase in 1971 for a high school black & white photography class. This eventually progressed to my receiving my Bachelor of Arts degree in professional photography from Southern Illinois University.</p> <p>&nbsp;After working in the photography field for a few years, I chose to go back to school to learn computer programming and worked for many years as a Programmer/Analyst and System Analyst. My frequent visits and family connection to Arizona assisted in my decision to move to Arizona in 1999.</p> <p>With the beauty of the Southwest all around me, I have recaptured my passion for photography. It is my goal as an artist and photographer to encourage this closer examination of ordinary things by presenting them in an unusual context. While my photographic subjects vary widely, I find myself repeatedly drawn to landscapes and objects from the past such as cars and ghost towns as well as the influence of man on both of these.</p> <p>Fine photograph is not only the creation of the original camera exposure but also the result of significant technical and aesthetic consideration while making the final print. This allows me to not only record a literal moment in time but rather the emotion or experience of the moment.&nbsp;</p> <p>Photography is the medium of choice for my creative expression. I am still excited about the power and magic of photography and its ability to capture my unique selective perception of the moment in a form that I can share with others.</p> <p>Estrin displays his art around Arizona at venues including solo exhibitions at the ASU Gammage Auditorium, Boyce Thompson Arboretum, Tucson Jewish Community Center Gallery, and the Peoria and Gilbert Arizona libraries.&nbsp;</p> <p>His art has been exhibited at the West Valley Art Museum and the Arizona Art Museum for Youth. Estrin’s art is collected by individuals as well as found in city and corporate collections. He has been featured in the Arizona Republic newspaper and selected as Phoenix Magazine’s artist of the month.<br></p> D