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 = 'Glitz Jewels 925 Sterling Silver Ring, 18K Gold Plated, Pink Tourmaline and White Zircon') * 100
+ (customers.company_name LIKE 'Glitz Jewels 925 Sterling Silver Ring, 18K Gold Plated, Pink Tourmaline and White Zircon%') * 50
+ (customers.company_name LIKE '%Glitz Jewels 925 Sterling Silver Ring, 18K Gold Plated, Pink Tourmaline and White Zircon%') * 20
+ (search.keyword LIKE '%Glitz Jewels 925 Sterling Silver Ring, 18K Gold Plated, Pink Tourmaline and White Zircon%') * 5
+ (search.keyword LIKE '%Glitz%') * 2
+ (search.keyword LIKE '%Jewels%') * 2
+ (search.keyword LIKE '%925%') * 2
+ (search.keyword LIKE '%Sterling%') * 2
+ (search.keyword LIKE '%Silver%') * 2
+ (search.keyword LIKE '%Ring,%') * 2
+ (search.keyword LIKE '%18K%') * 2
+ (search.keyword LIKE '%Gold%') * 2
+ (search.keyword LIKE '%Plated,%') * 2
+ (search.keyword LIKE '%Pink%') * 2
+ (search.keyword LIKE '%Tourmaline%') * 2
+ (search.keyword LIKE '%and%') * 2
+ (search.keyword LIKE '%White%') * 2
+ (search.keyword LIKE '%Zircon%') * 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 '%Glitz%' OR products.keywords LIKE '%Glitz%' OR customer_own_products.title LIKE '%Glitz%' OR customer_own_products.keywords LIKE '%Glitz%') AND (products.title LIKE '%Jewels%' OR products.keywords LIKE '%Jewels%' OR customer_own_products.title LIKE '%Jewels%' OR customer_own_products.keywords LIKE '%Jewels%') AND (products.title LIKE '%925%' OR products.keywords LIKE '%925%' OR customer_own_products.title LIKE '%925%' OR customer_own_products.keywords LIKE '%925%') AND (products.title LIKE '%Sterling%' OR products.keywords LIKE '%Sterling%' OR customer_own_products.title LIKE '%Sterling%' OR customer_own_products.keywords LIKE '%Sterling%') AND (products.title LIKE '%Silver%' OR products.keywords LIKE '%Silver%' OR customer_own_products.title LIKE '%Silver%' OR customer_own_products.keywords LIKE '%Silver%') AND (products.title LIKE '%Ring,%' OR products.keywords LIKE '%Ring,%' OR customer_own_products.title LIKE '%Ring,%' OR customer_own_products.keywords LIKE '%Ring,%') AND (products.title LIKE '%18K%' OR products.keywords LIKE '%18K%' OR customer_own_products.title LIKE '%18K%' OR customer_own_products.keywords LIKE '%18K%') AND (products.title LIKE '%Gold%' OR products.keywords LIKE '%Gold%' OR customer_own_products.title LIKE '%Gold%' OR customer_own_products.keywords LIKE '%Gold%') AND (products.title LIKE '%Plated,%' OR products.keywords LIKE '%Plated,%' OR customer_own_products.title LIKE '%Plated,%' OR customer_own_products.keywords LIKE '%Plated,%') AND (products.title LIKE '%Pink%' OR products.keywords LIKE '%Pink%' OR customer_own_products.title LIKE '%Pink%' OR customer_own_products.keywords LIKE '%Pink%') AND (products.title LIKE '%Tourmaline%' OR products.keywords LIKE '%Tourmaline%' OR customer_own_products.title LIKE '%Tourmaline%' OR customer_own_products.keywords LIKE '%Tourmaline%') AND (products.title LIKE '%and%' OR products.keywords LIKE '%and%' OR customer_own_products.title LIKE '%and%' OR customer_own_products.keywords LIKE '%and%') AND (products.title LIKE '%White%' OR products.keywords LIKE '%White%' OR customer_own_products.title LIKE '%White%' OR customer_own_products.keywords LIKE '%White%') AND (products.title LIKE '%Zircon%' OR products.keywords LIKE '%Zircon%' OR customer_own_products.title LIKE '%Zircon%' OR customer_own_products.keywords LIKE '%Zircon%'))
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 “Glitz Jewels 925 Sterling Silver Ring, 18K Gold Plated, Pink Tourmaline and White Zircon”
“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!”
