SELECT a.userid FROM tuser a left join tcompany b on a.companyid=b.companyid where b.country='1' and b.type like'%,8,%' and b.scalea like '%,2,%' and b.scale like '%,137,%' and a.isAuth=1 and a.Grade <> '3' ORDER BY a.Grade,a.start desc,a.lastlogin desc China Travel & Outdoors Trading Company- PetsGlobal.com
Products Manufacturers News Buyers Industry
Path : Home > 93 Manufacturers > Dog Products > Travel & Outdoors
Products Manufacturers News
Refine China Travel & Outdoors Trading Company By

Region

Province

Business type

Product Categories_2

Product Categories_3

SELECT a.grade,a.userid,b.companyid,b.name_e,b.province,b.country,b.type,b.scalec,b.otherstate,a.start,b.secweb,a.sex,a.name_e as username FROM tuser a left join tcompany b on a.companyid=b.companyid where userid in(47727,45761,44452,42832) ORDER BY a.Grade,a.start desc,a.lastlogin desc
Search By : A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9
Previous Page Next Page Manufacturers : 4
Select  to 
Ms.Oceanne
Inquire Now Royaumann--Mu Group    [China-Zhejiang] Products/Services: T-Shirts , Dog Beds , Pet Dining Table , Dog Cages , Dog Toys , Dog Collars... Products Matching Results
Ms.Shanna
Inquire Now Yiwu Zhaohu Pet Products Co,.LTD    [China-Shanghai ] Products/Services: Coats & Jackets , Dog Beds , Blankets & Throws , Dog Houses , Dog Toys , Dog Leashes... Products Matching Results
Mr.kerite
Inquire Now Ningbo Chaofeng Trading Co., Ltd.    [China-Zhejiang] Products/Services: Dog Beds , Automatic Dog Feeder/Waterers , Bottles , Dog Plastic Bowl , Dog Travel Water Bowls , Dog Cages... Products Matching Results
Ms.Mandy Li
Inquire Now Ningbo Two Birds Industry Co.,Ltd    [China-Zhejiang] Products/Services: Dog Beds , Dog Plastic Bowl , Dog Carriers , Dog Cages , Dog Toys , Dog Collars... Products Matching Results
Show: 20 30 40 50 Select  to 
Go to Page

Page 1 of 1

1


Let Suppliers know exactly what you want to buy! Post Buying Requests FREE now!
advertisement

Go to Top

HOME - About PetsGlobal.com - Industry Links - Update my company - Contact PetsGlobal.com

Copyright 2001-2029 PetsGlobal.com All right reserved