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 870, 10
ID Product Size list
871 M1079
Picture Product Size(mm) Price Stock Quantity Order
872 M1080
Picture Product Size(mm) Price Stock Quantity Order
873 M1081
Picture Product Size(mm) Price Stock Quantity Order
874 M1082
Picture Product Size(mm) Price Stock Quantity Order
875 M1083
Picture Product Size(mm) Price Stock Quantity Order
876 M1084
Picture Product Size(mm) Price Stock Quantity Order
877 M1085
Picture Product Size(mm) Price Stock Quantity Order
878 M1086
Picture Product Size(mm) Price Stock Quantity Order
879 M1087
Picture Product Size(mm) Price Stock Quantity Order
880 M1088
Picture Product Size(mm) Price Stock Quantity Order