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 850, 10
ID Product Size list
851 M1057
Picture Product Size(mm) Price Stock Quantity Order
852 M1059
Picture Product Size(mm) Price Stock Quantity Order
853 M1060
Picture Product Size(mm) Price Stock Quantity Order
854 M1061
Picture Product Size(mm) Price Stock Quantity Order
855 M1063
Picture Product Size(mm) Price Stock Quantity Order
856 M1064
Picture Product Size(mm) Price Stock Quantity Order
857 M1065
Picture Product Size(mm) Price Stock Quantity Order
858 M1066
Picture Product Size(mm) Price Stock Quantity Order
859 M1067
Picture Product Size(mm) Price Stock Quantity Order
860 M1068
Picture Product Size(mm) Price Stock Quantity Order