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 40, 10
ID Product Size list
41 C1267
Picture Product Size(mm) Price Stock Quantity Order
42 C1268
Picture Product Size(mm) Price Stock Quantity Order
43 C1269
Picture Product Size(mm) Price Stock Quantity Order
44 C1270
Picture Product Size(mm) Price Stock Quantity Order
45 C1271
Picture Product Size(mm) Price Stock Quantity Order
46 C1272
Picture Product Size(mm) Price Stock Quantity Order
47 C1273
Picture Product Size(mm) Price Stock Quantity Order
48 C1274
Picture Product Size(mm) Price Stock Quantity Order
49 C1275
Picture Product Size(mm) Price Stock Quantity Order
50 A3274
Picture Product Size(mm) Price Stock Quantity Order