Query time 0.00197
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "5.22"
},
"grouping_operation": {
"using_filesort": false,
"nested_loop": [
{
"table": {
"table_name": "products",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"status",
"idx_company_id",
"idx_usergroup_ids"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "4K"
},
"used_columns": [
"product_id",
"product_code",
"product_type",
"status",
"company_id",
"list_price",
"amount",
"weight",
"length",
"width",
"height",
"shipping_freight",
"low_avail_limit",
"timestamp",
"updated_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",
"weight_lbs",
"weight_oz",
"product_tax_code",
"deleted_at",
"archived_at",
"position"
]
}
},
{
"table": {
"table_name": "popularity",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"total"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "32"
},
"used_columns": [
"product_id",
"total"
]
}
},
{
"table": {
"table_name": "cd",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.10",
"prefix_cost": "0.00",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"terms"
]
}
},
{
"table": {
"table_name": "product_prices",
"access_type": "ref",
"possible_keys": [
"usergroup",
"product_id",
"lower_limit",
"usergroup_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.26",
"eval_cost": "0.10",
"prefix_cost": "0.36",
"data_read_per_join": "24"
},
"used_columns": [
"product_id",
"price",
"percentage_discount",
"lower_limit",
"usergroup_id"
],
"attached_condition": "<if>(is_not_null_compl(product_prices), ((`goimagine`.`product_prices`.`lower_limit` = 1) and (`goimagine`.`product_prices`.`usergroup_id` in (0,0,1))), true)"
}
},
{
"table": {
"table_name": "product_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"product_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id",
"lang_code"
],
"key_length": "11",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.64",
"eval_cost": "0.10",
"prefix_cost": "1.09",
"data_read_per_join": "5K"
},
"used_columns": [
"product_id",
"lang_code",
"product",
"shortname",
"short_description",
"full_description",
"meta_keywords",
"meta_description",
"search_words",
"page_title",
"age_warning_message",
"promo_text",
"cls_stop_words",
"how_its_made",
"custom_header"
]
}
},
{
"table": {
"table_name": "company_descr",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.89",
"eval_cost": "0.10",
"prefix_cost": "2.08",
"data_read_per_join": "1K"
},
"used_columns": [
"company_id",
"lang_code",
"i18n_company"
]
}
},
{
"table": {
"table_name": "companies",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.68",
"eval_cost": "0.10",
"prefix_cost": "2.87",
"data_read_per_join": "14K"
},
"used_columns": [
"company_id",
"status"
],
"attached_condition": "<if>(found_match(companies), ((`goimagine`.`companies`.`status` = 'A') or false), true)"
}
},
{
"table": {
"table_name": "products_categories",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"pt"
],
"key": "pt",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 3,
"rows_produced_per_join": 3,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.30",
"prefix_cost": "3.92",
"data_read_per_join": "48"
},
"used_columns": [
"product_id",
"category_id",
"link_type",
"category_position"
]
}
},
{
"table": {
"table_name": "categories",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"c_status",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"goimagine.products_categories.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "5.00",
"cost_info": {
"read_cost": "0.75",
"eval_cost": "0.02",
"prefix_cost": "4.97",
"data_read_per_join": "402"
},
"used_columns": [
"category_id",
"usergroup_ids",
"status",
"storefront_id"
],
"attached_condition": "((`goimagine`.`categories`.`storefront_id` in (0,1)) and ((`goimagine`.`categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`goimagine`.`categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`goimagine`.`categories`.`usergroup_ids`))) and (`goimagine`.`categories`.`status` in ('A','H')))"
}
},
{
"table": {
"table_name": "seo_names",
"access_type": "ref",
"possible_keys": [
"PRIMARY",
"dispatch"
],
"key": "PRIMARY",
"used_key_parts": [
"object_id",
"type",
"dispatch",
"lang_code"
],
"key_length": "206",
"ref": [
"const",
"const",
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.13",
"eval_cost": "0.02",
"prefix_cost": "5.11",
"data_read_per_join": "260"
},
"used_columns": [
"name",
"object_id",
"type",
"dispatch",
"path",
"lang_code"
]
}
},
{
"table": {
"table_name": "company_descriptions",
"access_type": "const",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id",
"lang_code"
],
"key_length": "10",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.04",
"eval_cost": "0.02",
"prefix_cost": "5.17",
"data_read_per_join": "266"
},
"used_columns": [
"company_id",
"lang_code",
"company_description"
]
}
},
{
"table": {
"table_name": "discussion",
"access_type": "const",
"possible_keys": [
"object_id"
],
"key": "object_id",
"used_key_parts": [
"object_id",
"object_type"
],
"key_length": "6",
"ref": [
"const",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 0,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.03",
"eval_cost": "0.02",
"prefix_cost": "5.22",
"data_read_per_join": "3"
},
"used_columns": [
"object_id",
"object_type",
"type"
]
}
}
]
}
}
}
Result
| product_id |
product_code |
product_type |
status |
company_id |
list_price |
amount |
weight |
length |
width |
height |
shipping_freight |
low_avail_limit |
timestamp |
updated_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 |
weight_lbs |
weight_oz |
product_tax_code |
deleted_at |
archived_at |
position |
lang_code |
product |
shortname |
short_description |
full_description |
meta_keywords |
meta_description |
search_words |
page_title |
age_warning_message |
promo_text |
cls_stop_words |
how_its_made |
custom_header |
price |
category_ids |
popularity |
company_name |
terms |
seo_name |
seo_path |
company_description |
discussion_type |
| 302567 |
GI-302567-SPF |
P |
A |
9723 |
0.00 |
1 |
0.000 |
0 |
0 |
0 |
0.00 |
0 |
1680578626 |
1680904206 |
0 |
N |
N |
N |
B |
N |
R |
N |
N |
N |
Y |
10 |
0 |
N |
|
0 |
0 |
0 |
0 |
|
N |
0 |
P |
F |
|
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;} |
0.000 |
0.000 |
|
|
|
2147483647 |
en |
Fossilized Buffalo tooth necklace bison |
|
|
<p>Authentic Fossilized Bison tooth measures 1.5†long by 1 1/4†long.Fossilized stegodon bone beads (grey) on leather cord </p>
<p>Bison latifrons, also known as the giant bison or long-horned bison, is an extinct species of bison that lived in North America during the Pleistocene. These teeth are anywhere from 20,000-30,000 years old.</p>
<p>The symbol on this necklace is from the ancient petroglyphs found in the Snake River Canyon here in Idaho. This “star†is found on a stone in Celebration park and the sunsets and rises at these different points on the solstice and equinox times. Although we can only speculate we can not say for sure that it was a symbol used for telling the time of the year. </p>
<p>Comes with a certificate of Native American made authenticity.<br>Artist: Aodhan Crawford <br>Tribe: Cherokee</p> |
|
|
Neolithic_art,paleo,cave_art_necklace,ancient_art,paleolithic,paleolithic_necklace,fossilized_tooth,fossil,fossil_necklace,bison,brain_tan,cave_man,primitive_jewelry |
Fossilized Bison tooth necklace with Stegodon bone beads |
|
|
|
|
|
125.00000000 |
2566M,13,22370 |
201 |
The Crafty Crawford |
<p></p>
<p><em>NOTICE: I am no longer refunding processing fees on canceled or changed orders due to new policies from card processing companies that are refusing to refund their transaction fees. I am still charged regardless if the transaction is canceled or not, this is up to 4% of total fee of your order. Please note if the order is canceled due to the item not being in stock I will refund all fees. Paypal is now only taken by direct invoice</em></p>
<p>Due to policies of processing payment, payment must be refunded the SAME tender it was paid in. No exceptions.</p>
<p><em>Both Paypal and stripe no longer refunding processing fees on ANY canceled orders. This means if you place and order and cancel your order you will NOT be refunded 4% of the total purchase price. This INCLUDES if you purchase an item and you give an incorrect shipping address (I can not alter the shipping address without issuing a full refund and having you re-purchase the item) If you give me an address in an illegal state I will cancel and refund your purchase MINUS the 4% as I have stated multiple times to PLEASE check your laws before purchasing the order. Every page states NO international sales. If there has any wildlife piece or part, it is NOT eligible for international shipment, PERIOD NO international sales due to laws on Wildlife items.</em></p>
<p><em><u>Policies stated below are for <a href="http://www.craftycrawford.com/">www.craftycrawford.com</a></u></em></p>
<p><em>Returns & exchanges</em></p>
<p>ANY RETURN OF A HEADDRESS OR SPORRAN MISSING THE TAG ON THE ITEM WILL RESULT IN A 80% restocking fee NO EXCEPTIONS!! Sadly too many people have bought my items for photo shoots only to return them when done.</p>
<p>Exchange only on all returns or in-store credit must be in same condition as when shipped all packages are shipped insured. In case of a return:</p>
<p>Buyer must contact me within 3 days of delivery of problem, item MUST not be altered or have protective seal and or tag removed to qualify for return.</p>
<p>Buyer pays return shipping and original shipping.</p>
<p>All items returned are subject to a 10% restocking fee and must be returned within a week of purchase in the same condition from delivery.</p>
<p>All items returned over 2 weeks there is a 20% restocking fee must be in same condition. All items returned over 3 weeks are subject to a 55% restocking fee must be in same condition. No returns over 30days. Please be sure to return your certificate of authenticity or you will be charged $2.50 this is to ensure my information and certificate of authenticity is not used on another product and upholds my privacy.</p>
<p>Custom orders are NOT refundable.</p>
<p>Processing fees will no longer be refunded unless the item is out of stock.</p>
<p><u>Product up-keep</u></p>
<p>As with all natural things they will want to deteriorate. The ultimate enemy of my products is MOISTURE! Bacteria live and breed in moisture and wet climates. To ensure your product has a long life do NOT allow it to get wet, a few rain drops wont hurt but I do NOT suggest showering, submerging, swimming, sweat lodging ect with any of these products.</p>
<p><u>Warranty</u></p>
<p>These products are nature made. Claws break, teeth crack and bones chip. There is no warranty on the actual animal item,claw or tooth things. Everything possible to ensure this product lasts a very long time has been taken. So long as the product is taken care of in a respectful manner it should last a while. All claws are cleaned, polished and sealed as are all skulls bones etc. All items ship insured if damaged by mail you will have to submit to me the required information for me to be able to refund you. With daily wear a clasp or string can break. If this happens to you Aodhan will fix or replace it free of charge so long as the business is in standing but you must pay to ship the product to me both ways. Crafty Crawford will not replace claws/teeth etc. that are lost or broken when this happens as I can’t be responsible for natural occurring wear on cord or life itself. Some of my necklaces have lasted over 5 years on this cord. Cords are made of 100% natural cotton material NOT leather as leather breaks within 2 months of use and rots with body sweat. However if the buyer wants to pay more to have it strung on wire I will do so. Buyer will pay all shipping both ways to have any and all repair done. Please purchase insurance as Crafty Crawford will not be held responsible for lost or damaged or lost property mailed to me in the mail. Again these are natural materials made by mother nature. Aodhan does his best to make all products carefully and will work with you to make sure you are not dissapointed but can not protect against lifes happenings. Thank you for understanding items are under warranty for 30 days after purchase. Necklace clasps and string I will repair again, so long as business is in business.</p>
<p><u>Additional policies</u></p>
<p>All products are Native American made and will be accompanied by a certificate of authenticity which will bear my signature and enrollment number. I sell these items for spiritual use and connection to our roots. All items I offer for sale are legally taken and can be legally sold by myself according to the laws of the State of Idaho. I assume when you order an item from me that you can legally possess the item or items according to the laws of your state or country. Please note that if you order an item or items from me and you cannot legally possess it (them) according to the laws of your state or country, that Aiden and CHEROKEE SPIRITS will hold you responsible for any penalties and/or legal fees incurred by CHEROKEE SPIRITS or Aiden ShortCloud</p>
<p><u>No refunds on Custom Orders I will work with you until I get the item right.</u></p>
<p><u>Shipping</u></p>
<p>Do to the amount of custom orders it is very hard to find an accurate shipping price on all my items without knowing your zip code and exactly what you want. To offer the most accurate information I will give you a personal estimate if you e-mail me for accuracy.</p>
<p>I can ship your order by UPS – Ground, 3rd Day, 2nd Day Air or Next Day Air. I can also ship your order via Post Office, or other arrangements on request. Customer pays actual shipping and insurance costs, no additional handling or packing fees. Most orders are shipped within 24 hours Unless it is a custom order. Because I carry inventory of all different shapes, sizes and weights and offer several shipping options, on request I can give you an estimate at the time of your order.I accept paypal and have sold for years on ebay if you need to check my seller id on there to give you the confidence I need it is 104erica I have over 100 positive feedback as both a buyer and a seller.</p>
<p>I try to ship items with insurance as well as a delivery conformation I will do my best to give to you the most accurate price possible.</p>
<p><u>I DO NOT SHIP INTERNATIONALLY</u></p>
<p>Why?</p>
<p>1.All international wildlife shipments are subject to: USFWS Inspection Fee, Brokers Fees and International shipping charges These are VERY expensive.</p>
<p>2.Paperwork for international orders can take up to six months to process and orders under $5,000 are impractical.</p>
<p>Sorry for the inconvenience but due to federal paperwork and high export fees, I am unable to fulfill requests internationally at this time. Please see the FAQ page for more information.</p>
<p>Legality</p>
<p>All items I offer for sale are legally taken and can legally be sold by myself according to the laws of the State of Idaho. I assume when you order an item that you can in fact legally possess that item according to the laws of your state. If you order items from me and you cannot possess them according to the laws of your state or country, Cherokee spirits will hold you responsible for any penalties and/or legal fees incurred by Cherokee spirits. All offerings of merchandise shall be interpreted to mean that Cherokee Spirits is not offering to sell items of which the sale is prohibited in your state.</p>
<p>Because I carry many one-of-a-kind items, all items are sold on an availability basis only.</p>
<p> Custom orders </p>
<p> Custom orders are available in all products! Quantity of products are limited orders can take up to 2 weeks to complete. All custom orders are works of art and art can not be completed at microwave speed.</p>
<p>Remember in Native culture it is an insult to copy another person’s regalia. These pictures are for ideas to spur your own creation I will not 100% copy or match another person’s custom order. Thank you for honoring all relations.</p>
<p>Custom orders are NOT allowed to be returned as they are made for you and will not work for anyone else.</p>
<h5>NO INTERNATIONAL SALES ON ANY WILDLIFE ITEMS BY LAW</h5>
<p>All photos are ©2019 Crafty Crawford. No photo or product should be reproduced without the written permission from the owner of <a href="http://www.craftycrawford.com/">www.Craftycrawford.com</a></p>
<p>Please read the Policies and FAQ page before placing an order as you are agreeing to the terms, return policies and restocking fees. This can be located at the top bar on all pages, please view it in detail before placing an order as you are agreeing to these terms upon checkout. All items are authentic Native American made at buyer’s request tribal enrollment information will be sent with the product.</p>
<p>All animal products were legally harvested according to Idaho state regulations. Make sure you check your local wildlife regulations before ordering from me. Crafty Crawford holds you liable for all fines and legal fees if you can not purchase an item in your state and do so illegally from me. Some states do not allow the possession of certain items, if you order an item and it is confiscated Crafty Crawford will NOT replace what was taken or issue a refund for your mistake. If it is illegal for you to purchase this item Crafty Crawford is NOT offering to sell it to you. Know your laws! NO INTERNATIONAL SALES DUE TO LAWS AND RESTRICTIONS!</p>
<p>real bear claws, masked sporran, bear claw, bear claw necklace, native american crafts, ulfhednar, berserker, wampum, glass wampum. Black bear headdress, wolf headdress, historical, reenacting, pagan, shamanism, druid, viking #nativeart #nativecrafts #nativeamericanmade #nativeart #vikings #ulfhednar #berserker #wolfheaddress </p> |
product-302567 |
2566 |
<p>My name is pronounced “Ooo-Hen” I’m Native American and Gael. I’m an enrolled Citizen of The United Cherokee Aniyunwia Tribe (State recognized tribe of approx 3,000 people) I am the product of Two amazing tribal and clan based people. My Family traces our heritage to the Hester roll and Guion Miller Roll. My Cherokee family ties originated in the Carolinas. Campbell, Smith, Hightower, Murphy and other family names located around the Spartansburg trade routes. My Great Great Great grandfather Issac (Photo to the right) served in WW1 to obtain his United States citizenship and was marked as Indian Citizen on his draft card documents. We also have more Native and Scottish relatives back in the 1700’s. The Vann Family was caught in the middle of the Fur trade towards the end of the Powhatan Confederacy and eventually married into the King family (Cherokee) I have been making my native crafts since the age of 9. I am Adopted Lakota and spend a lot of my time researching family history and ever curious I am always seeking traditional knowledge to share with others along the way. Culture is often complex, being multicultural is also deeply complex. I identify as Native and Gael to encompass all of my clans and leave those doors open to both of my cultures. I recently completed my schooling and hold a Doctorate in Ancient Theology, with a Masters in Arts of Ancient Spirituality and a Bachelors of Environmental spirituality. I am always a student of History and culture and do my best to represent the ancestors I come from.</p><p>Your items are professionally cleaned and processed by a professional Taxidermist. (Idaho license #288942516) You can rest assured that only the choice hides and ethically sourced hides are used. No Fur industry hides are used. It is imperative that my business contributes to conservation. By using hunted hides all funds trickle back into permits and licensing from Idaho Fish and Game which promotes healthy and well managed forests. Taxes don’t pay for conservation…<br></p><p>Hunting/fishing/trapping licenses and tags do! By eating domestic cattle you feed the industry that is responsible for most green house gasses, but also the destruction of valuable forests to create more grazing grass for the commercial meat industry. I donate and share my crafts to my local community, my tribe, and I set aside all scraps and craft materials and ship it to various prisons across the country for their Native yards to have craft supplies. I am an enrolled member of an officially State Recognized tribe my products are Native American made in accordance with the Native American Arts and Craft act of 1990</p> |
D |