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 940, 10
ID Product Size list
941 M1151
Picture Product Size(mm) Price Stock Quantity Order
942 M1152
Picture Product Size(mm) Price Stock Quantity Order
943 M1153
Picture Product Size(mm) Price Stock Quantity Order
944 M1154
Picture Product Size(mm) Price Stock Quantity Order
945 M1155
Picture Product Size(mm) Price Stock Quantity Order
946 134160-HA3692
Picture Product Size(mm) Price Stock Quantity Order
450×600$33.62
500×700$39.92
600×800$49.32
947 134160-HA3691
Picture Product Size(mm) Price Stock Quantity Order
450×600$33.61
500×700$39.91