query=SELECT * FROM orderimages INNER JOIN orderitems ON orderitems.GalleryId = orderimages.GalleryId AND orderitems.Album = orderimages.Album AND orderitems.Type = orderimages.Type AND orderitems.ItemId = orderimages.ItemId AND orderimages.PackageId = orderitems.PackageId INNER JOIN orders ON orders.GalleryId = orderitems.GalleryId AND orders.Album = orderitems.Album AND orders.Type = orderitems.Type WHERE orders.Paid = '' AND orders.GalleryId= AND orders.Album='' AND orders.Type='' AND orderitems.ItemCode = 'C'