MySQL Tables with their properties:

buyers(BuyerID, TelNumber, Email, UserName, Password, ShipAdress, ShipCity, ShipState, ShipCountry, ShipZipcode)
payment(PaymentID, CardHolderName, CardType, CreditCard, CredExpMo, CardExpYr, BillingAddress, BillingCity, BillingState, BillingZipcode, BillCountry, OrderID)
products(ProductID, ProductName, SupplierID, Category, UnitPrice, Color, QuantityOnHand)
order_details(OrderID, ProductID, ItemQuantity)
orders(OrderID, BuyerID, Total_amount, Total_quantity, PaymentID, PaymentDate, OrderDate, Cancel, Paid, Fulfilled, ShipDate, ShippingID)

Using these tables, provide the MySQL query to check who ordered what item, which city and what is the payment type. Use only required columns and make sure joins are proper.