Disk full (/var/tmp/#sql_5344_1); waiting for someone to free some space...
SELECT l.giftID,g.name as title,g.image FROM SC_products_gift_list l LEFT JOIN SC_products_gift g ON g.giftID = l.giftID WHERE productID =15082 AND g.enabled = 1 ORDER BY name