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 120, 10
ID Product Size list
121 Z1487
Picture Product Size(mm) Price Stock Quantity Order
122 Z1488
Picture Product Size(mm) Price Stock Quantity Order
123 Z1489
Picture Product Size(mm) Price Stock Quantity Order
124 Z1490
Picture Product Size(mm) Price Stock Quantity Order
125 Z1491
Picture Product Size(mm) Price Stock Quantity Order
126 Z1494
Picture Product Size(mm) Price Stock Quantity Order
127 Z1495
Picture Product Size(mm) Price Stock Quantity Order
128 Z1496
Picture Product Size(mm) Price Stock Quantity Order
129 Z1497
Picture Product Size(mm) Price Stock Quantity Order
130 Z1498
Picture Product Size(mm) Price Stock Quantity Order