{
"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 = 64692 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": 8,
"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')"
}
}
}| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64692 | BLE-S-WHS24 | P | E | C | M | W | A | 0 | A | 1 | 630.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1560965735 | 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;} | 1767803158 | Price decreased by $78 - DC 6/15/20 Price increased 5% from $390 to $410 - DC 5/27/21 Price decreased by $7 to align with standard Original™ listing - DC 9/21/21 Price increased 10% from $403 to $444 - DC 5/20/22 Price increased by $100 to account for shipping increase - DC 9/9/22 Price increased from $544 to $630 - DC 10/12/22 Commercial price adjusted to be $83 increase from commercial base price on standard listing, with $33 upcharge to 28", per CJ - DC 8/28/24 | Y | none | none | 78,79 | BLE-S | {"21970":3,"21973":5,"22224":10} | 1008383 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | The Original™ Stem Pendant Light - 24" & 28" | <p>Amassing various influences into a single fixture, the Original™ Stem Mount Pendant transports the styles of the early 20th century to modern spaces. And now the Original™ is available with two oversized shades. This massive shade illuminates large, open spaces such as workshops, factories and warehouses. Through a process unique to Barn Light Electric, the pendant lighting is engineered by hand in the United States — utilizing only commercial grade materials. This ensures each pendant light is capable of withstanding the variety of challenges it faces when installed in those trying settings.</p> <p>However, this RLM light isn't limited to industrial settings. Demanding attention in any space, this oversized ceiling light becomes a focal point in kitchens, living rooms and commercial settings. With dozens of customization options available, create a light complementing your commercial brand or personal style.</p> <p>|break|</p> <ul> <li>Hand built with an American made RLM warehouse shade, this quality industrial lighting is a lasting stem mount option.<span> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li><span>Freight delivery required for 28" shades.</span></li> <li>Read more about The <span>Original™ Stem Mount Pendant Light over at our<span> </span><a title="All You Need To Know: The Original™ Stem Mount Pendant Light" href="https://www.barnlight.com/inspiration/all-you-need-to-know-the-original-stem-mount-pendant/" target="_blank">blog</a>!</span></li> </ul> | extra large light, heavy duty pendant, large barn light, large pendant shade, extra large RLM light, huge barn light stem mount, original pendant light fixture | Original™ stem mount pendant is now available in two larger sizes. This over-sized warehouse shade is ideal for lighting tall commercial facades and barns. | The Original™ Stem Mount Pendant 24" & 28", BLE-S-WHS24-PC, original, warehouse shade, large barn light, stem mount pendant, BLE-S-WHS28-PC, new listing, new rlm, original 24, original 24", original 28, original 28", SPS-0111, SPS 0111, SPS0111, original series, original collection, original™ series, original™ collection, originaltm collection, originaltm series, the original series, the original collection, the original™ series, the original™ collection, originaltm collection, originaltm series, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside pendant, Outside pendants, Outside ceiling pendant, Outside ceiling pendants, Outside pendant light, Outside pendant lights, Outside pendant lighting, Outside ceiling pendant, Outside ceiling pendants, large shade, large shades, extra large shade, extra large shades, large light shade, large light shades, large light fixture, large light fixtures, large lighting fixture, large lighting fixtures, 24” shade, 24” RLM shade, 24” shades, 24” warehouse shade, 24” warehouse shades, 24” ware house shade, 24” ware house shades, 24 inch shade, 24 inch shades, 24 warehouse shade, 24 inch warehouse shades, 24 ware house shade, 24 inch ware house shades, 24 inch RLM shade, 24 inch RLM shades, 24 inch warehouse shade, 24 inch ware house shade, oversized shades, 24" shade, 28" shade, 24in size pendant, H-15124, classic warehouse shade stem mount pendant rlm, classic warehouse shade, | The Original™ Stem Pendant Light - 24" & 28" | Barn Light Electric | 630.000000 | 1543,1603,1614,1704,1793,1882,2001,1890M | 669637 | Barn Light Electric Company | 74 | the-original-stem-mount-pendant-24-28 | 1887/1888/1890 | B |