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 930, 10
ID Product Size list
931 M1139
Picture Product Size(mm) Price Stock Quantity Order
932 M1140
Picture Product Size(mm) Price Stock Quantity Order
933 M1142
Picture Product Size(mm) Price Stock Quantity Order
934 M1143
Picture Product Size(mm) Price Stock Quantity Order
935 M1144
Picture Product Size(mm) Price Stock Quantity Order
936 M1145
Picture Product Size(mm) Price Stock Quantity Order
937 M1146
Picture Product Size(mm) Price Stock Quantity Order
938 M1148
Picture Product Size(mm) Price Stock Quantity Order
939 M1149
Picture Product Size(mm) Price Stock Quantity Order
940 M1150
Picture Product Size(mm) Price Stock Quantity Order