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 = 483 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/themes/Store.template.php 1609 Go back
|