Access denied for user 'ilovetoy'@'localhost' (using password: NO)SELECT count(*) counter, SUM(quantity) quantity , sum(quantity*(case when ifnull(product_othersites.price,0)=0 then product.price else product_othersites.price end + case when ifnull(product_othersites.vat,0)=0 then product.vat else product_othersites.vat end)) as price FROM basket INNER JOIN product ON product.productid = basket.productid LEFT OUTER JOIN product_othersites on product_othersites.productid = product.productid AND product_othersites.active_flag=1 AND product_othersites.siteid=2 WHERE basket.siteid=2 and s_userid = -1;

Access denied for user 'ilovetoy'@'localhost' (using password: NO)SELECT basket.quantity, product.short_description, product.item_weight, product.shipping, price, vat, product.productid, img_thumb_url , shipping , special_shipping_time , out_of_stock_shipping_time , disappears_when_sold_flag , (stock_count-IFNULL(( SELECT SUM(quantity) FROM basket WHERE basket.productid = product.productid AND basket.s_userid <> -1 AND basket.ADDED_DATE > Date_SUB(Now(), INTERVAL 30 MINUTE) ),0)) calc_stock_count FROM basket INNER JOIN product ON product.productid = basket.productid AND basket.siteid=2 AND s_userid=-1Access denied for user 'ilovetoy'@'localhost' (using password: NO)