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 90, 10
ID Product Size list
91 D1266
Picture Product Size(mm) Price Stock Quantity Order
92 D1267
Picture Product Size(mm) Price Stock Quantity Order
93 D1268
Picture Product Size(mm) Price Stock Quantity Order
94 D1270
Picture Product Size(mm) Price Stock Quantity Order
95 D1272
Picture Product Size(mm) Price Stock Quantity Order
96 B1355
Picture Product Size(mm) Price Stock Quantity Order
97 B1356
Picture Product Size(mm) Price Stock Quantity Order
98 B1357
Picture Product Size(mm) Price Stock Quantity Order
99 B1358
Picture Product Size(mm) Price Stock Quantity Order
100 B1359
Picture Product Size(mm) Price Stock Quantity Order