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 140, 10
ID Product Size list
141 Z1509
Picture Product Size(mm) Price Stock Quantity Order
142 Z1510
Picture Product Size(mm) Price Stock Quantity Order
143 Z1511
Picture Product Size(mm) Price Stock Quantity Order
144 Z1512
Picture Product Size(mm) Price Stock Quantity Order
145 Z1514
Picture Product Size(mm) Price Stock Quantity Order
146 Z1515
Picture Product Size(mm) Price Stock Quantity Order
147 Z1516
Picture Product Size(mm) Price Stock Quantity Order
148 Z1517
Picture Product Size(mm) Price Stock Quantity Order
149 F1107
Picture Product Size(mm) Price Stock Quantity Order
500×900$751
500×1000$62.50