Elasticsearch search engine

[login to view URL] runs on PHP/Maria DB - MySQli/. Require to build a site search engine on Elasticsearch to display search results in certain predefined order/rank. Limit the index and extraction of results to certain tables in the dB. Nacfun engages largely children (adults as well) with home video and image based activities, challenges, quizzes and study material. These activities are published by NacFun content writers or faculty of schools participating in the program. Kindly review the site and read the following to have the proper context.; The search results should be grouped and displayed in the following order. 1. Published by NacFun Content writer - Video challenges (instruction based physical fun sports ) - Video Contests ( fun activity like blow 100 ballons) - Image Contests (art work, drawing etc) - Image Quiz ( show a picture/image and have user answer questions) - Multiple Choice Quiz (pick the right answer) - subjective Quiz (essay based) - study material for any subject 2. Published by faculty Pretty much everything as in 1 above 3. Winners 4. Leaderboard [login to view URL] 6. FAQ 7. About Us 8. School - school pages - Gallery - Events 9. Publication by users (response submitted by users) - Pretty much everything as outlined in 1 above 10. Display promotions on top (above 1) any activities as identified by nacfun Open for improvising based upon the developers feedback.