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 = 'MASTER MECHATRONICS CO., LTD.') * 100
        + (customers.company_name LIKE 'MASTER MECHATRONICS CO., LTD.%') * 50
        + (customers.company_name LIKE '%MASTER MECHATRONICS CO., LTD.%') * 20
        + (search.keyword LIKE '%MASTER MECHATRONICS CO., LTD.%') * 5
        + (search.keyword LIKE '%MASTER%') * 2
        + (search.keyword LIKE '%MECHATRONICS%') * 2
        + (search.keyword LIKE '%CO.,%') * 2
        + (search.keyword LIKE '%LTD.%') * 2
    ) AS relevance
                FROM customers
            LEFT JOIN search ON (search.member_id = customers.id) 
 WHERE 1  AND customers.status='Active' 
 AND customers.member_type IN('Basic', 'Standard', 'Premium', 'Premium Plus') 
 AND customers.parent_id = 0 
 AND ((search.keyword LIKE '%MASTER%' OR customers.company_name LIKE '%MASTER%' OR customers.short_name LIKE '%MASTER%') AND (search.keyword LIKE '%MECHATRONICS%' OR customers.company_name LIKE '%MECHATRONICS%' OR customers.short_name LIKE '%MECHATRONICS%') AND (search.keyword LIKE '%CO.,%' OR customers.company_name LIKE '%CO.,%' OR customers.short_name LIKE '%CO.,%') AND (search.keyword LIKE '%LTD.%' OR customers.company_name LIKE '%LTD.%' OR customers.short_name LIKE '%LTD.%')) 
 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/fti.petrolsolutions.com/application/views/themes/falcon/search.php:188 Stack trace: #0 /home/ps0lut9c0m/fti.petrolsolutions.com/system/core/Loader.php(833): include() #1 /home/ps0lut9c0m/fti.petrolsolutions.com/system/core/Loader.php(419): CI_Loader->_ci_load(Array) #2 /home/ps0lut9c0m/fti.petrolsolutions.com/application/models/template.php(190): CI_Loader->view('themes/falcon/s...', Array) #3 /home/ps0lut9c0m/fti.petrolsolutions.com/application/controllers/page.php(128): Template->load('search.php', Array) #4 /home/ps0lut9c0m/fti.petrolsolutions.com/application/controllers/page.php(77): Page->page('search.php') #5 /home/ps0lut9c0m/fti.petrolsolutions.com/system/core/CodeIgniter.php(359): Page->index() #6 /home/ps0lut9c0m/fti.petrolsolutions.com/index.php(207): require_once('/home/ps0lut9c0...') #7 {main} thrown in /home/ps0lut9c0m/fti.petrolsolutions.com/application/views/themes/falcon/search.php on line 188