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 100, 10
ID Product Size list
101 B1360
Picture Product Size(mm) Price Stock Quantity Order
102 B1361
Picture Product Size(mm) Price Stock Quantity Order
103 B1362
Picture Product Size(mm) Price Stock Quantity Order
104 B1363
Picture Product Size(mm) Price Stock Quantity Order
105 B1364
Picture Product Size(mm) Price Stock Quantity Order
106 B1365
Picture Product Size(mm) Price Stock Quantity Order
107 B1366
Picture Product Size(mm) Price Stock Quantity Order
108 E1059
Picture Product Size(mm) Price Stock Quantity Order
109 E1060
Picture Product Size(mm) Price Stock Quantity Order
110 E1061
Picture Product Size(mm) Price Stock Quantity Order