logo

Query: SELECT DISTINCT `EstoreProduct`.`id`, `EstoreProduct`.*, `EstoreProductsCategory`.*, IFNULL(`EstoreProduct`.`active`, "") AS `active`, `EstoreProduct`.`id` FROM `estore_products` AS `EstoreProduct` LEFT JOIN `estore_brands` AS `EstoreBrand` ON (`EstoreProduct`.`brand_id` = `EstoreBrand`.`id`) LEFT JOIN `estore_products_categories` AS `EstoreProductsCategory` ON (`EstoreProductsCategory`.`product_id` = `EstoreProduct`.`id`) WHERE `EstoreProduct`.`id` != 182699 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 20067 AND `EstoreProduct`.`title` Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''s TUNGSTEN UV Sowbug - Rainbow ORDER BY `EstoreProduct`.`title` DESC LIMIT 1' at line 1 in /home/pagetree/public_html/cake/libs/model/datasources/dbo_source.php on line 492

Query: SELECT DISTINCT `EstoreProduct`.`id`, `EstoreProduct`.*, `EstoreProductsCategory`.*, IFNULL(`EstoreProduct`.`active`, "") AS `active`, `EstoreProduct`.`id` FROM `estore_products` AS `EstoreProduct` LEFT JOIN `estore_brands` AS `EstoreBrand` ON (`EstoreProduct`.`brand_id` = `EstoreBrand`.`id`) LEFT JOIN `estore_products_categories` AS `EstoreProductsCategory` ON (`EstoreProductsCategory`.`product_id` = `EstoreProduct`.`id`) WHERE `EstoreProduct`.`id` != 182699 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 20067 AND `EstoreProduct`.`title`>YFG's TUNGSTEN UV Sowbug - Rainbow ORDER BY `EstoreProduct`.`title` ASC LIMIT 1
Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''s TUNGSTEN UV Sowbug - Rainbow ORDER BY `EstoreProduct`.`title` ASC LIMIT 1' at line 1 in /home/pagetree/public_html/cake/libs/model/datasources/dbo_source.php on line 492

YFG's TUNGSTEN UV Sowbug - Rainbow

$13.95

Ordering is temporarily down, please try again shortly

Details

YFG’s UV Sowbugs are a new twist in the lineup. Tied with iridescent dubbing, locked in with a dubbing loop & Zap for durability. A bluish is hue on the back, with a black top line, secured with UV Cement. Seemed to make a difference this past season when other patterns were off.