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 220, 10
ID Product Size list
221 M1010
Picture Product Size(mm) Price Stock Quantity Order
222 M1011
Picture Product Size(mm) Price Stock Quantity Order
223 M1014
Picture Product Size(mm) Price Stock Quantity Order
224 M1015
Picture Product Size(mm) Price Stock Quantity Order
225 M1016
Picture Product Size(mm) Price Stock Quantity Order
226 M1017
Picture Product Size(mm) Price Stock Quantity Order
227 M1018
Picture Product Size(mm) Price Stock Quantity Order
228 M1019
Picture Product Size(mm) Price Stock Quantity Order
229 M1020
Picture Product Size(mm) Price Stock Quantity Order
230 M1021
Picture Product Size(mm) Price Stock Quantity Order