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 = '22ea5d914957c0c597a2b7d021642b64' AND c.sessionid = '36ad29232ef861b3b5af4754f686d202' OR (c.browsertoken = '22ea5d914957c0c597a2b7d021642b64' AND c.sessionid = '36ad29232ef861b3b5af4754f686d202'))
			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
	<br>=================<br>
		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 = '22ea5d914957c0c597a2b7d021642b64' AND c.sessionid = '36ad29232ef861b3b5af4754f686d202' OR (c.browsertoken = '22ea5d914957c0c597a2b7d021642b64' AND c.sessionid = '36ad29232ef861b3b5af4754f686d202'))
			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