- Towel Manufacturers Association of Pakistan -
- ٹاول مینوفیکچررز ایسوسی ایشن آف پاکستان -
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 = 'PEP A Division Pepkor Trading (PTD)') * 100
+ (customers.company_name LIKE 'PEP A Division Pepkor Trading (PTD)%') * 50
+ (customers.company_name LIKE '%PEP A Division Pepkor Trading (PTD)%') * 20
+ (search.keyword LIKE '%PEP A Division Pepkor Trading (PTD)%') * 5
+ (search.keyword LIKE '%PEP%') * 2
+ (search.keyword LIKE '%A%') * 2
+ (search.keyword LIKE '%Division%') * 2
+ (search.keyword LIKE '%Pepkor%') * 2
+ (search.keyword LIKE '%Trading%') * 2
+ (search.keyword LIKE '%(PTD)%') * 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 '%PEP%' OR customers.company_name LIKE '%PEP%' OR customers.short_name LIKE '%PEP%') AND (search.keyword LIKE '%A%' OR customers.company_name LIKE '%A%' OR customers.short_name LIKE '%A%') AND (search.keyword LIKE '%Division%' OR customers.company_name LIKE '%Division%' OR customers.short_name LIKE '%Division%') AND (search.keyword LIKE '%Pepkor%' OR customers.company_name LIKE '%Pepkor%' OR customers.short_name LIKE '%Pepkor%') AND (search.keyword LIKE '%Trading%' OR customers.company_name LIKE '%Trading%' OR customers.short_name LIKE '%Trading%') AND (search.keyword LIKE '%(PTD)%' OR customers.company_name LIKE '%(PTD)%' OR customers.short_name LIKE '%(PTD)%'))
GROUP BY customers.id
ORDER BY FIELD(customers.member_type,'Premium Plus','Premium','Standard','Basic'), relevance DESC, customers.ordering ASC
LIMIT 0,20
Search results
Companies matching “PEP A Division Pepkor Trading (PTD)”
No matching businesses found
Try a shorter keyword, check the spelling, or use advanced search for more filters.
Open advanced search