Ignore:
Timestamp:
2012/05/07 00:21:54 (12 years ago)
Author:
nanasess
bzr:base-revision:
svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_12-dev:21808
bzr:committer:
Kentaro Ohkouchi <nanasess@fsm.ne.jp>
bzr:file-ids:

data/class/api/operations/ItemSearch.php 21713@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fversion-2_12-dev%2Fdata%2Fclass%2Fapi%2Foperations%2FItemSearch.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php 15660@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents_Recommend.php
data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore.php 21782@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fversion-2_12-dev%2Fdata%2Fclass%2Fpages%2Fadmin%2Fownersstore%2FLC_Page_Admin_OwnersStore.php
data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore_Log.php 16411@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fownersstore%2FLC_Page_Admin_OwnersStore_Log.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 15526@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ProductRank.php
data/class/pages/admin/total/LC_Page_Admin_Total.php 15600@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Ftotal%2FLC_Page_Admin_Total.php
data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Category.php 15367@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Ffrontparts%2Fbloc%2FLC_Page_FrontParts_Bloc_Category.php
data/class/pages/mypage/LC_Page_Mypage_MailView.php 17922@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_MailView.php
data/class/pages/mypage/LC_Page_Mypage_Order.php 16238@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Order.php
data/class/pages/products/LC_Page_Products_List.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_List.php
bzr:mapping-version:
v4
bzr:merge:

nanasess@fsm.ne.jp-20120506152054-2zllwij5qyhh3uxx
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
nanasess@fsm.ne.jp-20120506152147-ax0qre64rxi2o56m
bzr:revno:
4477
bzr:revprop:branch-nick:
branches/version-2_12-dev
bzr:root:
branches/version-2_12-dev
bzr:testament:

bazaar-ng testament short form 2.1
revision-id: nanasess@fsm.ne.jp-20120506152147-ax0qre64rxi2o56m
sha1: bef21b70135260bbb8f95ba265b120aa53acb518
bzr:timestamp:
2012-05-07 00:21:47.828999996 +0900
bzr:user-agent:
bzr2.4.2+bzr-svn1.1.2
Message:

#1753 (SQL の USING 句を使用しない)

  • USING を ON に修正
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/pages/admin/total/LC_Page_Admin_Total.php

    r21755 r21809  
    556556                product_name, 
    557557                SUM(quantity) AS products_count, 
    558                 COUNT(order_id) AS order_count, 
     558                COUNT(dtb_order_detail.order_id) AS order_count, 
    559559                price, 
    560560                (price * SUM(quantity)) AS total 
    561561__EOS__; 
    562562 
    563         $from = 'dtb_order_detail JOIN dtb_order USING(order_id)'; 
     563        $from = 'dtb_order_detail JOIN dtb_order ON dtb_order_detail.order_id = dtb_order.order_id'; 
    564564 
    565565        /* 
     
    591591__EOS__; 
    592592 
    593         $from   = 'dtb_order JOIN dtb_customer USING ( customer_id)'; 
     593        $from   = 'dtb_order JOIN dtb_customer ON dtb_order.customer_id = dtb_customer.customer_id'; 
    594594 
    595595        $where .= ' AND dtb_order.del_flg = 0 AND dtb_order.status <> ?'; 
Note: See TracChangeset for help on using the changeset viewer.