SELECT a.*,#__categories.title as category,ans.answered,o.bought FROM #__questions AS a LEFT JOIN #__categories on a.catid=#__categories.id LEFT JOIN (select qus_id,count(*) as answered from #__qus_answer group by qus_id) ans on a.id=ans.qus_id LEFT JOIN (select qus_id,count(*) as bought from #__qus_order group by qus_id) o on a.id=o.qus_id ORDER BY id DESC

Questions and tutorials

Title Field of study Price Answered Bought Deadline
John's Sporting Goods is preparing Business & Finance 8.00 1 0 -
Johnson Products is considering Business & Finance 8.00 1 0 -
Locus Quintatus, Inc., a highly profitable maker Business & Finance 8.00 1 0 -
Mitchell Auto Parts, Inc. has estimated the probab... Business & Finance 11.00 1 0 -
How would each of the following scenarios affect Business & Finance 7.00 1 0 -
Huang Industries is considering a proposed Business & Finance 8.00 1 0 -
Fox Enterprises is considering expanding Business & Finance 12.00 1 0 -
important considerations for enterprise system in... Information Systems 15.00 1 0 -
Fred and Frieda have always wanted Business & Finance 12.00 1 0 -
Hathaway, Inc., a resort company, Business & Finance 8.00 1 0 -
Hermann Corporation is considering Business & Finance 11.00 1 0 -
business process management (BPM) Information Systems 15.00 1 0 -
Business writing- Report proposal Memo, writing h... Business & Finance 10.00 1 0 -
Personal Leadership Management 10.00 1 0 -
personal knowledge management tools does this orga... Information Systems 15.00 1 0 -
Articles questions, http://www.ew.com/article/201... History 10.00 1 0 -
Learning Team collaborative discussion Information Systems 10.00 1 0 -
Define monetary policy Social Science 10.00 1 0 -
Network traffic pilfering Information Systems 13.00 1 0 -
the United States is the Juvenile Justice System. Information Systems 10.00 1 0 -

High Quality Custom Assignment Writing Assistance Online

Our solution bank provides you with common questions and answers from various fields of study. You can select your homework category and search answers for homework questions. If you are assigned an essay or any other writing assignment then you can avail our online custom assignment writing services. We provide fast and accurate online writing assistance to students experiencing problems in school, college and university writing assignments. Our online writing assistance is available 24 X7.