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 = 'Full Automatic Cotton terry face towel sewing machine') * 100
+ (customers.company_name LIKE 'Full Automatic Cotton terry face towel sewing machine%') * 50
+ (customers.company_name LIKE '%Full Automatic Cotton terry face towel sewing machine%') * 20
+ (search.keyword LIKE '%Full Automatic Cotton terry face towel sewing machine%') * 5
+ (search.keyword LIKE '%Full%') * 2
+ (search.keyword LIKE '%Automatic%') * 2
+ (search.keyword LIKE '%Cotton%') * 2
+ (search.keyword LIKE '%terry%') * 2
+ (search.keyword LIKE '%face%') * 2
+ (search.keyword LIKE '%towel%') * 2
+ (search.keyword LIKE '%sewing%') * 2
+ (search.keyword LIKE '%machine%') * 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 '%Full%' OR technologies.keywords LIKE '%Full%' OR customer_own_technologies.title LIKE '%Full%' OR customer_own_technologies.keywords LIKE '%Full%') AND (technologies.title LIKE '%Automatic%' OR technologies.keywords LIKE '%Automatic%' OR customer_own_technologies.title LIKE '%Automatic%' OR customer_own_technologies.keywords LIKE '%Automatic%') AND (technologies.title LIKE '%Cotton%' OR technologies.keywords LIKE '%Cotton%' OR customer_own_technologies.title LIKE '%Cotton%' OR customer_own_technologies.keywords LIKE '%Cotton%') AND (technologies.title LIKE '%terry%' OR technologies.keywords LIKE '%terry%' OR customer_own_technologies.title LIKE '%terry%' OR customer_own_technologies.keywords LIKE '%terry%') AND (technologies.title LIKE '%face%' OR technologies.keywords LIKE '%face%' OR customer_own_technologies.title LIKE '%face%' OR customer_own_technologies.keywords LIKE '%face%') AND (technologies.title LIKE '%towel%' OR technologies.keywords LIKE '%towel%' OR customer_own_technologies.title LIKE '%towel%' OR customer_own_technologies.keywords LIKE '%towel%') AND (technologies.title LIKE '%sewing%' OR technologies.keywords LIKE '%sewing%' OR customer_own_technologies.title LIKE '%sewing%' OR customer_own_technologies.keywords LIKE '%sewing%') AND (technologies.title LIKE '%machine%' OR technologies.keywords LIKE '%machine%' OR customer_own_technologies.title LIKE '%machine%' OR customer_own_technologies.keywords LIKE '%machine%'))
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
Search results
Companies matching “Full Automatic Cotton terry face towel sewing machine”
