Popeye 100JB SH4 Gold |
View More Pictures |
Out of Stock |
Price:$25.00 |
Description: A 100mm long nose tow mid depth Jerk Bait made from Camphor Laurel for strength and long accurate casting. Views: 377 Date: February 01, 2020, 06:49:05 AM Rating: This product has not been rated yet. [Print Item] |
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`.knellerlures_store_releateditems AS r, `lureshop_shop`.knellerlures_store_item as i LEFT JOIN `lureshop_shop`.knellerlures_store_item_pic as p ON (i.primaryID_PICTURE = p.ID_PICTURE) WHERE r.RELATED_ID_ITEM = i.ID_ITEM AND r.ID_ITEM = 607 AND i.hideproduct = 0 ORDER BY RAND() LIMIT 15 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/knellerlures/sources/Store.php 6308 Go back |