- Timestamp:
- 2010/09/22 13:23:00 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php
r18815 r18819 363 363 dtb_products.update_date, 364 364 dtb_products.deliv_date_id, 365 dtb_products.down,366 dtb_products.down_filename,367 dtb_products.down_realfilename,368 365 T4.product_code_min, 369 366 T4.product_code_max, … … 419 416 __EOS__; 420 417 418 $sql['vw_download_class'] = <<< __EOS__ 419 (SELECT 420 pc.product_id AS product_id, 421 pc.classcategory_id1 AS classcategory_id1, 422 pc.classcategory_id2 AS classcategory_id2, 423 pc.down_realfilename AS down_realfilename , 424 pc.down_filename AS down_filename, 425 o.order_id AS order_id, 426 o.customer_id AS customer_id, 427 o.payment_date AS payment_date, 428 o.status AS status 429 FROM 430 dtb_products_class pc, 431 dtb_order_detail od, 432 dtb_order o 433 WHERE 434 pc.product_id = od.product_id AND 435 pc.classcategory_id1 = od.classcategory_id1 AND 436 pc.classcategory_id2 = od.classcategory_id2 AND 437 od.order_id = o.order_id 438 ) 439 __EOS__; 440 421 441 } 422 442
Note: See TracChangeset
for help on using the changeset viewer.