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 30, 10
ID Product Size list
31 C1256
Picture Product Size(mm) Price Stock Quantity Order
32 C1257
Picture Product Size(mm) Price Stock Quantity Order
33 C1258
Picture Product Size(mm) Price Stock Quantity Order
34 C1259
Picture Product Size(mm) Price Stock Quantity Order
35 C1260
Picture Product Size(mm) Price Stock Quantity Order
36 C1261
Picture Product Size(mm) Price Stock Quantity Order
37 C1262
Picture Product Size(mm) Price Stock Quantity Order
38 C1264
Picture Product Size(mm) Price Stock Quantity Order
39 C1265
Picture Product Size(mm) Price Stock Quantity Order
40 C1266
Picture Product Size(mm) Price Stock Quantity Order