SBC55 Flat Horton |
View More Pictures |
Out of Stock |
Price:$25.00 |
Description: A 55mm nose tow shallow running lure, already become my go to skinny water bass lure. Wriggles harder then a cat walk model Views: 310 Date: October 27, 2019, 07:40:17 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 = 478 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 |