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
پاکستان ٹیکسٹائل ایکسپورٹرز ایسوسی ایشن

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
              , (
        (customers.company_name = 'Color Fastness Testing') * 100
        + (customers.company_name LIKE 'Color Fastness Testing%') * 50
        + (customers.company_name LIKE '%Color Fastness Testing%') * 20
        + (search.keyword LIKE '%Color Fastness Testing%') * 5
        + (search.keyword LIKE '%Color%') * 2
        + (search.keyword LIKE '%Fastness%') * 2
        + (search.keyword LIKE '%Testing%') * 2
    ) AS relevance
                FROM customers
            LEFT JOIN customer_own_technologies ON (customer_own_technologies.created_by=customers.id)
LEFT JOIN customer_technologies ON (customers.id = customer_technologies.customer_id) 
LEFT JOIN technologies ON (technologies.id = customer_technologies.technology_id)
LEFT JOIN search ON (customers.id = search.member_id) 
 WHERE 1  AND customers.status='Active' 
 AND customers.member_type IN('Basic', 'Standard', 'Premium', 'Premium Plus') 
 AND customers.parent_id = 0 
 AND ((technologies.title LIKE '%Color%' OR technologies.keywords LIKE '%Color%' OR customer_own_technologies.title LIKE '%Color%' OR customer_own_technologies.keywords LIKE '%Color%') AND (technologies.title LIKE '%Fastness%' OR technologies.keywords LIKE '%Fastness%' OR customer_own_technologies.title LIKE '%Fastness%' OR customer_own_technologies.keywords LIKE '%Fastness%') AND (technologies.title LIKE '%Testing%' OR technologies.keywords LIKE '%Testing%' OR customer_own_technologies.title LIKE '%Testing%' OR customer_own_technologies.keywords LIKE '%Testing%')) 
 GROUP BY customers.id 
 ORDER BY FIELD(customers.member_type,'Premium Plus','Premium','Standard','Basic'), relevance DESC, customers.ordering ASC 
 LIMIT 0,20 

Fatal error: Uncaught Error: Call to a member function result() on bool in /home/ps0lut9c0m/ptea.petrolsolutions.com/application/views/themes/falcon/search.php:188 Stack trace: #0 /home/ps0lut9c0m/ptea.petrolsolutions.com/system/core/Loader.php(833): include() #1 /home/ps0lut9c0m/ptea.petrolsolutions.com/system/core/Loader.php(419): CI_Loader->_ci_load(Array) #2 /home/ps0lut9c0m/ptea.petrolsolutions.com/application/models/template.php(193): CI_Loader->view('themes/falcon/s...', Array) #3 /home/ps0lut9c0m/ptea.petrolsolutions.com/application/controllers/page.php(128): Template->load('search.php', Array) #4 /home/ps0lut9c0m/ptea.petrolsolutions.com/application/controllers/page.php(77): Page->page('search.php') #5 /home/ps0lut9c0m/ptea.petrolsolutions.com/system/core/CodeIgniter.php(359): Page->index() #6 /home/ps0lut9c0m/ptea.petrolsolutions.com/index.php(207): require_once('/home/ps0lut9c0...') #7 {main} thrown in /home/ps0lut9c0m/ptea.petrolsolutions.com/application/views/themes/falcon/search.php on line 188