{
"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 = 64765 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": 12,
"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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64765 | BLE-G-SBS | P | E | C | P | W | A | 0 | A | 1 | 290.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1564582037 | 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;} | 1768314638 | Price increased by $41 - DC 5/10/21 35% commercial discount to base price manually added - DC 5/10/21 Price increased 5% from $216 to $227 - DC 5/24/21 Price increased from $227 to $240- DC 12/10/21 Price increased 10% from $240 to $264 - DC 5/24/22 Price decreased from $264 to $240 - DC 11/1/22 Price increased from $240 to $290 - DM 9/27/23 | Y | none | none | 322,323,324 | BLE-G | {"22266":7,"22265":7,"22264":7,"21941":8} | 1008383 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | en | Sinclair Gooseneck Light | <p>Based on designs from the 1930s, the Sinclair’s classic lines and straightforward appearance complement the various styles popular in contemporary décors. To achieve this near-universal appeal, the Sinclair centers its aesthetic on an eye-catching shallow bowl shade and iconic gooseneck arm. First developed to spread light throughout industrial settings, this shade now functions as a stylish accent piece in homes and businesses.</p> <p>Entirely made-to-order, the Sinclair is handcrafted and assembled in the United States. The customization options you select ultimately determine the Sinclair’s appearance. Choose from various shapes for the gooseneck arm, finish options including marine grade, powder coat, and natural copper or brass, and other options to create a one-of-a-kind design!</p> <p>|break|</p> <ul> <li><span data-contrast="auto" xml:lang="EN-US" lang="EN-US" class="TextRun SCXW243164382 BCX0"><span class="NormalTextRun SCXW243164382 BCX0">Meticulously handcrafted from</span><span class="NormalTextRun SCXW243164382 BCX0"><span> </span>high-quality, commercial-grade materials for a dependable</span><span class="NormalTextRun SCXW243164382 BCX0"><span> </span>indoor/outdoor wall light option.</span></span><span class="EOP SCXW243164382 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>Read more about our Sinclair Gooseneck Light over on our <a href="/inspiration/featured-customer-exterior-lighting-blends-farmhouse-modern-design/" target="_blank">blog</a>!</li> </ul> | shallow bowl gooseneck light, american made lighting fixture, gooseneck light, sinclair gas station light, vintage gas station light, barn lighting, shallow bowl reflector, flat cone RLM shade, | Based on '30s lighting, our Sinclair Gooseneck add historic charm with their compact shallow bowl shades. Customize yours with beautiful finish options! | sinclair, goodrich sinclair, sinclair gooseneck, shallow bowl gooseneck, shallow bowl, goodrich shallow bowl, BLE-G-SBS, BLE-G-SBS10, BLE-G-SBS12, BLE-G-SBS14, new listing, new rlm, new sinclair, Skylark, Skylark gooseneck, skylark shallow bowl gooseneck, shallow bowl gooseneck, BLE-G-SBS-PC, BLE-G-SBS10-PC, BLE-G-SBS12-PC, BLE-G-SBS14-PC, BLE-G-SBS16-PC, The Skylark Shallow Bowl Gooseneck Light, The Skylark Gooseneck Light, Shallow Bowl Gooseneck Light, Skylark Shallow Bowl Gooseneck Light, skylark lighting, skylark shade, gooseneck shallow bowl, gooseneck light, gooseneck lighting, outdoor lighting, outdoor gooseneck lighting, exterior gooseneck lighting, outdoor gooseneck, gooseneck wall light, gooseneck wall lighting, gooseneck wall mount, outdoor gooseneck wall light, outdoor gooseneck wall light, BLE-G-SBS10, BLE-G-SBS12, BLE-G-SBS14, BLE-G-SBS16, Sinclaire, SPS-0155, SPS0155, SPS 0155, Sinclair Series, Sinclair Collection, The Sinclair Series, The Sinclair Collection, Gooseneck Sinclair, Outside lights, Outside light, Outside lighting, Out side lights, Out side light, Out side lighting, barn light for outside, barn lights for outside, Outside gooseneck barn light, Outside gooseneck barn lights, Outside gooseneck barn lighting, Outside gooseneck light, Outside gooseneck lights, Outside gooseneck lighting, Outside gooseneck, Outside goosenecks, Out side gooseneck light, Out side gooseneck lights, Out side gooseneck lighting, Out side gooseneck, Out side goosenecks, goose neck outside lights, goose neck outside light, goose neck outside lighting, gooseneck outside lights, gooseneck outside light, gooseneck outside lighting, 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, bleg, jadeite, jadite, jadeite light, jadite light, bowl shallow, | Sinclair Gooseneck Light | Barn Light Electric | 290.000000 | 1518,1530,1600,1602,1628,1697,1707,1906,2001,1897M | 597353 | Barn Light Electric Company | 100 | sinclair-gooseneck-light | 1887/1896/1897 | B |