Changeset 20916 for branches/version-2_11-dev/data/class/SC_Product.php
- Timestamp:
- 2011/05/07 23:44:04 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/data/class/SC_Product.php
r20877 r20916 620 620 $sql = <<< __EOS__ 621 621 ( 622 SELECT dtb_products.product_id, 623 dtb_products.name, 624 dtb_products.maker_id, 625 dtb_products.status, 626 dtb_products.comment1, 627 dtb_products.comment2, 628 dtb_products.comment3, 629 dtb_products.comment4, 630 dtb_products.comment5, 631 dtb_products.comment6, 632 dtb_products.note, 633 dtb_products.main_list_comment, 634 dtb_products.main_list_image, 635 dtb_products.main_comment, 636 dtb_products.main_image, 637 dtb_products.main_large_image, 638 dtb_products.sub_title1, 639 dtb_products.sub_comment1, 640 dtb_products.sub_image1, 641 dtb_products.sub_large_image1, 642 dtb_products.sub_title2, 643 dtb_products.sub_comment2, 644 dtb_products.sub_image2, 645 dtb_products.sub_large_image2, 646 dtb_products.sub_title3, 647 dtb_products.sub_comment3, 648 dtb_products.sub_image3, 649 dtb_products.sub_large_image3, 650 dtb_products.sub_title4, 651 dtb_products.sub_comment4, 652 dtb_products.sub_image4, 653 dtb_products.sub_large_image4, 654 dtb_products.sub_title5, 655 dtb_products.sub_comment5, 656 dtb_products.sub_image5, 657 dtb_products.sub_large_image5, 658 dtb_products.sub_title6, 659 dtb_products.sub_comment6, 660 dtb_products.sub_image6, 661 dtb_products.sub_large_image6, 662 dtb_products.del_flg, 663 dtb_products.creator_id, 664 dtb_products.create_date, 665 dtb_products.update_date, 666 dtb_products.deliv_date_id, 667 T4.product_code_min, 668 T4.product_code_max, 669 T4.price01_min, 670 T4.price01_max, 671 T4.price02_min, 672 T4.price02_max, 673 T4.stock_min, 674 T4.stock_max, 675 T4.stock_unlimited_min, 676 T4.stock_unlimited_max, 677 T4.point_rate, 678 T4.deliv_fee, 679 T4.class_count 680 FROM dtb_products 681 JOIN ( 622 SELECT 0 623 ,dtb_products.product_id 624 ,dtb_products.name 625 ,dtb_products.maker_id 626 ,dtb_products.status 627 ,dtb_products.comment1 628 ,dtb_products.comment2 629 ,dtb_products.comment3 630 ,dtb_products.comment4 631 ,dtb_products.comment5 632 ,dtb_products.comment6 633 ,dtb_products.note 634 ,dtb_products.main_list_comment 635 ,dtb_products.main_list_image 636 ,dtb_products.main_comment 637 ,dtb_products.main_image 638 ,dtb_products.main_large_image 639 ,dtb_products.sub_title1 640 ,dtb_products.sub_comment1 641 ,dtb_products.sub_image1 642 ,dtb_products.sub_large_image1 643 ,dtb_products.sub_title2 644 ,dtb_products.sub_comment2 645 ,dtb_products.sub_image2 646 ,dtb_products.sub_large_image2 647 ,dtb_products.sub_title3 648 ,dtb_products.sub_comment3 649 ,dtb_products.sub_image3 650 ,dtb_products.sub_large_image3 651 ,dtb_products.sub_title4 652 ,dtb_products.sub_comment4 653 ,dtb_products.sub_image4 654 ,dtb_products.sub_large_image4 655 ,dtb_products.sub_title5 656 ,dtb_products.sub_comment5 657 ,dtb_products.sub_image5 658 ,dtb_products.sub_large_image5 659 ,dtb_products.sub_title6 660 ,dtb_products.sub_comment6 661 ,dtb_products.sub_image6 662 ,dtb_products.sub_large_image6 663 ,dtb_products.del_flg 664 ,dtb_products.creator_id 665 ,dtb_products.create_date 666 ,dtb_products.update_date 667 ,dtb_products.deliv_date_id 668 ,T4.product_code_min 669 ,T4.product_code_max 670 ,T4.price01_min 671 ,T4.price01_max 672 ,T4.price02_min 673 ,T4.price02_max 674 ,T4.stock_min 675 ,T4.stock_max 676 ,T4.stock_unlimited_min 677 ,T4.stock_unlimited_max 678 ,T4.point_rate 679 ,T4.deliv_fee 680 ,T4.class_count 681 ,dtb_maker.name AS maker_name 682 FROM dtb_products 683 JOIN ( 682 684 SELECT product_id, 683 685 MIN(product_code) AS product_code_min, … … 694 696 MAX(deliv_fee) AS deliv_fee, 695 697 COUNT(*) as class_count 696 FROM dtb_products_class 697 $whereCause 698 GROUP BY product_id 699 ) AS T4 700 ON dtb_products.product_id = T4.product_id 701 ) AS alldtl 698 FROM dtb_products_class 699 $whereCause 700 GROUP BY product_id 701 ) AS T4 702 ON dtb_products.product_id = T4.product_id 703 LEFT JOIN dtb_maker 704 ON dtb_products.maker_id = dtb_maker.maker_id 705 ) AS alldtl 702 706 __EOS__; 703 707 return $sql;
Note: See TracChangeset
for help on using the changeset viewer.