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` != 184429 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 20372 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 'KUMOTO Pike Hooks 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` != 184429 AND `EstoreProduct`.`user_id` = 340 AND `EstoreProductsCategory`.`category_id` = 20372 AND `EstoreProduct`.`title`>K2312 KUMOTO Pike Hooks 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 'KUMOTO Pike Hooks 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. KUMOTO HOOKS
  2. K2312 KUMOTO Pike Hooks

K2312 KUMOTO Pike Hooks

$4.50

50 PK
Ordering is temporarily down, please try again shortly

Details

KUMOTO Pike Hooks

2X Strong, 4X Long, Wide Gap, Black Nickel, sizes 5/0 - 1/0 50 pks