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 890, 10
ID Product Size list
891 M1099
Picture Product Size(mm) Price Stock Quantity Order
892 M1100
Picture Product Size(mm) Price Stock Quantity Order
893 M1101
Picture Product Size(mm) Price Stock Quantity Order
894 M1102
Picture Product Size(mm) Price Stock Quantity Order
895 M1103
Picture Product Size(mm) Price Stock Quantity Order
896 M1104
Picture Product Size(mm) Price Stock Quantity Order
897 M1105
Picture Product Size(mm) Price Stock Quantity Order
898 M1106
Picture Product Size(mm) Price Stock Quantity Order
899 M1107
Picture Product Size(mm) Price Stock Quantity Order
900 M1108
Picture Product Size(mm) Price Stock Quantity Order