SELECT t.ItemID, t.CategoryID, t.SupplierID, t.ItemName,t.ItemName_en, t.ItemDiscrip, t.ItemPrice, t.ItemImage, t.ItemImage1, t.ItemComment1, t.tourokudate, t.kousindate, t.hyouji, t.narabe, t.tateyoko, o.orditmID, o.orditmOrderID, o.orditmItemID, o.orditmQty, o.orditmNarabe, d.orderID, d.orderCustID, d.orderTitle, d.orderTitle_en, d.orderComment,d.orderBunrui, 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 d.orderBunrui='Lphoto' AND t.hyouji='OK' ORDER BY t.narabe ASC <cfoutput>PHOTOGRAPHY Kazuyohi Nomachi: #getCust_b.orderTitle_en#</cfoutput>