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 = 1907 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 64194 
  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 = 64194 
  AND (
    companies.status = 'A' 
    OR cscart_products.company_id = 0
  ) 
GROUP BY 
  cscart_products.product_id

Query time 0.00152

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 = 64194 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": 6,
      "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
64194	BLE-PMD-WHU		E	C	M	W	A	0	A	1	924.00	1000	0.000	0	0	0	0.00	0	1489982400	0	N	N	N	D	N	R	N	N	N	Y	30	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;}	1769624288	Price increased 5% from $800 to $840 - DC 5/28/21 Price increased 10% from $840 to $924 - DC 6/1/22	Y		none	none	1764,1765,1766	BLE	{"22397":10}	1056013	0	0	0	0	0	0	0	0	1	0.00	0	en	Union Double Post Mount Light			<p>Every outdoor space needs lighting fixtures to make them safe and secure. Outputting ample illumination, the Union extends any outdoor area’s usability into the night. Regularly installed to brighten sidewalks, docks, and parking lots, the Union is beneficial to both residential and commercial properties. Equipping a durable post mounting with two shades allows any setting to receive these necessary touches light!</p> <p>The Union additionally carries a distinguishing character throughout exterior locations. This light is fully customizable with decorative accessories, like wire cages and cast guards, and various shade options. Marine grade contributes an additional layer of protection not found in other options, or copper and brass present a uniquely elegant aesthetic! Elevate your outdoor spaces with stylish post mount lighting!</p> <p>\|break\|</p> <ul> <li>This durable outdoor light includes a hand-built, American-made RLM warehouse shade.</li> <li>Made-to-order, learn more about the process<span> </span><a href="https://www.barnlight.com/video-gallery/">here</a>.</li> <li>Learn more about the Union Double Post Mount Light over on our<span> <a href="https://www.barnlight.com/inspiration/featured-customer-dark-sky-friendly-lights-for-the-grand-canyon/" target="_blank">blog</a>!</span></li> </ul>		Crafted entirely by hand, the Union is a durable-yet-fashionable post mount light! Fully customizable with various finishes, and our solid copper and brass shades!	BLE-PMD-WHU, The Union Double Post Mount Light, The Union Double Post Mount Lights, The Union Double Post Mount Lighting, Union Double Post Mount Light, Union Double Post Mount Lights, Union Double Post Mount Lighting, Union Double Post Mount Exterior Light, Union post mount, Union double post mount, union, double post, post mount, exterior light, lamppost, double arm, light pole light pole fixture, double light, light post , commercial lighting, parking lot lights, lot lights, walkway lighting, BLE-PMD-WHU, BLE-PMD-WHU14, BLE-PMD-WHU16, Union Decorative Double Post Mount Exterior Light, union, BLE-PMDD-WHU, decorative, double post, post mount, exterior light, american made, decorative post, double pole, pole light, warehouse shade, outdoor light, light fixture, patio light sidewalk light, park light, pole mount, BLE-PMDD-WHU14, BLE-PMDD-WHU16, outdoor lighting, exterior light, Union Brass Double Post Mount Exterior Light, Union Brass Double Post Mount Exterior Lights, Union Brass Double Post Mount Exterior Lighting, The Union Brass Double Post Mount Exterior Light, The Union Brass Double Post Mount Exterior Lights, The Union Brass Double Post Mount Exterior Lighting, Union Brass Double Post Mount Light, Union Brass Double Post Mount Lights, Union Brass Double Post Mount Lighting, The Union Brass Double Post Mount Light, The Union Brass Double Post Mount Lights, The Union Brass Double Post Mount Lighting, Union Double Post Mount Exterior Light, Union Double Post Mount Exterior Lights, Union Double Post Mount Exterior Lighting, The Union Double Post Mount Exterior Light, The Union Double Post Mount Exterior Lights, The Union Double Post Mount Exterior Lighting, Union Double Post Mount Light, Union Double Post Mount Lights, Union Double Post Mount Lighting, The Union Double Post Mount Light, The Union Double Post Mount Lights, The Union Double Post Mount Lighting, Union Brass Post Mount Exterior Light, Union Brass Post Mount Exterior Lights, Union Brass Post Mount Exterior Lighting, The Union Brass Post Mount Exterior Light, The Union Brass Post Mount Exterior Lights, The Union Brass Post Mount Exterior Lighting, Union Brass Post Mount Light, Union Brass Post Mount Lights, Union Brass Post Mount Lighting, The Union Brass Post Mount Light, The Union Brass Post Mount Lights, The Union Brass Post Mount Lighting, Union Post Mount Exterior Light, Union Post Mount Exterior Lights, Union Post Mount Exterior Lighting, The Union Post Mount Exterior Light, The Union Post Mount Exterior Lights, The Union Post Mount Exterior Lighting, Union Post Mount Light, Union Post Mount Lights, Union Post Mount Lighting, The Union Post Mount Light, The Union Post Mount Lights, The Union Post Mount Lighting, Union post mount, union post mounts, union post mount light, union post mount lights, union post mount lighting, The Union post mount, The union post mounts, The union post mount light, The union post mount lights, The union post mount lighting, brass post mount, brass post mounts, brass post mount light, brass post mount lights, brass post mount lighting, The brass post mount, The brass post mounts, The brass post mount light, The brass post mount lights, The brass post mount lighting, double post mount, double post mounts, double post mount light, double post mount lights, double post mount lighting, The double post mount, The double post mounts, The double post mount light, The double post mount lights, The double post mount lighting, Post mount, post mounts, post mount light, post mount lights, post mount lighting, Union, BLE-PMD-WHU-BRS, BLE-PMDD-WHU-COP, Union Copper Decorative Double Post Mount Exterior Light, Union Copper Decorative Double Post Mount Exterior Lights, Union Copper Decorative Double Post Mount Exterior Lighting, Union Copper Decorative Double Post Mount Light, Union Copper Decorative Double Post Mount Lights, Union Copper Decorative Double Post Mount Lighting, Union Copper Double Post Mount Exterior Light, Union Copper Double Post Mount Exterior Lights, Union Copper Double Post Mount Exterior Lighting, Union Copper Double Post Mount Light, Union Copper Double Post Mount Lights, Union Copper Double Post Mount Lighting, Copper Decorative Double Post Mount Exterior Light, Copper Decorative Double Post Mount Exterior Lights, Copper Decorative Double Post Mount Exterior Lighting, Copper Double Post Mount Exterior Light, Copper Double Post Mount Exterior Lights, Copper Double Post Mount Exterior Lighting, Copper Decorative Double Post Mount Light, Copper Decorative Double Post Mount Lights, Copper Decorative Double Post Mount Lighting, Copper Double Post Mount Light, Copper Double Post Mount Lights, Copper Double Post Mount Lighting, Copper Post Mount Light, Copper Post Mount Lights, Copper Post Mount Lighting, Union, union post mount, union post mounts, union post mount light, union post mount lights, union post mount lighting, Copper post mount, copper post mounts, Post mount copper light, post mount copper lights, post mount copper lighting, BLE-PMD-WHU-COP, Union Copper Double Post Mount Exterior Light, Union Copper Double Post Mount Exterior Lights, Union Copper Double Post Mount Exterior Lighting, The Union Copper Double Post Mount Exterior Light, The Union Copper Double Post Mount Exterior Lights, The Union Copper Double Post Mount Exterior Lighting, Union Copper Double Post Mount Light, Union Copper Double Post Mount Lights, Union Copper Double Post Mount Lighting, The Union Copper Double Post Mount Light, The Union Copper Double Post Mount Lights, The Union Copper Double Post Mount Lighting, Union Double Post Mount Exterior Light, Union Double Post Mount Exterior Lights, Union Double Post Mount Exterior Lighting, The Union Double Post Mount Exterior Light, The Union Double Post Mount Exterior Lights, The Union Double Post Mount Exterior Lighting, Union Double Post Mount Light, Union Double Post Mount Lights, Union Double Post Mount Lighting, The Union Double Post Mount Light, The Union Double Post Mount Lights, The Union Double Post Mount Lighting, Union Copper Post Mount Exterior Light, Union Copper Post Mount Exterior Lights, Union Copper Post Mount Exterior Lighting, The Union Copper Post Mount Exterior Light, The Union Copper Post Mount Exterior Lights, The Union Copper Post Mount Exterior Lighting, Union Copper Post Mount Light, Union Copper Post Mount Lights, Union Copper Post Mount Lighting, The Union Copper Post Mount Light, The Union Copper Post Mount Lights, The Union Copper Post Mount Lighting, Union Post Mount Exterior Light, Union Post Mount Exterior Lights, Union Post Mount Exterior Lighting, The Union Post Mount Exterior Light, The Union Post Mount Exterior Lights, The Union Post Mount Exterior Lighting, Union Post Mount Light, Union Post Mount Lights, Union Post Mount Lighting, The Union Post Mount Light, The Union Post Mount Lights, The Union Post Mount Lighting, Union post mount, union post mounts, union post mount light, union post mount lights, union post mount lighting, The Union post mount, The union post mounts, The union post mount light, The union post mount lights, The union post mount lighting, copper post mount, copper post mounts, copper post mount light, copper post mount lights, copper post mount lighting, The copper post mount, The copper post mounts, The copper post mount light, The copper post mount lights, The copper post mount lighting, double post mount, double post mounts, double post mount light, double post mount lights, double post mount lighting, The double post mount, The double post mounts, The double post mount light, The double post mount lights, The double post mount lighting, Post mount, post mounts, post mount light, post mount lights, post mount lighting, Union, Union Brass Decorative Double Post Mount Exterior Light, Union Brass Decorative Double Post Mount Exterior Lights, Union Brass Decorative Double Post Mount Exterior Lighting, Union Brass Decorative Double Post Mount Light, Union Brass Decorative Double Post Mount Lights, Union Brass Decorative Double Post Mount Lighting, Union Brass Double Post Mount Exterior Light, Union Brass Double Post Mount Exterior Lights, Union Brass Double Post Mount Exterior Lighting, Union Brass Double Post Mount Light, Union Brass Double Post Mount Lights, Union Brass Double Post Mount Lighting, Brass Decorative Double Post Mount Exterior Light, Brass Decorative Double Post Mount Exterior Lights, Brass Decorative Double Post Mount Exterior Lighting, Brass Double Post Mount Exterior Light, Brass Double Post Mount Exterior Lights, Brass Double Post Mount Exterior Lighting, Brass Decorative Double Post Mount Light, Brass Decorative Double Post Mount Lights, Brass Decorative Double Post Mount Lighting, Brass Double Post Mount Light, Brass Double Post Mount Lights, Brass Double Post Mount Lighting, Brass Post Mount Light, Brass Post Mount Lights, Brass Post Mount Lighting, Union, union post mount, union post mounts, union post mount light, union post mount lights, union post mount lighting, Brass post mount, brass post mounts, Post mount brass light, post mount brass lights, post mount brass lighting, BLE-PMDD-WHU-BRS, union double, 2 light union, double union, union post, union double post, union, union 2 light, union two light, BLE-PMD-WHU14, BLE-PMD-WHU16, BLE-PMDD-WHU14, BLE-PMDD-WHU16, union series, union collection, the union series, the union collection, SPS-0271, SPS 0271, SPS0271, SPS-0271, SPS 0271, SPS0271, The Union Post Mount Collection, the Union Post Mount Series, Union Post Mount Collection, Union Post Mount Series, post+mount+lights, post top, Outdoor posts lighting, Post light fixtures, post top fixture, post top fixtures, post top light fixture, post mount double, poles, pole, barn lights on pole, jadeite, jadite, jadeite light, jadite light, outdoor pole lights, light post lighting,	Union Double Post Mount Light \| Barn Light Electric				924.000000	1538,1618,1666,1835,2001,1907M	270991	Barn Light Electric Company	14	the-union-double-post-mount-exterior-light	1887/1904/1907	B