DealQUE | United We Stand USA Pocket Knife

Price Comparison

Sorry, we were not able to find a comparison chart for this product. You might want to try searching our partner pages to compare prices.

"United We Stand" USA Pocket Knife w/ Silver CaseThe 440 Stainless Steel lock back blade measures 4 inches with an overall dimesion of 7 inches. The handle has a picture an American flag waving in the wind with fireworks overhead. The box has a picture of and American Flage and the words UNITED WE STAND.The handle is very heavy and has a polished silver steel finish. The knife has a silver bearing cover with a stylish mold of an indian feather.A stylish silver covering over wood collector's case that is lined with soft black felt and also the picture is included with this knife.Product Measurements: 5x 5x 1. This item will ship in approximately 2 business days.Case of 1Location:Sports Outdoors- Knives- Pocket Knives

(default) 49 queries took 775 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `comments`	10	10	3
2	DESCRIBE `user_comments`	8	8	1
3	DESCRIBE `users`	11	11	1
4	DESCRIBE `report_deals`	7	7	1
5	DESCRIBE `report_comments`	8	8	1
6	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	1
7	SELECT name,id,temp_cat,website FROM merchants WHERE id ="127"	1	1	0
8	SELECT category,sub_category FROM user_deals where uid = 127 AND start_date='2010-03-11 12^03^11'	0	0	0
9	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
10	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078212;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078212 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
11	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
12	( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5	5	5	742
13	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	1
14	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078212;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078213 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
15	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
16	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-09 19:09:23") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "109" AND user_comments.start_date = "2010-09-09 19:09:23" )	2	2	0
17	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-09 19:09:23" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
18	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	1
19	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078213;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078213 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
20	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
21	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "136" AND comments.start_date = "2010-09-09 18:09:09") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "136" AND user_comments.start_date = "2010-09-09 18:09:09" )	2	2	0
22	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "136" AND date = "2010-09-09 18:09:09" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
23	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
24	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078213;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078213 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		1
25	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
26	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "42" AND comments.start_date = "2010-09-09 17:09:35") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "42" AND user_comments.start_date = "2010-09-09 17:09:35" )	2	2	0
27	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "42" AND date = "2010-09-09 17:09:35" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
28	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
29	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078213;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078213 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		2
30	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	1
31	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "29" AND comments.start_date = "2010-09-09 17:09:33") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "29" AND user_comments.start_date = "2010-09-09 17:09:33" )	2	2	2
32	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "29" AND date = "2010-09-09 17:09:33" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
33	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
34	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078213;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078213 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
35	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
36	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "26" AND comments.start_date = "2010-09-09 17:09:32") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "26" AND user_comments.start_date = "2010-09-09 17:09:32" )	2	2	1
37	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "26" AND date = "2010-09-09 17:09:32" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	5
38	SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "127" and deals.start_date="2010-03-11 12:03:11"	1	1	3
39	SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '127' and start_date = '2010-03-11 12:03:11'	1	1	1
40	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "127" AND date = "2010-03-11 12^03^11" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
41	(SELECT comments.name as name, comments.subject as subject, comments.body as body, comments.posted_on as posted_on, "anon" as user_type, comments.id as ident_id, monsters.img as img FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "127" AND comments.start_date = "2010-03-11 12^03^11") UNION ALL ( SELECT users.username as name, user_comments.subject as subject, user_comments.body as body, user_comments.posted_on as posted_on, user_comments.user_id as user_type, user_comments.posted_on as ident_id, monsters.img as img FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "127" AND user_comments.start_date = "2010-03-11 12^03^11" ) ORDER BY posted_on desc	0	0	2
42	SELECT img,code from verify_imgs	13	13	0
43	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
44	SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="127"	1	1	0
45	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
46	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078213;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078213 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
47	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
48	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
49	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078213;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284078213 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0

(default) 49 queries took 775 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `comments`

DESCRIBE `user_comments`

DESCRIBE `users`

DESCRIBE `report_deals`

DESCRIBE `report_comments`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT name,id,temp_cat,website FROM merchants WHERE id ="127"

SELECT category,sub_category FROM user_deals where uid = 127 AND start_date='2010-03-11 12^03^11'

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078212;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284078212 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5

742

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-09 19:09:23") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "109" AND user_comments.start_date = "2010-09-09 19:09:23" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-09 19:09:23" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078213;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284078213 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "136" AND comments.start_date = "2010-09-09 18:09:09") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "136" AND user_comments.start_date = "2010-09-09 18:09:09" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "136" AND date = "2010-09-09 18:09:09" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "42" AND comments.start_date = "2010-09-09 17:09:35") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "42" AND user_comments.start_date = "2010-09-09 17:09:35" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "42" AND date = "2010-09-09 17:09:35" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "29" AND comments.start_date = "2010-09-09 17:09:33") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "29" AND user_comments.start_date = "2010-09-09 17:09:33" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "29" AND date = "2010-09-09 17:09:33" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "26" AND comments.start_date = "2010-09-09 17:09:32") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "26" AND user_comments.start_date = "2010-09-09 17:09:32" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "26" AND date = "2010-09-09 17:09:32" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "127" and deals.start_date="2010-03-11 12:03:11"

SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '127' and start_date = '2010-03-11 12:03:11'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "127" AND date = "2010-03-11 12^03^11" AND TIMEDIFF("2010-09-09 19:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

(SELECT comments.name as name, comments.subject as subject, comments.body as body, comments.posted_on as posted_on, "anon" as user_type, comments.id as ident_id, monsters.img as img FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "127" AND comments.start_date = "2010-03-11 12^03^11") UNION ALL ( SELECT users.username as name, user_comments.subject as subject, user_comments.body as body, user_comments.posted_on as posted_on, user_comments.user_id as user_type, user_comments.posted_on as ident_id, monsters.img as img FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "127" AND user_comments.start_date = "2010-03-11 12^03^11" ) ORDER BY posted_on desc

SELECT img,code from verify_imgs

SELECT * from monsters where is_live ="true" and rights = "public"

SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="127"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'