Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select sp.sku, sp.thuong_mai_dien_tu, v.fahasa_van_phuc, fs.name, fs.category, fs.category2, fs.category3
- from fahasa_bookstore_salepower sp
- join fahasa_bookstore_stock_vanilla v on v.mabh = sp.sku
- join fahasa_stock fs on fs.sku = sp.sku
- where fahasa_van_phuc > 0
- and sp.thuong_mai_dien_tu between 10 and 10000
- and fs.category3 not in ('Truyện tranh thanh thiếu niên','Truyện tranh','Truyện đọc','Văn học Thanh Thiếu Niên')
- and fs.category2 not in ('Văn Phòng phẩm Nhập khẩu','Giáo khoa')
- and fs.category not in ('VPP - DCHS','Lịch & Agenda','Lưu niệm')
- order by sp.thuong_mai_dien_tu desc
- limit 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement