logo

E-Store

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` != 184442 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 20373 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 Tung Drop - Black Peacock 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` != 184442 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 20373 AND `EstoreProduct`.`title`>YFG's Tung Drop - Black Peacock 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 Tung Drop - Black Peacock 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

  1. Nymphs
  2. Jig Head Nymphs
  3. YFG's Tung Drop - Black Peacock

YFG's Tung Drop - Black Peacock

$16.75 - $18.50

Ordering is temporarily down, please try again shortly

Details

Stock #7323, available in sizes 12-16, Tugsten