Sandbox

SELECT 
  cscart_products.*, 
  cscart_product_descriptions.*, 
  MIN(
    IF(
      cscart_product_prices.percentage_discount = 0, 
      cscart_product_prices.price, 
      cscart_product_prices.price - (
        cscart_product_prices.price * cscart_product_prices.percentage_discount
      )/ 100
    )
  ) as price, 
  GROUP_CONCAT(
    IF(
      cscart_products_categories.link_type = 'M', 
      CONCAT(
        cscart_products_categories.category_id, 
        'M'
      ), 
      cscart_products_categories.category_id
    )
  ) as category_ids, 
  popularity.total as popularity, 
  IF(
    shared_prices.product_id IS NOT NULL, 
    MIN(
      IF(
        shared_prices.percentage_discount = 0, 
        shared_prices.price, 
        shared_prices.price - (
          shared_prices.price * shared_prices.percentage_discount
        )/ 100
      )
    ), 
    MIN(
      IF(
        cscart_product_prices.percentage_discount = 0, 
        cscart_product_prices.price, 
        cscart_product_prices.price - (
          cscart_product_prices.price * cscart_product_prices.percentage_discount
        )/ 100
      )
    )
  ) as price, 
  companies.company as company_name, 
  cscart_product_sales.amount as sales_amount, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path, 
  cscart_discussion.type as discussion_type 
FROM 
  cscart_products 
  LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id 
  AND cscart_product_prices.lower_limit = 1 
  AND cscart_product_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id 
  AND cscart_product_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id 
  AND shared_prices.company_id = 1 
  AND shared_prices.lower_limit = 1 
  AND shared_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id 
  INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.company_id = 1 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND (
    cscart_products.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_products.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_products.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  AND cscart_products.status IN ('A', 'H') 
  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id 
  LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id 
  AND cscart_product_sales.category_id = 1899 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 64026 
  AND cscart_seo_names.type = 'p' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  AND cscart_seo_names.company_id = 1 
  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id 
  AND cscart_discussion.object_type = 'P' 
WHERE 
  cscart_products.product_id = 64026 
  AND (
    companies.status = 'A' 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00127

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "shared_prices",
      "access_type": "system",
      "possible_keys": [
        "usergroup",
        "product_id",
        "company_id",
        "lower_limit",
        "usergroup_id"
      ],
      "rows": 0,
      "filtered": 0,
      "const_row_not_found": true
    },
    "table": {
      "table_name": "cscart_products",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "status"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "companies",
      "access_type": "const",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["company_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "popularity",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "total"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_product_sales",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "pa"],
      "key": "PRIMARY",
      "key_length": "6",
      "used_key_parts": ["category_id", "product_id"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_product_prices",
      "access_type": "range",
      "possible_keys": ["usergroup", "product_id", "lower_limit", "usergroup_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "usergroup_id", "lower_limit"],
      "rowid_filter": {
        "range": {
          "key": "lower_limit",
          "used_key_parts": ["lower_limit", "product_id", "usergroup_id"]
        },
        "rows": 2,
        "selectivity_pct": 0.074128984
      },
      "rows": 2,
      "filtered": 100,
      "attached_condition": "trigcond(1) and trigcond(cscart_product_prices.product_id = 64026 and cscart_product_prices.lower_limit = 1 and cscart_product_prices.usergroup_id in (0,0,1))"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_product_descriptions.lang_code = 'en')"
    },
    "table": {
      "table_name": "cscart_products_categories",
      "access_type": "ref",
      "possible_keys": ["PRIMARY", "pt"],
      "key": "pt",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "ref": ["const"],
      "rows": 5,
      "filtered": 100,
      "using_index": true
    },
    "table": {
      "table_name": "cscart_categories",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY", "c_status", "p_category_id"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["category_id"],
      "ref": ["cscart_migrate.cscart_products_categories.category_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "cscart_categories.company_id = 1 and (cscart_categories.usergroup_ids = '' or find_in_set(0,cscart_categories.usergroup_ids) or find_in_set(1,cscart_categories.usergroup_ids)) and cscart_categories.`status` in ('A','H')"
    },
    "table": {
      "table_name": "cscart_seo_names",
      "access_type": "const",
      "possible_keys": ["PRIMARY", "dispatch"],
      "key": "dispatch",
      "key_length": "210",
      "used_key_parts": [
        "dispatch",
        "object_id",
        "type",
        "lang_code",
        "company_id"
      ],
      "ref": ["const", "const", "const", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_seo_names.`type` = 'p' and cscart_seo_names.dispatch = '' and cscart_seo_names.lang_code = 'en')"
    },
    "table": {
      "table_name": "cscart_discussion",
      "access_type": "ref",
      "possible_keys": ["object_id"],
      "key": "object_id",
      "key_length": "6",
      "used_key_parts": ["object_id", "object_type"],
      "ref": ["const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_discussion.object_type = 'P')"
    }
  }
}

Result

product_id	product_code	product_type	trustmark_origin	trustmark_certified	trustmark_leadtime	trustmark_location	trustmark_return	owner_id	status	company_id	list_price	amount	weight	length	width	height	shipping_freight	low_avail_limit	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	updated_timestamp	pricing_note	use_new_layout	category_image	tax_code	upc_code	product_detail_ids	nav_sku	sku_columns	nav_review_user_id	hide_price	vendor_fulfilled	hide_commercial_price	non_returnable	ble_basics	commercial_hidden	allow_configurator	enable_customize	enable_buy_american	base_cost	redline_p	lang_code	product	shortname	short_description	full_description	meta_keywords	meta_description	search_words	page_title	age_warning_message	internal	promo_text	price	category_ids	popularity	company_name	sales_amount	seo_name	seo_path	discussion_type
64026	BLE-G-MA7	P	E	C	M	D	A	0	A	1	930.00	1000	0.000	0	0	0	0.00	0	1478494800	0	N	N	N	D	N	R	N	N	N	Y	10	0	N		0	0	0	0	13	N	0	P	F	default	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;}	1659113934	Price decreased by $50 - DC 8/28/20 Price increased 5% from $805 to $845 - DC 5/24/21 Price increased 10% from $845 to $930 - DC 5/24/22	Y		none	none	3253	BLE-G-MA7		1051256	0	0	0	0	0	0	0	0	1	0.00	0	en	Huxley Machine Age Wall Mount			<p>The Huxley, one of our boldest creations, indulges our desire to develop imaginative new possibilities for our lighting. Consisting of exposed metal piping and other rugged flourishes, this inventive light favors an industrial aesthetic. The oversized wall-mounted structure sprawls out across a large area, commanding focus as a stunning statement piece. Decorative valves and gauges complete the Huxley’s rustic appeal!<br /> <br />This captivating appearance and substantial size impart the distinguishing character needed to separate businesses from the competition. As the foundation for new designs, the Huxley sets a unique tone for the space. Or this striking wall-mounted light breathes a new life to existing décors. The Huxley can fulfill a similar role in residential settings. Consider this industrial wall fixture for both modern, minimalist styles and more traditional looks!</p> <p>\|break\|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial wall lighting is a lasting sconce option.<span> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li><span>See more of the steampunk-inspired Machine Age Collection </span><a href="/lighting-collections/machine-age-collection/" target="_blank">here</a><span>.</span></li> <li>Read more about the Huxley Machine Age Wall Mount over on our <a href="https://www.barnlight.com/inspiration/featured-customer-industrial-lighting-adds-unique-machine-age-chic/" target="_blank">blog</a>!</li> </ul>		This dramatic wall mounted provides a stunning statement piece to residential or commercial spaces. Machine Age style, American made! Perfect for modern looks!	BLE-G-MA7, The Huxley Machine Age Wall Mount, The Huxley Machine Age Wall Mount Light, The Huxley Machine Age Wall Mount Lights, The Huxley Machine Age Wall Mount Lighting, The Huxley Machine Age Wall Mounted, The Huxley Machine Age Wall Mounted Light, The Huxley Machine Age Wall Mounted Lights, The Huxley Machine Age Wall Mounted Lighting, Huxley Machine Age Wall Mount, Huxley Machine Age Wall Mount Light, Huxley Machine Age Wall Mount Lights, Huxley Machine Age Wall Mount Lighting, Huxley Machine Age Wall Mounted, Huxley Machine Age Wall Mounted Light, Huxley Machine Age Wall Mounted Lights, Huxley Machine Age Wall Mounted Lighting, The Huxley Machine Age Wall, The Huxley Machine Age Wall Light, The Huxley Machine Age Wall Lights, The Huxley Machine Age Wall Lighting, Huxley Machine Age Wall, Huxley Machine Age Wall Light, Huxley Machine Age Wall Lights, Huxley Machine Age Wall Lighting, The Huxley Wall Mount, The Huxley Wall Mount Light, The Huxley Wall Mount Lights, The Huxley Wall Mount Lighting, The Huxley Wall Mounted, The Huxley Wall Mounted Light, The Huxley Wall Mounted Lights, The Huxley Wall Mounted Lighting, Huxley Wall Mount, Huxley Wall Mount Light, Huxley Wall Mount Lights, Huxley Wall Mount Lighting, Huxley Wall Mounted, Huxley Wall Mounted Light, Huxley Wall Mounted Lights, Huxley Wall Mounted Lighting, The Huxley Wall, The Huxley Wall Light, The Huxley Wall Lights, The Huxley Wall Lighting, Huxley Wall, Huxley Wall Light, Huxley Wall Lights, Huxley Wall Lighting, The Machine Age Wall Mount, The Machine Age Wall Mount Light, The Machine Age Wall Mount Lights, The Machine Age Wall Mount Lighting, The Machine Age Wall Mounted, The Machine Age Wall Mounted Light, The Machine Age Wall Mounted Lights, The Machine Age Wall Mounted Lighting, Machine Age Wall Mount, Machine Age Wall Mount Light, Machine Age Wall Mount Lights, Machine Age Wall Mount Lighting, Machine Age Wall Mounted, Machine Age Wall Mounted Light, Machine Age Wall Mounted Lights, Machine Age Wall Mounted Lighting, The Machine Age Wall, The Machine Age Wall Light, The Machine Age Wall Lights, The Machine Age Wall Lighting, Machine Age Wall, Machine Age Wall Light, Machine Age Wall Lights, Machine Age Wall Lighting, The Wall Mount, The Wall Mount Light, The Wall Mount Lights, The Wall Mount Lighting, The Wall Mounted, The Wall Mounted Light, The Wall Mounted Lights, The Wall Mounted Lighting, Wall Mount, Wall Mount Light, Wall Mount Lights, Wall Mount Lighting, Wall Mounted, Wall Mounted Light, Wall Mounted Lights, Wall Mounted Lighting, The Huxley Steampunk Wall Mount, The Huxley Steampunk Wall Mount Light, The Huxley Steampunk Wall Mount Lights, The Huxley Steampunk Wall Mount Lighting, The Huxley Steampunk Wall Mounted, The Huxley Steampunk Wall Mounted Light, The Huxley Steampunk Wall Mounted Lights, The Huxley Steampunk Wall Mounted Lighting, Huxley Steampunk Wall Mount, Huxley Steampunk Wall Mount Light, Huxley Steampunk Wall Mount Lights, Huxley Steampunk Wall Mount Lighting, Huxley Steampunk Wall Mounted, Huxley Steampunk Wall Mounted Light, Huxley Steampunk Wall Mounted Lights, Huxley Steampunk Wall Mounted Lighting, The Huxley Steampunk Wall, The Huxley Steampunk Wall Light, The Huxley Steampunk Wall Lights, The Huxley Steampunk Wall Lighting, Huxley Steampunk Wall, Huxley Steampunk Wall Light, Huxley Steampunk Wall Lights, Huxley Steampunk Wall Lighting, The Huxley Wall Mount, The Huxley Wall Mount Light, The Huxley Wall Mount Lights, The Huxley Wall Mount Lighting, The Huxley Wall Mounted, The Huxley Wall Mounted Light, The Huxley Wall Mounted Lights, The Huxley Wall Mounted Lighting, Huxley Wall Mount, Huxley Wall Mount Light, Huxley Wall Mount Lights, Huxley Wall Mount Lighting, Huxley Wall Mounted, Huxley Wall Mounted Light, Huxley Wall Mounted Lights, Huxley Wall Mounted Lighting, The Huxley Wall, The Huxley Wall Light, The Huxley Wall Lights, The Huxley Wall Lighting, Huxley Wall, Huxley Wall Light, Huxley Wall Lights, Huxley Wall Lighting, The Steampunk Wall Mount, The Steampunk Wall Mount Light, The Steampunk Wall Mount Lights, The Steampunk Wall Mount Lighting, The Steampunk Wall Mounted, The Steampunk Wall Mounted Light, The Steampunk Wall Mounted Lights, The Steampunk Wall Mounted Lighting, Steampunk Wall Mount, Steampunk Wall Mount Light, Steampunk Wall Mount Lights, Steampunk Wall Mount Lighting, Steampunk Wall Mounted, Steampunk Wall Mounted Light, Steampunk Wall Mounted Lights, Steampunk Wall Mounted Lighting, The Steampunk Wall, The Steampunk Wall Light, The Steampunk Wall Lights, The Steampunk Wall Lighting, Steampunk Wall, Steampunk Wall Light, Steampunk Wall Lights, Steampunk Wall Lighting, The Huxley Steam punk Wall Mount, The Huxley Steam punk Wall Mount Light, The Huxley Steam punk Wall Mount Lights, The Huxley Steam punk Wall Mount Lighting, The Huxley Steam punk Wall Mounted, The Huxley Steam punk Wall Mounted Light, The Huxley Steam punk Wall Mounted Lights, The Huxley Steam punk Wall Mounted Lighting, Huxley Steam punk Wall Mount, Huxley Steam punk Wall Mount Light, Huxley Steam punk Wall Mount Lights, Huxley Steam punk Wall Mount Lighting, Huxley Steam punk Wall Mounted, Huxley Steam punk Wall Mounted Light, Huxley Steam punk Wall Mounted Lights, Huxley Steam punk Wall Mounted Lighting, The Huxley Steam punk Wall, The Huxley Steam punk Wall Light, The Huxley Steam punk Wall Lights, The Huxley Steam punk Wall Lighting, Huxley Steam punk Wall, Huxley Steam punk Wall Light, Huxley Steam punk Wall Lights, Huxley Steam punk Wall Lighting, The Steam punk Wall Mount, The Steam punk Wall Mount Light, The Steam punk Wall Mount Lights, The Steam punk Wall Mount Lighting, The Steam punk Wall Mounted, The Steam punk Wall Mounted Light, The Steam punk Wall Mounted Lights, The Steam punk Wall Mounted Lighting, Steam punk Wall Mount, Steam punk Wall Mount Light, Steam punk Wall Mount Lights, Steam punk Wall Mount Lighting, Steam punk Wall Mounted, Steam punk Wall Mounted Light, Steam punk Wall Mounted Lights, Steam punk Wall Mounted Lighting, The Steam punk Wall, The Steam punk Wall Light, The Steam punk Wall Lights, The Steam punk Wall Lighting, Steam punk Wall, Steam punk Wall Light, Steam punk Wall Lights, Steam punk Wall Lighting, steampunk, steam punk, steampunk light, steampunk lights, steampunk lighting, steam punk light, steam punk lights, steam punk lighting, machine age, machine age light, machine age lights, machine age lighting, Huxley, The Huxley, haxley, oversized wall light, over sized wall light, large wall light, Interior barn light wall sconce, Interior barn light wall sconces, Interior sconce, interior sconces, interior wall sconce, interior wall sconces, Interior sconce light, Interior sconce lights, Interior sconce lighting, Interior wall light, Interior wall lights, Interior wall lighting, Interior light wall sconce, Interior light wall sconces, Interior light, Interior lights, Interior lighting, wall mount indoor light, wall mount indoor lights, wall mount indoor lighting, wall mount interior light, wall mount interior lights, wall mount interior lighting, wall mounted indoor light, wall mounted indoor lights, wall mounted indoor lighting, wall mounted interior light, wall mounted interior lights, wall mounted interior lighting, interior wall mount light, interior wall mount lights, interior wall mount lighting, interior wall mounted light, interior wall mounted lights, interior wall mounted lighting, wall mount interior sconce, wall mount interior sconces, wall mount interior wall sconce, wall mount interior wall sconces, wall mounted interior sconce, wall mounted interior sconces, wall mounted interior wall sconce, wall mounted interior wall sconces, wall mount indoor sconce, wall mount indoor sconces, wall mount indoor wall sconce, wall mount indoor wall sconces, wall mounted indoor sconce, wall mounted indoor sconces, wall mounted indoor wall sconce, wall mounted indoor wall sconces, Indoor barn light wall sconce, Indoor barn light wall sconces, Indoor sconce, Indoor sconces, Indoor wall sconce, Indoor wall sconces, Indoor sconce light, Indoor sconce lights, Indoor sconce lighting, Indoor wall light, Indoor wall lights, Indoor wall lighting, Indoor light wall sconce, Indoor light wall sconces, Indoor light, Indoor lights, Indoor lighting,	Huxley Machine Age Wall Mount \| Barn Light Electric				930.000000	1531,1610,1820,1832,1899M	177726	Barn Light Electric Company	21	huxley-machine-age-wall-mount	1887/1896/1899	B