{
"query_block": {
"select_id": 1,
"read_sorted_file": {
"filesort": {
"sort_key": "cscart_discussion_posts.`timestamp` desc",
"table": {
"table_name": "cscart_discussion_posts",
"access_type": "ref",
"possible_keys": ["thread_id", "thread_id_2"],
"key": "thread_id_2",
"key_length": "6",
"used_key_parts": ["thread_id", "status"],
"ref": ["const", "const"],
"rows": 6,
"filtered": 100,
"index_condition": "cscart_discussion_posts.`status` = 'A'",
"attached_condition": "cscart_discussion_posts.thread_id <=> 162178 and cscart_discussion_posts.`status` <=> 'A'"
}
}
},
"table": {
"table_name": "cscart_discussion_messages",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["post_id"],
"ref": ["cscart_migrate.cscart_discussion_posts.post_id"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_discussion_rating",
"access_type": "eq_ref",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["post_id"],
"ref": ["cscart_migrate.cscart_discussion_posts.post_id"],
"rows": 1,
"filtered": 100
}
}
}
| post_id | thread_id | name | timestamp | user_id | ip_address | status | message | rating_value | |
|---|---|---|---|---|---|---|---|---|---|
| 124438 | 162178 | Randy Donald | 1467689520 | 0 | 71.170.240.212 | A | Love the selection and our pendant lights look great. I am impressed at the way you can customize your light fixture. We actually used the pendants to create a cool industrial fixture. | 5 | |
| 124435 | 162178 | C.Murray | 1456934160 | 0 | 104.169.174.242 | A | Love my pendant lights they look like they have always been hanging over the kitchen peninsula, which is a good thing! Love buying American made products. We did experience two hitches. One light was damaged in shipping and a very small and important part to install one of the lights was missing. I was disappointed but I will say that your customer service is excellent and took care of both problems timely and to our satisfaction, | 4 | |
| 124436 | 162178 | Betty Greger | 1455817200 | 0 | 204.76.113.51 | A | I'm very pleased with my experience with your company. When I accidently doubled my order & then tried to cancel one; I messed that up as well! Your customer service person called me before I could call & fix it. Impressive! The pendant lights I ordered are a beautiful addition to my kitchen & arrived much faster than I expected. I will definitely recommend your products! | 5 | |
| 124437 | 162178 | M Rice | 1425873960 | 0 | 206.193.249.140 | A | I am very pleased with my new light. I have been looking for a fixture for my entry for a long time. The ceiling is sloped so a lot lights just wouldn't work but the Benjamin Industrial Pendant works beautifully. It was very easy to order online and worth the wait. A great product made in the USA. | 5 | |
| 124440 | 162178 | Jannetje Rocker | 1416084540 | 0 | 99.176.24.88 | A | We love our light, we have it hanging above a reclamed wood table. Derick was verry helpfull,he new we where out of town by the time the light would be mailed to our house, he called us and had it shipped to the store for us to pick it up when we got back home. This company is the American Dream come true hard work and a great product made right here in Titusville Fl. Thank you Barn Light | 5 | |
| 124439 | 162178 | n cavaliere | 1300981980 | 1002786 | 98.109.63.200 | A | We bought these barnlights for over our island in our farmhouse kitchen. The quality is very good for the price considering other companies out there that charge much more for a similar product. It's great that the fixture can be customized as well. We spent the extra $20 each for the cloth cords, but I'm not sure if this was worth it since it's barely noticeable that it's cloth. I wish it had the braided look that the Ivanhoe Sinclair fixture has. The cloth cord is smooth and no one can tell it's cloth unless you touch it (looks like any standard black extension cord). Otherwise very nice product. | 5 |