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 920, 10
ID Product Size list
921 M1129
Picture Product Size(mm) Price Stock Quantity Order
922 M1130
Picture Product Size(mm) Price Stock Quantity Order
923 M1131
Picture Product Size(mm) Price Stock Quantity Order
924 M1132
Picture Product Size(mm) Price Stock Quantity Order
925 M1133
Picture Product Size(mm) Price Stock Quantity Order
926 M1134
Picture Product Size(mm) Price Stock Quantity Order
927 M1135
Picture Product Size(mm) Price Stock Quantity Order
928 M1136
Picture Product Size(mm) Price Stock Quantity Order
929 M1137
Picture Product Size(mm) Price Stock Quantity Order
930 M1138
Picture Product Size(mm) Price Stock Quantity Order