How to convert SQL statement to TP5

This article introduces the relevant knowledge of "how to convert SQL statements into TP5". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Specific problem description:

Ask God to help me translate this native SQL statement into TP5 thank you! It is the chain operation of Db:: ('name')->.

'select a.id, a. Title, a. Createkeeper time.a. Isometric solvecount (b.qid) as answer_count from fa_question a journal fathomb where a.id=b.qid and a.is_solve=0 group by b.qid order by answer_count DESC LIMIT 6'

Implementation method:

Db::table (['fa_question' = > 'axiology')-> field ('a.id, a.title, a.create_time, a.is_solve) Count (b.qid) as answer_count)-> where ('a.id=b.qid and A. isometric solvetrain0')-> group (' b.qid')-> order ('answer_count desc')-> limit (6)-> select () "how to convert a SQL statement to TP5" ends here Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!