JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

- Thai-Russian Chamber of Commerce -
- หอการค้าไทย-รัสเซีย - 

SELECT SQL_CALC_FOUND_ROWS customers.id, customers.member_type, customers.sub_type, customers.company_logo, customers.company_name
              , customers.slug, customers.first_name, customers.last_name, customers.phone, customers.mobile, customers.email
              , customers.designation, customers.ntn, customers.website, customers.dob, customers.photo
              , customers.city, customers.state, customers.country, customers.status, customers.package_id, customers.package_status
              , customers.short_name, customers.falcon_profile_url, customers.profile_photo
              , is_completed, profile_access
              , 0 AS relevance
                FROM customers
             WHERE 1  AND customers.status='Active' 
 AND customers.member_type IN('Basic', 'Standard', 'Premium', 'Premium Plus') 
 AND customers.parent_id = 0 
 GROUP BY customers.id 
 ORDER BY FIELD(customers.member_type,'Premium Plus','Premium','Standard','Basic'), relevance DESC, customers.ordering ASC 
 LIMIT 0,20
Business directory

Explore our network

Discover trusted members, products, services and business opportunities.