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 130, 10
ID Product Size list
131 Z1499
Picture Product Size(mm) Price Stock Quantity Order
132 Z1500
Picture Product Size(mm) Price Stock Quantity Order
133 Z1501
Picture Product Size(mm) Price Stock Quantity Order
134 Z1502
Picture Product Size(mm) Price Stock Quantity Order
135 Z1503
Picture Product Size(mm) Price Stock Quantity Order
136 Z1504
Picture Product Size(mm) Price Stock Quantity Order
137 Z1505
Picture Product Size(mm) Price Stock Quantity Order
138 Z1506
Picture Product Size(mm) Price Stock Quantity Order
139 Z1507
Picture Product Size(mm) Price Stock Quantity Order
140 Z1508
Picture Product Size(mm) Price Stock Quantity Order