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 = 'e4d937280cb39983019d538c2df27f6b' AND c.sessionid = '4ab2602b238118e932a5d3fdaf0c78f9' OR (c.browsertoken = 'e4d937280cb39983019d538c2df27f6b' AND c.sessionid = '4ab2602b238118e932a5d3fdaf0c78f9'))
			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