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 910, 10
ID Product Size list
911 M1119
Picture Product Size(mm) Price Stock Quantity Order
912 M1120
Picture Product Size(mm) Price Stock Quantity Order
913 M1121
Picture Product Size(mm) Price Stock Quantity Order
914 M1122
Picture Product Size(mm) Price Stock Quantity Order
915 M1123
Picture Product Size(mm) Price Stock Quantity Order
916 M1124
Picture Product Size(mm) Price Stock Quantity Order
917 M1125
Picture Product Size(mm) Price Stock Quantity Order
918 M1126
Picture Product Size(mm) Price Stock Quantity Order
919 M1127
Picture Product Size(mm) Price Stock Quantity Order
920 M1128
Picture Product Size(mm) Price Stock Quantity Order