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

Pakistan Textile Exporters Association
پاکستان ٹیکسٹائل ایکسپورٹرز ایسوسی ایشن

  • English
  • Chinese
  • Japanese
  • Thai
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.