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 860, 10
ID Product Size list
861 M1069
Picture Product Size(mm) Price Stock Quantity Order
862 M1070
Picture Product Size(mm) Price Stock Quantity Order
863 M1071
Picture Product Size(mm) Price Stock Quantity Order
864 M1072
Picture Product Size(mm) Price Stock Quantity Order
865 M1073
Picture Product Size(mm) Price Stock Quantity Order
866 M1074
Picture Product Size(mm) Price Stock Quantity Order
867 M1075
Picture Product Size(mm) Price Stock Quantity Order
868 M1076
Picture Product Size(mm) Price Stock Quantity Order
869 M1077
Picture Product Size(mm) Price Stock Quantity Order
870 M1078
Picture Product Size(mm) Price Stock Quantity Order