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 60, 10
ID Product Size list
61 A3285
Picture Product Size(mm) Price Stock Quantity Order
62 A3286
Picture Product Size(mm) Price Stock Quantity Order
63 A3287
Picture Product Size(mm) Price Stock Quantity Order
64 A3288
Picture Product Size(mm) Price Stock Quantity Order
65 A3289
Picture Product Size(mm) Price Stock Quantity Order
66 A3290
Picture Product Size(mm) Price Stock Quantity Order
67 A3291
Picture Product Size(mm) Price Stock Quantity Order
68 A3292
Picture Product Size(mm) Price Stock Quantity Order
69 A3293
Picture Product Size(mm) Price Stock Quantity Order
70 A3294
Picture Product Size(mm) Price Stock Quantity Order