service india

   Popular Search Categories

 Advance Search

Online Darshan

Creative Crows

Creative Crows

select sp.*,c.city_name,s.state_name,spr.*,sc.* from tbl_servicesprovided as sp,tbl_city as c,tbl_states as s,tbl_service_providers as spr,tbl_service_category as sc where (sp.service_category=sc.category_id and sp.city=c.city_id and sp.state=s.state_id and sp.provider_id=spr.provider_id and sp.service_id != 0 AND sp.status=1) AND (sp.organization_name LIKE '%mobilephone%' OR c.city_name LIKE '%mobilephone%' OR sp.area LIKE '%mobilephone%' OR sc.category_name LIKE '%mobilephone%' OR sp.services_offered LIKE '%mobilephone%' OR sp.keywords LIKE '%mobilephone%' OR spr.provider_name LIKE '%mobilephone%' OR spr.provider_contact_number LIKE '%mobilephone%' OR s.state_name LIKE '%mobilephone%' OR sp.email_id LIKE '%mobilephone%' OR sp.other_services LIKE '%mobilephone%' OR sp.pincode LIKE '%mobilephone%') order by sp.organization_name

No records found matching your search criteria...