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
shell-and-tube heat Management 2.00 1 0 -
Urea pellets Management 4.00 1 0 -
single-phase power transforme Accounting 6.00 1 0 -
values means Management 2.00 1 0 -
, describe the functionality and demonstrate it co... Science 3.00 1 0 -
Read the article posted in the attached folder Computer Science 8.00 1 0 -
Patient portals and personal health records Computer Science 5.00 1 0 -
How do selection, insertion, and the Java Collecti... Computer Science 8.00 1 0 -
Opens that file and reads through the file Computer Science 7.00 1 0 -
What ies the total number of operations that occu... Computer Science 7.00 1 0 -
Create the html file with a tag that state... </a> </td> <td>Computer Science</td> <td><span class="price">8.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156912-define-a-class-representing-an-inflatable-balloon"> Define a class representing an inflatable balloon... </a> </td> <td>Computer Science</td> <td><span class="price">5.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156911-i-can-t-seem-to-connect-to-my-database-its-giving"> I can't seem to connect to my database its giving ... </a> </td> <td>Computer Science</td> <td><span class="price">5.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156910-i-am-working-on-some-problems-in-java-using-eclips"> I am working on some problems in Java using Eclips... </a> </td> <td>Computer Science</td> <td><span class="price">6.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156909-export-the-data-in-the-listing-area-to-an-external"> Export the data in the listing area to an external... </a> </td> <td>Engineering</td> <td><span class="price">8.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156908-require-a-response-between-2-4-sentenc-each"> Require a response between 2-4 sentenc each. </a> </td> <td>Computer Science</td> <td><span class="price">5.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156907-i-truly-appreciated-your-help-last-term-i-have-re"> I truly appreciated your help last term. I have re... </a> </td> <td>Computer Science</td> <td><span class="price">10.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156906-pare-down-the-attached-list-to-information-for-3-t"> Pare down the attached list to information for 3 t... </a> </td> <td>Computer Science</td> <td><span class="price">10.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156905-missing-comma-in-sql-please-point-out-where-the-er"> missing comma in SQL please point out where the er... </a> </td> <td>Computer Science</td> <td><span class="price">6.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156904-i-need-help-with-a-program-that-reads-and-prints"> I need help with a program that reads and prints </a> </td> <td>Computer Science</td> <td><span class="price">6.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> </tbody> </table> </div> <div class="col-xs-12 home-work-text"> <h1 class="heading-h1 text-center">High Quality Custom Assignment Writing Assistance Online</h1> <p>Our solution bank provides you with common questions and answers from various fields of study. You can select your homework category and search <b>answers for homework questions</b>. 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. </p> </div> <div> <input type="hidden" name="task" value=" " /> <input type="hidden" name="boxchecked" value="0" /> <input type="hidden" name="filter_order" value="id" /> <input type="hidden" name="filter_order_Dir" value="DESC" /> <input type="hidden" name="4550632b10b4b1d7bf9293e1a6924b2f" value="1" /> </div> </div> </div> </div> </div> </section> <!-- Footer --> <footer> <section class="footer-container"> <div class="container"> <div class="row"> <div class="custom"> <div class="col-xs-12 col-sm-6 col-md-3 col-lg-3 footer-logo"> <a class="logo" href="/"> <img src="https://www.sobtell.com/images/logo.png" alt="SobTell | Your Solution to Professional Online Tutoring Help" /> </a> <div class="sobtell-address"> 19 Holly Cove Ln.Dover,kent, 19901,USA<br><br><img src="/templates/study/images/sobtell-email.png" alt="email"> </div> <div class="security_logo"> <img src="/images/seal_logo.png" alt="Seal"> </div> </div> </div> <div class="custom"> <div class="col-xs-12 col-sm-6 col-md-3 col-lg-3 footer-menu"> <h5>Company</h5> <ul class="nav navbar-nav navbar-right "> <li class="item-171"><a href="/about-us" >About us</a></li><li class="item-215"><a href="/our-team" >Our Team</a></li><li class="item-216"><a href="/scholarships" >Scholarships</a></li><li class="item-161"><a href="/refund-policy" >Refund Policy</a></li><li class="item-163"><a href="/terms-and-conditions" >Terms and Conditions</a></li><li class="item-217"><a href="/blog" >Blog</a></li><li class="item-214"><a href="/sitemap" >Sitemap</a></li><li class="item-159"><a href="/contact" >Contact us</a></li><li class="item-220"><a href="/new-whiteboard" class="display-none">New whiteboard</a></li><li class="item-108"><a href="/login">Signin</a></li> <!--li><a class="topbar-icons" href="#"><span><i class="fa fa-search top-search"></i></span></a></li--> </ul> </div> </div> <div class="custom" > <div class="col-xs-12 col-sm-12 col-md-3 text-center float-right"> <div class="footer-learn-more"> <h5>Are You a Business Owner?</h5> <p>Browse SobTell experts and find a good fit for your Business need,</p> <a class="link-btn orang-button-footer btn-hover" href="/q/findtutors">Find Experts</a></div> </div></div> <div class="mod_iflychat"> <script>var iflychat_bundle = document.createElement("script");iflychat_bundle.src = "//cdn.iflychat.com/js/iflychat-v2.min.js?app_id=8b0a5f0b-f0f3-400b-a09f-91fcb3ff3f8a";iflychat_bundle.async="async";document.body.appendChild(iflychat_bundle);</script><script>var iFlyChatDiv = document.createElement("div");iFlyChatDiv.className = 'iflychat-popup';document.body.appendChild(iFlyChatDiv);</script> </div> <div class="col-xs-12 col-sm-12 col-md-3 col-lg-3 social-box"> <h5>Connect with Us</h5> <a href="https://www.facebook.com/Sobtell-1898100007089715/" class="social-icon facebook"><i class="fa fa-facebook" aria-hidden="true"></i> <span>Facebook</span></a> <a href="https://twitter.com/Sobtell" class="social-icon twitter"><i class="fa fa-twitter" aria-hidden="true"></i> <span>Twitter</span></a> <a href="https://plus.google.com/103710232090082727574" class="social-icon google-plus"><i class="fa fa-google-plus" aria-hidden="true"></i> <span>Google Plus</span></a> <a href="#" class="social-icon linkedin"><i class="fa fa-linkedin" aria-hidden="true"></i> <span>Linked In</span></a> <a href="https://www.youtube.com/channel/UCc-q_KOyAeBZnwpU6J80dpQ" class="social-icon you-tube"><i class="fa fa-youtube-play" aria-hidden="true"></i> <span>Youtube</span></a> <script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-58a6c728e3f1ca57"></script> </div> <div class="clearfix"></div> </div> </div> </section> <section class="copy-container"> <div class="container"> <div class="row text-center"> <p class="col-xs-12">© 2026 SobTell | Your Solution to Professional Online Tutoring Help</p> </div> </div> </section> <div class="mask"></div> </footer> <script type="text/javascript"> jQuery(document).ready(function (){ jQuery(document).on('click','#system-message-container .alert .close',function (){ jQuery('#system-message-container').css({"display":"none"}); }); setTimeout(function (){jQuery('#system-message-container').css({"display":"none"});} , 5000); // Sorry about bad spacing. Also...this is jquery if you didn't notice allready. jQuery(".sub-menu-main").hover(function(){ jQuery(this).find('.sub-menu').show(); }, function(){ jQuery(this).find('.sub-menu').hide(); }) jQuery('.social-share').click(function(){ if(jQuery(this).parent().hasClass("show-icons")) { jQuery(this).parent().removeClass("show-icons"); } else { jQuery(this).parent().addClass("show-icons"); } }); window.setTimeout(function() { iflychat.startChat({ // id: '1', /* id of the user or room with whom to start chat */ // name: 'Guest', /*name of the user or room with whom to start chat */ state: 'open' /* defines if chat needs to be started in open state or minimised state*/ }); }, 30000); //time’s in milliseconds - 30 seconds = 30000 }); jQuery(window).scroll(function() { var scroll = jQuery(window).scrollTop(); if(scroll<=84) { jQuery(".sidenav").css({"top":83-scroll+"px"}); } if (scroll >= 83) { jQuery(".sidenav").addClass("sidenavtop"); } else { jQuery(".sidenav").removeClass("sidenavtop"); } }); if(jQuery.trim(jQuery("#system-message-container").html())!=""){jQuery("#system-message-container").css({"display":"block"});} jQuery('#jform_deadline_img').html('<i class="fa fa-calendar" aria-hidden="true">'); </script> </body> </html>