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 880, 10
ID Product Size list
881 M1089
Picture Product Size(mm) Price Stock Quantity Order
882 M1090
Picture Product Size(mm) Price Stock Quantity Order
883 M1091
Picture Product Size(mm) Price Stock Quantity Order
884 M1092
Picture Product Size(mm) Price Stock Quantity Order
885 M1093
Picture Product Size(mm) Price Stock Quantity Order
886 M1094
Picture Product Size(mm) Price Stock Quantity Order
887 M1095
Picture Product Size(mm) Price Stock Quantity Order
888 M1096
Picture Product Size(mm) Price Stock Quantity Order
889 M1097
Picture Product Size(mm) Price Stock Quantity Order
890 M1098
Picture Product Size(mm) Price Stock Quantity Order