Changeset 16550
- Timestamp:
- 2007/10/24 18:05:30 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php
r16546 r16550 324 324 325 325 "vw_products_allclass" => ' 326 (SELECT T5.product_id, 327 product_code_min, 328 product_code_max, 329 price01_min, 330 price01_max, 331 price02_min, 332 price02_max, 333 stock_min, 334 stock_max, 335 stock_unlimited_min, 336 stock_unlimited_max, 337 category_rank, 338 T5.category_id, 339 T5.del_flg, 340 T5.status, 341 T5.name, 342 T5.comment1, 343 T5.comment2, 344 T5.comment3, 345 T5.rank, 346 T5.main_list_comment, 347 T5.main_image, 348 T5.main_list_image, 349 T5.product_flag, 350 T5.deliv_date_id, 351 T5.sale_limit, 352 T5.point_rate, 353 T5.sale_unlimited, 354 T5.create_date, 355 T5.deliv_fee 356 FROM 357 ((SELECT T1.product_id, 358 T1.del_flg, 359 T1.status, 360 T1.name, 361 T1.comment1, 362 T1.comment2, 363 T1.comment3, 364 T1.main_list_comment, 365 T1.main_image, 366 T1.main_list_image, 367 T1.product_flag, 368 T1.deliv_date_id, 369 T1.sale_limit, 370 T1.point_rate, 371 T1.sale_unlimited, 372 T1.create_date, 373 T1.deliv_fee, 374 T2.category_id, 375 T1.rank 376 FROM dtb_products AS T1 377 LEFT JOIN dtb_product_categories AS T2 378 ON T1.product_id = T2.product_id) AS T3 379 RIGHT JOIN 380 (SELECT product_id AS product_id_sub, 381 MIN(product_code) AS product_code_min, 382 MAX(product_code) AS product_code_max, 383 MIN(price01) AS price01_min, 384 MAX(price01) AS price01_max, 385 MIN(price02) AS price02_min, 386 MAX(price02) AS price02_max, 387 MIN(stock) AS stock_min, 388 MAX(stock) AS stock_max, 389 MIN(stock_unlimited) AS stock_unlimited_min, 390 MAX(stock_unlimited) AS stock_unlimited_max 391 FROM dtb_products_class 392 GROUP BY product_id) AS T4 393 ON T3.product_id = T4.product_id_sub) AS T5 394 LEFT JOIN 395 (SELECT rank AS category_rank, 396 category_id AS sub_category_id 397 FROM dtb_category) AS T6 398 ON T5.category_id = T6.sub_category_id 326 (SELECT product_id, 327 product_code_min, 328 product_code_max, 329 price01_min, 330 price01_max, 331 price02_min, 332 price02_max, 333 stock_min, 334 stock_max, 335 stock_unlimited_min, 336 stock_unlimited_max, 337 del_flg, 338 status, 339 name, 340 comment1, 341 comment2, 342 comment3, 343 main_list_comment, 344 main_image, 345 main_list_image, 346 product_flag, 347 deliv_date_id, 348 sale_limit, 349 point_rate, 350 sale_unlimited, 351 create_date, 352 deliv_fee, 353 rank 354 ,(SELECT rank AS category_rank 355 FROM dtb_category AS T4 356 WHERE T1.category_id = T4.category_id) as category_rank 357 ,(SELECT category_id AS sub_category_id 358 FROM dtb_category T4 359 WHERE T1.category_id = T4.category_id) as category_id 360 FROM (SELECT T0.product_id, 361 T0.del_flg, 362 T0.status, 363 T0.name, 364 T0.comment1, 365 T0.comment2, 366 T0.comment3, 367 T0.main_list_comment, 368 T0.main_image, 369 T0.main_list_image, 370 T0.product_flag, 371 T0.deliv_date_id, 372 T0.sale_limit, 373 T0.point_rate, 374 T0.sale_unlimited, 375 T0.create_date, 376 T0.deliv_fee, 377 T00.category_id, 378 T00.rank 379 FROM dtb_products AS T0 380 LEFT JOIN dtb_product_categories AS T00 381 USING (product_id)) AS T1 382 RIGHT JOIN (SELECT product_id as product_id_sub, 383 MIN(product_code) AS product_code_min, 384 MAX(product_code) AS product_code_max, 385 MIN(price01) AS price01_min, 386 MAX(price01) AS price01_max, 387 MIN(price02) AS price02_min, 388 MAX(price02) AS price02_max, 389 MIN(stock) AS stock_min, 390 MAX(stock) AS stock_max, 391 MIN(stock_unlimited) AS stock_unlimited_min, 392 MAX(stock_unlimited) AS stock_unlimited_max 393 FROM dtb_products_class GROUP BY product_id) AS T2 394 ON T1.product_id = T2.product_id_sub 399 395 ) ', 400 396
Note: See TracChangeset
for help on using the changeset viewer.