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 = 'WB Light Two, collared shirt, 3/4 sleeves, floral print') * 100
+ (customers.company_name LIKE 'WB Light Two, collared shirt, 3/4 sleeves, floral print%') * 50
+ (customers.company_name LIKE '%WB Light Two, collared shirt, 3/4 sleeves, floral print%') * 20
+ (search.keyword LIKE '%WB Light Two, collared shirt, 3/4 sleeves, floral print%') * 5
+ (search.keyword LIKE '%WB%') * 2
+ (search.keyword LIKE '%Light%') * 2
+ (search.keyword LIKE '%Two,%') * 2
+ (search.keyword LIKE '%collared%') * 2
+ (search.keyword LIKE '%shirt,%') * 2
+ (search.keyword LIKE '%3/4%') * 2
+ (search.keyword LIKE '%sleeves,%') * 2
+ (search.keyword LIKE '%floral%') * 2
+ (search.keyword LIKE '%print%') * 2
) AS relevance
FROM customers
LEFT JOIN customer_own_products ON (customer_own_products.created_by=customers.id)
LEFT JOIN customer_products ON (customers.id = customer_products.customer_id)
LEFT JOIN products ON (products.id = customer_products.product_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 ((products.title LIKE '%WB%' OR products.keywords LIKE '%WB%' OR customer_own_products.title LIKE '%WB%' OR customer_own_products.keywords LIKE '%WB%') AND (products.title LIKE '%Light%' OR products.keywords LIKE '%Light%' OR customer_own_products.title LIKE '%Light%' OR customer_own_products.keywords LIKE '%Light%') AND (products.title LIKE '%Two,%' OR products.keywords LIKE '%Two,%' OR customer_own_products.title LIKE '%Two,%' OR customer_own_products.keywords LIKE '%Two,%') AND (products.title LIKE '%collared%' OR products.keywords LIKE '%collared%' OR customer_own_products.title LIKE '%collared%' OR customer_own_products.keywords LIKE '%collared%') AND (products.title LIKE '%shirt,%' OR products.keywords LIKE '%shirt,%' OR customer_own_products.title LIKE '%shirt,%' OR customer_own_products.keywords LIKE '%shirt,%') AND (products.title LIKE '%3/4%' OR products.keywords LIKE '%3/4%' OR customer_own_products.title LIKE '%3/4%' OR customer_own_products.keywords LIKE '%3/4%') AND (products.title LIKE '%sleeves,%' OR products.keywords LIKE '%sleeves,%' OR customer_own_products.title LIKE '%sleeves,%' OR customer_own_products.keywords LIKE '%sleeves,%') AND (products.title LIKE '%floral%' OR products.keywords LIKE '%floral%' OR customer_own_products.title LIKE '%floral%' OR customer_own_products.keywords LIKE '%floral%') AND (products.title LIKE '%print%' OR products.keywords LIKE '%print%' OR customer_own_products.title LIKE '%print%' OR customer_own_products.keywords LIKE '%print%'))
GROUP BY customers.id
ORDER BY FIELD(customers.member_type,'Premium Plus','Premium','Standard','Basic'), relevance DESC, customers.ordering ASC
LIMIT 0,20
“Join Our YouTube Live Today — Shop, Chat & Grab Deals in Real-Time!”
“Mega Deal Week Kicks Off — Shop Live & Save Big!”
“Exclusive Product Showcase Starts Today — Watch & Win!”
“Flash Bargain Hour Now Live — Don’t Miss Out!”
