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 80, 10
ID Product Size list
81 D1256
Picture Product Size(mm) Price Stock Quantity Order
82 D1257
Picture Product Size(mm) Price Stock Quantity Order
83 D1258
Picture Product Size(mm) Price Stock Quantity Order
84 D1259
Picture Product Size(mm) Price Stock Quantity Order
85 D1260
Picture Product Size(mm) Price Stock Quantity Order
86 D1261
Picture Product Size(mm) Price Stock Quantity Order
87 D1262
Picture Product Size(mm) Price Stock Quantity Order
88 D1263
Picture Product Size(mm) Price Stock Quantity Order
89 D1264
Picture Product Size(mm) Price Stock Quantity Order
90 D1265
Picture Product Size(mm) Price Stock Quantity Order