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 110, 10
ID Product Size list
111 E1062
Picture Product Size(mm) Price Stock Quantity Order
112 E1063
Picture Product Size(mm) Price Stock Quantity Order
113 E1064
Picture Product Size(mm) Price Stock Quantity Order
114 E1065
Picture Product Size(mm) Price Stock Quantity Order
115 E1066
Picture Product Size(mm) Price Stock Quantity Order
116 E1067
Picture Product Size(mm) Price Stock Quantity Order
117 Z1483
Picture Product Size(mm) Price Stock Quantity Order
118 Z1484
Picture Product Size(mm) Price Stock Quantity Order
119 Z1485
Picture Product Size(mm) Price Stock Quantity Order
120 Z1486
Picture Product Size(mm) Price Stock Quantity Order