select count(*) as count from (SELECT distinct institute_class.insclass_id as id, institute_class.category as catg,cb.batch_price as batch_amount,cb.discount_percentage,institute_class.image as img,institute_class.c_title as title, rating(institute_class.insclass_id,1) as rte from institute_class
join course_tags on institute_class.insclass_id=course_tags.course
JOIN course_batches cb
ON cb.course_id = institute_class.insclass_id
AND cb.status = "active" where institute_class.status="1" and institute_class.admin_status=1 and is_verified(institute_class.created_by) AND ((MATCH(institute_class.c_title, private_tuts,faculty,language,lern,courses_include,courses_content,course_desc)
AGAINST("calculus teacher" IN NATURAL LANGUAGE MODE)) or course_tags.tag like "calculus teacher%")) t1
Feeds(0) |
Profiles(17) |
Courses(0) |
Jobs(1) |
Service(1) |
Product(0) |
Institute(0)
Accomodation(160)Exams(76)
Library(102)