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 50, 10
ID Product Size list
51 A3275
Picture Product Size(mm) Price Stock Quantity Order
52 A3276
Picture Product Size(mm) Price Stock Quantity Order
53 A3277
Picture Product Size(mm) Price Stock Quantity Order
54 A3278
Picture Product Size(mm) Price Stock Quantity Order
55 A3279
Picture Product Size(mm) Price Stock Quantity Order
56 A3280
Picture Product Size(mm) Price Stock Quantity Order
57 A3281
Picture Product Size(mm) Price Stock Quantity Order
58 A3282
Picture Product Size(mm) Price Stock Quantity Order
59 A3283
Picture Product Size(mm) Price Stock Quantity Order
60 A3284
Picture Product Size(mm) Price Stock Quantity Order