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 240, 10
ID Product Size list
241 M1035
Picture Product Size(mm) Price Stock Quantity Order
242 M1036
Picture Product Size(mm) Price Stock Quantity Order
243 M1037
Picture Product Size(mm) Price Stock Quantity Order
244 M1038
Picture Product Size(mm) Price Stock Quantity Order
245 M1039
Picture Product Size(mm) Price Stock Quantity Order
246 M1040
Picture Product Size(mm) Price Stock Quantity Order
247 M1041
Picture Product Size(mm) Price Stock Quantity Order
248 M1042
Picture Product Size(mm) Price Stock Quantity Order
249 M1043
Picture Product Size(mm) Price Stock Quantity Order
250 M1044
Picture Product Size(mm) Price Stock Quantity Order