SELECT c.cartid AS cid, c.itemid, c.varients, c.qty, c.storeid, c.sellerid, c.userid, c.spid, c.bpid, c.paymethod, c.shipperid, c.localpickup, c.digitaldownload, c.freeshipping, c.auctionorderid, c.added, c.sku, c.wonbidid, c.crypto_wonbidamount, c.wonbidamount,c.whole_variants,c.plus_property, p.buynow_qty_lot, p.buynow_qty, p.crypto_buynow_price, p.buynow_price, p.crypto_currentprice, p.currentprice, p.country, p.state, p.city, p.zipcode, p.currencyid, p.project_title,p.filtered_auctiontype, p.wholebuymin_qty,v.crypto_price, v.price, v.qty AS vqty
FROM ilance_carts c
LEFT JOIN ilance_projects p ON (c.itemid = p.project_id)
LEFT JOIN ilance_variants v ON (v.sku = c.sku AND v.project_id = p.project_id)
WHERE (c.userid = '0' AND c.browsertoken = '4ff28f78ac2b9c4d5c1fa67be39a9860' AND c.sessionid = 'e0bb7461600316c1017606cce046b84c' OR (c.browsertoken = '4ff28f78ac2b9c4d5c1fa67be39a9860' AND c.sessionid = 'e0bb7461600316c1017606cce046b84c'))
AND c.saveforlater = '0'
AND c.wishlist = '0'
AND c.isdeleted = '0'
AND c.purchased = '0'
AND p.visible = '1'
GROUP BY c.cartid
ORDER BY c.auctionorderid DESC, c.cartid DESC
=================
SELECT c.cartid AS cid, c.itemid, c.varients, c.qty, c.storeid, c.sellerid, c.userid, c.spid, c.bpid, c.paymethod, c.shipperid, c.localpickup, c.digitaldownload, c.freeshipping, c.auctionorderid, c.added, c.sku, c.wonbidid, c.crypto_wonbidamount, c.wonbidamount,c.whole_variants,c.plus_property, p.buynow_qty_lot, p.buynow_qty, p.crypto_buynow_price, p.buynow_price, p.crypto_currentprice, p.currentprice, p.country, p.state, p.city, p.zipcode, p.currencyid, p.project_title, p.filtered_auctiontype,p.wholebuymin_qty,v.crypto_price, v.price, v.qty AS vqty
FROM ilance_carts c
LEFT JOIN ilance_projects p ON (c.itemid = p.project_id)
LEFT JOIN ilance_variants v ON (v.sku = c.sku AND v.project_id = p.project_id)
WHERE (c.userid = '0' AND c.browsertoken = '4ff28f78ac2b9c4d5c1fa67be39a9860' AND c.sessionid = 'e0bb7461600316c1017606cce046b84c' OR (c.browsertoken = '4ff28f78ac2b9c4d5c1fa67be39a9860' AND c.sessionid = 'e0bb7461600316c1017606cce046b84c'))
AND c.saveforlater = '0'
AND c.wishlist = '0'
AND c.isdeleted = '0'
AND c.purchased = '0'
AND p.visible = '1'
GROUP BY c.cartid
ORDER BY c.auctionorderid DESC, c.cartid DESC