{
"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 = 62059 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')"
}
}
}| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62059 | BLE-G-VDBW | P | E | C | M | A | A | 0 | A | 1 | 270.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1386046800 | 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;} | 1780516085 | Price increased by $55 - DC 4/28/21 37% commercial discount to base price manually added - DC 4/28/21 Price increased 10% from $245 to $270 - DC 5/24/22 | Y | none | none | 800,801,802,2865 | BLE-G | {"22117":3,"22907":5,"22599":7,"22598":7,"22911":9,"22912":10,"22596":11,"22594":11,"22595":11,"21941":12} | 1051256 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | Wilcox Vented Gooseneck Light | <p>Expertly balancing its functional obligations with decorative aesthetics, the Wilcox offers multiple directional lighting alongside classic styles. For traces of uplighting, vents are cut into the neck of a classic deep bowl shade. By evoking traditional designs, this wall light feels at home in farmhouse, industrial, and contemporary décors.</p> <p>Meticulously constructed and assembled by hand, the Wilcox demonstrates the high-quality associated with American made lighting. This fully customizable design is offered with an eclectic selection of finish colors and materials, gooseneck arm styles, and other unique options. Durable enough for installation in commercial venues, elevate any décor with stylish gooseneck lighting. </p> |break| <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW65727559 BCX0"><span class="NormalTextRun SCXW65727559 BCX0">A rugged, handcrafted</span><span class="NormalTextRun SCXW65727559 BCX0"><span> </span></span><span class="NormalTextRun SCXW65727559 BCX0">gooseneck wall light, this industrial fixture is<span> </span></span><span class="NormalTextRun SCXW65727559 BCX0">a long-</span><span class="NormalTextRun SCXW65727559 BCX0">lasting, reliable indoor/outdoor lighting option. </span></span><span class="EOP SCXW65727559 BCX0" data-ccp-props="{"201341983":0,"335559739":160,"335559740":259}"> </span></li> <li>Made-to-order, learn more about the process<span> </span><a href="/video-gallery/">here</a>.</li> <li>Learn more about the Wilcox Vented Gooseneck Light over on our<span> <a href="https://www.barnlight.com/inspiration/vented-gooseneck-lighting-an-eye-catching-favorite-for-front-porches/" target="_blank">blog</a></span>!</li> </ul> | directional exterior lighting, deep bowl gooseneck light, factory shade wall light, up light down light wall fixture, uplight gooseneck light | For multi-directional exterior lights in classic farmhouse form, hang the Wilcox Vented Gooseneck! This fixture features our deep bowl shade with subtle vents for up lighting! Shop now! | vented, vented shade, vintage warehouse, Wilcox Vented Gooseneck Light, wilcox, BLE-G-VDBW-PC, gooseneck, vinted, ented, vented wilcox, deep bowl, uplight, BLE-G-VDBW10-PC, BLE-G-VDBW12-PC, BLE-G-VDBW14-PC, BLE-G-VDBW16-PC, vented wesco, wesco, wesco vented, wesco slot, wilcox slot, uplight gooseneck, up light gooseneck, vented wesco, wesco, wesco vent, vent wesco, vent wilcox, wilcox vent, vint, BLE-G-VDBW16, BLE-G-VDBW20, BLE-G-VDBW10, BLE-G-VDBW12, BLE-G-VDBW14, Goose neck interior, Gooseneck interior, Goose neck light interior, Gooseneck light interior, interior goose neck, interior gooseneck light, interior goose neck light, SPS-0158, SPS 0158, SPS0158, Wilcox Series, Wilcox Collection, The Wilcox Series, The Wilcox Collection, Wilcox deep bowl series, wilcox deep bowl collection, the wilcox deep bowl series, the wilcox deep bowl collection, deep bowl series, deep bowl collection, wilcox vented collection, wilcox vented series, the wilcox vented collection, the wilcox vented series, SPS-0168, SPS 0168, SPS0168, Wilcox vented deep, Wilcox vented gooseneck lights, wilcox vented goosneck light, wilcox vented gooseneck light, Wall mount light, wall mount lights, wall mount lighting, Wall mount light fixture, Wall mount light fixtures, Wall mount lighting fixture, Wall mount lighting fixtures, wall mounted light, wall mounted lights, wall mounted lighting, wall mounted light fixture, wall mounted light fixtures, wall mounted lighting fixture, wall mounted lighting fixtures, Wall mount gooseneck light, Wall mount gooseneck lights, Wall mount gooseneck lighting, Wall mount gooseneck, Wall mount goosenecks, Wall mounted gooseneck light, Wall mounted gooseneck lights, Wall mounted gooseneck lighting, Wall mounted gooseneck, Wall mounted goosenecks, Vented barn light, Vented goose neck light, Vented gooseneck light, Vented goose neck lights, Vented goose neck lighting, Vented gooseneck lights, Vented gooseneck lighting, Vented goose neck, Vented goose necks, Vented gooseneck, Vented goosenecks, Barn light vented, bleg, wilcox bowl, slotted, slotted light, H-16510, H-16512, H-16514, H-16516, H-16518, H-16524, vented deep bowl shade, vented deep bowl shade cord-hung gooseneck, | Wilcox Vented Gooseneck Light | Barn Light Electric | 270.000000 | 1530,1620,1697,2002,1897M | 8401072 | Barn Light Electric Company | 256 | wilcox-vented-gooseneck-light | 1887/1896/1897 | B |