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/api/operations/ItemSearch.php

    r21771 r21809  
    153153                            $dtb_product_categories T2 
    154154                            JOIN dtb_category T3 
    155                                 USING (category_id) 
     155                              ON T2.category_id = T3.category_id 
    156156                        WHERE T2.product_id = alldtl.product_id 
    157157                        ORDER BY T3.rank DESC, T2.rank DESC 
Note: See TracChangeset for help on using the changeset viewer.