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 900, 10
ID Product Size list
901 M1109
Picture Product Size(mm) Price Stock Quantity Order
902 M1110
Picture Product Size(mm) Price Stock Quantity Order
903 M1111
Picture Product Size(mm) Price Stock Quantity Order
904 M1112
Picture Product Size(mm) Price Stock Quantity Order
905 M1113
Picture Product Size(mm) Price Stock Quantity Order
906 M1114
Picture Product Size(mm) Price Stock Quantity Order
907 M1115
Picture Product Size(mm) Price Stock Quantity Order
908 M1116
Picture Product Size(mm) Price Stock Quantity Order
909 M1117
Picture Product Size(mm) Price Stock Quantity Order
910 M1118
Picture Product Size(mm) Price Stock Quantity Order