Notice (8): Undefined variable: isPost [CORE/Cake/Controller/Component/SecurityComponent.php, line 239]
Notice (8): Undefined variable: isPost [CORE/Cake/Controller/Component/SecurityComponent.php, line 248]
Justin Rugged Bay Gaucho Cow 4444JR Boots - Boot Round Up | Ariat, Corral, Nocona, Resistol and more Cowboy and Cowgirl Boots
Kids Boots - Justin - Rugged Bay Gaucho Cow 4444JR Missing
Color:
Size
Call 956-729-1126 To Order
Item # 4444JR
$92.70
Save $10.30
Regular $103.00

Description/Features
  • RUGGED BAY GAUCHO COW

You May Also Like...





(default) 15 queries took 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Item`.`id`, `Item`.`subsection_id`, `Item`.`brand_id`, `Item`.`modified`, `Item`.`name`, `Item`.`display`, `Item`.`googletitle`, `Item`.`googlelabels`, `Item`.`price`, `Item`.`discount`, `Item`.`cprice`, `Item`.`pretext`, `Item`.`features`, `Item`.`aftertext`, `Item`.`colors`, `Item`.`field1`, `Item`.`field1values`, `Item`.`field2`, `Item`.`field2values`, `Item`.`field3`, `Item`.`field3values`, `Item`.`field4`, `Item`.`field4values`, `Item`.`inventory`, `Item`.`availablepercent`, `Item`.`outofstock`, `Item`.`stockupdate`, `Subsection`.`id`, `Subsection`.`section_id`, `Subsection`.`name`, `Subsection`.`display`, `Subsection`.`description`, `Subsection`.`bndpos`, `Subsection`.`twidth`, `Subsection`.`theight`, `Brand`.`id`, `Brand`.`name`, `Brand`.`display`, `Brand`.`description` FROM `mikek_site`.`items` AS `Item` LEFT JOIN `mikek_site`.`subsections` AS `Subsection` ON (`Item`.`subsection_id` = `Subsection`.`id`) LEFT JOIN `mikek_site`.`brands` AS `Brand` ON (`Item`.`brand_id` = `Brand`.`id`) WHERE `Item`.`id` = 3433 LIMIT 1111
2SELECT `Image`.`id`, `Image`.`item_id`, `Image`.`name`, `Image`.`type`, `Image`.`size` FROM `mikek_site`.`images` AS `Image` WHERE `Image`.`item_id` = (3433) 111
3SELECT `Photo`.`id`, `Photo`.`item_id`, `Photo`.`name`, `Photo`.`type`, `Photo`.`size` FROM `mikek_site`.`photos` AS `Photo` WHERE `Photo`.`item_id` = (3433) 000
4SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`display`, `Tag`.`description`, `ItemsTag`.`id`, `ItemsTag`.`item_id`, `ItemsTag`.`tag_id` FROM `mikek_site`.`tags` AS `Tag` JOIN `mikek_site`.`items_tags` AS `ItemsTag` ON (`ItemsTag`.`item_id` = 3433 AND `ItemsTag`.`tag_id` = `Tag`.`id`) 000
5SELECT `Subsection`.`id`, `Subsection`.`section_id`, `Subsection`.`name`, `Subsection`.`display`, `Subsection`.`description`, `Subsection`.`bndpos`, `Subsection`.`twidth`, `Subsection`.`theight`, `Section`.`id`, `Section`.`name`, `Section`.`display`, `Section`.`title`, `Section`.`description`, `Section`.`image`, `Section`.`headerimage` FROM `mikek_site`.`subsections` AS `Subsection` LEFT JOIN `mikek_site`.`sections` AS `Section` ON (`Subsection`.`section_id` = `Section`.`id`) WHERE `section_id` = 3550
6SELECT `Item`.`id`, `Item`.`subsection_id`, `Item`.`brand_id`, `Item`.`modified`, `Item`.`name`, `Item`.`display`, `Item`.`googletitle`, `Item`.`googlelabels`, `Item`.`price`, `Item`.`discount`, `Item`.`cprice`, `Item`.`pretext`, `Item`.`features`, `Item`.`aftertext`, `Item`.`colors`, `Item`.`field1`, `Item`.`field1values`, `Item`.`field2`, `Item`.`field2values`, `Item`.`field3`, `Item`.`field3values`, `Item`.`field4`, `Item`.`field4values`, `Item`.`inventory`, `Item`.`availablepercent`, `Item`.`outofstock`, `Item`.`stockupdate` FROM `mikek_site`.`items` AS `Item` WHERE `Item`.`subsection_id` IN (30, 12, 33, 31, 32) 32320
7SELECT `Brand`.`id`, `Brand`.`name`, `Brand`.`display`, `Brand`.`description` FROM `mikek_site`.`brands` AS `Brand` WHERE 1 = 138380
8SELECT `Item`.`id`, `Item`.`subsection_id`, `Item`.`brand_id`, `Item`.`modified`, `Item`.`name`, `Item`.`display`, `Item`.`googletitle`, `Item`.`googlelabels`, `Item`.`price`, `Item`.`discount`, `Item`.`cprice`, `Item`.`pretext`, `Item`.`features`, `Item`.`aftertext`, `Item`.`colors`, `Item`.`field1`, `Item`.`field1values`, `Item`.`field2`, `Item`.`field2values`, `Item`.`field3`, `Item`.`field3values`, `Item`.`field4`, `Item`.`field4values`, `Item`.`inventory`, `Item`.`availablepercent`, `Item`.`outofstock`, `Item`.`stockupdate` FROM `mikek_site`.`items` AS `Item` WHERE `Item`.`brand_id` IN (1, 2, 3, 4, 5, 6, 8, 9, 11, 14, 15, 17, 18, 38, 20, 21, 22, 23, 24, 25, 26, 27, 30, 29, 31, 32, 33, 34, 35, 36, 37, 39, 40, 41, 42, 43, 44, 45) 7487481
9SELECT `Tmpstock`.`id`, `Tmpstock`.`brand_id`, `Tmpstock`.`style`, `Tmpstock`.`sizes`, `Tmpstock`.`stock`, `Tmpstock`.`total` FROM `mikek_site`.`tmpstocks` AS `Tmpstock` WHERE `Tmpstock`.`brand_id` IN (1, 2, 3, 4, 5, 6, 8, 9, 11, 14, 15, 17, 18, 38, 20, 21, 22, 23, 24, 25, 26, 27, 30, 29, 31, 32, 33, 34, 35, 36, 37, 39, 40, 41, 42, 43, 44, 45) 000
10SELECT `Subsection`.`id`, `Subsection`.`section_id`, `Subsection`.`name`, `Subsection`.`display`, `Subsection`.`description`, `Subsection`.`bndpos`, `Subsection`.`twidth`, `Subsection`.`theight`, `Section`.`id`, `Section`.`name`, `Section`.`display`, `Section`.`title`, `Section`.`description`, `Section`.`image`, `Section`.`headerimage` FROM `mikek_site`.`subsections` AS `Subsection` LEFT JOIN `mikek_site`.`sections` AS `Section` ON (`Subsection`.`section_id` = `Section`.`id`) WHERE `Subsection`.`id` = 12 LIMIT 1110
11SELECT `Item`.`id`, `Item`.`subsection_id`, `Item`.`brand_id`, `Item`.`modified`, `Item`.`name`, `Item`.`display`, `Item`.`googletitle`, `Item`.`googlelabels`, `Item`.`price`, `Item`.`discount`, `Item`.`cprice`, `Item`.`pretext`, `Item`.`features`, `Item`.`aftertext`, `Item`.`colors`, `Item`.`field1`, `Item`.`field1values`, `Item`.`field2`, `Item`.`field2values`, `Item`.`field3`, `Item`.`field3values`, `Item`.`field4`, `Item`.`field4values`, `Item`.`inventory`, `Item`.`availablepercent`, `Item`.`outofstock`, `Item`.`stockupdate` FROM `mikek_site`.`items` AS `Item` WHERE `Item`.`subsection_id` = (12) 32320
12SELECT `Item`.`id`, `Item`.`subsection_id`, `Item`.`brand_id`, `Item`.`modified`, `Item`.`name`, `Item`.`display`, `Item`.`googletitle`, `Item`.`googlelabels`, `Item`.`price`, `Item`.`discount`, `Item`.`cprice`, `Item`.`pretext`, `Item`.`features`, `Item`.`aftertext`, `Item`.`colors`, `Item`.`field1`, `Item`.`field1values`, `Item`.`field2`, `Item`.`field2values`, `Item`.`field3`, `Item`.`field3values`, `Item`.`field4`, `Item`.`field4values`, `Item`.`inventory`, `Item`.`availablepercent`, `Item`.`outofstock`, `Item`.`stockupdate`, `Subsection`.`id`, `Subsection`.`section_id`, `Subsection`.`name`, `Subsection`.`display`, `Subsection`.`description`, `Subsection`.`bndpos`, `Subsection`.`twidth`, `Subsection`.`theight`, `Brand`.`id`, `Brand`.`name`, `Brand`.`display`, `Brand`.`description` FROM `mikek_site`.`items` AS `Item` LEFT JOIN `mikek_site`.`subsections` AS `Subsection` ON (`Item`.`subsection_id` = `Subsection`.`id`) LEFT JOIN `mikek_site`.`brands` AS `Brand` ON (`Item`.`brand_id` = `Brand`.`id`) WHERE `subsection_id` = 12 AND `Item`.`id` <> 343331312
13SELECT `Image`.`id`, `Image`.`item_id`, `Image`.`name`, `Image`.`type`, `Image`.`size` FROM `mikek_site`.`images` AS `Image` WHERE `Image`.`item_id` IN (391, 392, 3246, 2304, 2303, 2302, 3045, 818, 845, 2861, 1394, 1399, 1404, 1407, 3774, 3056, 3642, 1833, 1842, 1846, 1853, 1857, 1858, 2995, 3732, 3134, 3135, 3136, 3434, 4010, 4011) 31311
14SELECT `Photo`.`id`, `Photo`.`item_id`, `Photo`.`name`, `Photo`.`type`, `Photo`.`size` FROM `mikek_site`.`photos` AS `Photo` WHERE `Photo`.`item_id` IN (391, 392, 3246, 2304, 2303, 2302, 3045, 818, 845, 2861, 1394, 1399, 1404, 1407, 3774, 3056, 3642, 1833, 1842, 1846, 1853, 1857, 1858, 2995, 3732, 3134, 3135, 3136, 3434, 4010, 4011) 221
15SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`display`, `Tag`.`description`, `ItemsTag`.`id`, `ItemsTag`.`item_id`, `ItemsTag`.`tag_id` FROM `mikek_site`.`tags` AS `Tag` JOIN `mikek_site`.`items_tags` AS `ItemsTag` ON (`ItemsTag`.`item_id` IN (391, 392, 3246, 2304, 2303, 2302, 3045, 818, 845, 2861, 1394, 1399, 1404, 1407, 3774, 3056, 3642, 1833, 1842, 1846, 1853, 1857, 1858, 2995, 3732, 3134, 3135, 3136, 3434, 4010, 4011) AND `ItemsTag`.`tag_id` = `Tag`.`id`) 000