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 210, 10
ID Product Size list
211 M1032
Picture Product Size(mm) Price Stock Quantity Order
600×120000
212 M1033
Picture Product Size(mm) Price Stock Quantity Order
600×120000
213 M1001
Picture Product Size(mm) Price Stock Quantity Order
214 M1002
Picture Product Size(mm) Price Stock Quantity Order
215 M1003
Picture Product Size(mm) Price Stock Quantity Order
216 M1004
Picture Product Size(mm) Price Stock Quantity Order
217 M1005
Picture Product Size(mm) Price Stock Quantity Order
218 M1006
Picture Product Size(mm) Price Stock Quantity Order
219 M1007
Picture Product Size(mm) Price Stock Quantity Order
220 M1009
Picture Product Size(mm) Price Stock Quantity Order