Sort: Code: Stock:
Search
SELECT g.id AS group_id, g.product_code, g.product_name, g.product_width, g.product_height, g.product_long, g.album_sort_str, g.sort, g.sequence, g.group_item_num, g.pic_address_total, g.order_times, i.id AS item_id, i.product_width AS item_width, i.product_height AS item_height, i.product_long AS item_long, i.product_price_NY, i.pic_address, i.stock_num, i.item_sequence FROM wap_products_group g LEFT JOIN wap_products_group_item i ON g.id = i.product_group_id WHERE g.album_sort_str != '' AND g.show_to_public = 1 ORDER BY g.album_sort_str ASC, g.sequence ASC, g.id ASC, i.pic_address ASC, i.item_sequence ASC LIMIT 0, 10
ID Product Size list
1 Z1518
Picture Product Size(mm) Price Stock Quantity Order
1200×800$319.40
2 Z1513
Picture Product Size(mm) Price Stock Quantity Order
1000×1000$263.90
3 Z1492
Picture Product Size(mm) Price Stock Quantity Order
1000×1000$208.30
4 Z1493
Picture Product Size(mm) Price Stock Quantity Order
800×1200$208.30
5 B1367
Picture Product Size(mm) Price Stock Quantity Order
1000×1000$2500
6 D1271
Picture Product Size(mm) Price Stock Quantity Order
800×1200$208.30
7 A3302
Picture Product Size(mm) Price Stock Quantity Order
1000×1000$208.30
8 D1269
Picture Product Size(mm) Price Stock Quantity Order
1000×1000$263.90
9 A3297
Picture Product Size(mm) Price Stock Quantity Order
1200×800$222.20
1500×100000