Kazuyoshi Nomachi Photograhy: #getCust.orderTitle_en#：#getCust.ItemName

SELECT t.ItemID, t.CategoryID, t.SupplierID, t.ItemName_en, t.ItemDiscrip, t.ItemPrice, t.ItemImage, t.ItemImage2, t.ItemImage3, t.ItemComment1, t.ItemComment2, t.tourokudate, t.kousindate, t.hyouji, t.narabe, t.tateyoko, t.lat, t.lon, o.orditmID, o.orditmOrderID, o.orditmItemID, o.orditmQty, o.orditmNarabe, d.orderID, d.orderCustID, d.orderTitle_en, d.orderComment, c.custID, c.custName FROM Customers c, Orders d, OrderItems o, Items t WHERE t.ItemID = o.orditmItemID AND d.OrderID = o.orditmOrderID AND c.custID = d.orderCustID AND d.orderID=#URL.OrderID# AND t.ItemID=#URL.ItemID_b# ORDER BY o.orditmNarabe ASC Kazuyoshi Nomachi Photograhy: #getCust.orderTitle_en#：#getCust.ItemName_en#

	［#getCust.orderTitle_en#］ #getCust.ItemName_en#
	width="550" width="370" border="0">