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 250, 10
ID Product Size list
251 M1045
Picture Product Size(mm) Price Stock Quantity Order
252 M1046
Picture Product Size(mm) Price Stock Quantity Order
253 M1047
Picture Product Size(mm) Price Stock Quantity Order
254 M1048
Picture Product Size(mm) Price Stock Quantity Order
255 M1008
Picture Product Size(mm) Price Stock Quantity Order
256 131174
Picture Product Size(mm) Price Stock Quantity Order
400×600$28.51
500×700$48.81
600×800$56.71
257 130927
Picture Product Size(mm) Price Stock Quantity Order
400×600$28.51
500×700$48.81