|
CC3 grey gold | ||||
Price: Sale $18.00 | ||||
Description: 120mm Timber lure designed be cast or trolled. I dives down to approx 3m with a roll and big action to trigger that bite. Strong aircraft grade stainless steel and 150kg rated glues and sealed with multiple layers of polymer resin making this a tough lure for all species and conditions. Views: 741 Date: November 30, 2016, 07:06:00 AM Rating: This product has not been rated yet.
|
SELECT i.ID_ITEM, i.commenttotal, i.totalratings, i.rating, i.primaryID_PICTURE, i.productname, p.thumbfilename, i.price,i.currency, i.qtyinstock, i.needsstock, i.date, i.views, i.saleprice, i.onsale FROM `lureshop_shop`.captainslures_store_releateditems AS r, `lureshop_shop`.captainslures_store_item as i LEFT JOIN `lureshop_shop`.captainslures_store_item_pic as p ON (i.primaryID_PICTURE = p.ID_PICTURE) WHERE r.RELATED_ID_ITEM = i.ID_ITEM AND r.ID_ITEM = 75 AND i.hideproduct = 0 ORDER BY RAND() LIMIT 20 Disk full (/tmp/#sql_4453_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") /home/lureshop1/public_html/captainslures/themes/Store.template.php 1609 Go back |