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
Provide an example of an equivalence relation that... Science 4.00 1 0 -
You are tasked as the Chief Information Security O... Engineering 7.00 1 0 -
could you plase let me know how to program the att... Science 7.00 1 0 -
Create the html file with a tag that state... </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/156759-vicarious-mentoring"> Vicarious Mentoring </a> </td> <td>Psychology</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/156758-create-the-html-file-with-a-title-tag-that-state"> Create the html file with a <title> tag that state... </a> </td> <td>Computer Science</td> <td><span class="price">7.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156757-description-of-a-study-that-focuses-on-teaching-c"> description of a study that focuses on teaching c... </a> </td> <td>Psychology</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/156756-need-to-use-book-for-reference-and-an-article"> Need to use book for reference and an article </a> </td> <td>Psychology</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/156755-psychology-in-the-united-states"> psychology in the United States </a> </td> <td>Psychology</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/156754-i-m-way-over-my-head-in-csc205-anyone-available"> I'm way over my head in csc205! anyone available ... </a> </td> <td>Engineering</td> <td><span class="price">7.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156753-respond-to-each-question-with-up-to-1-page-per-que"> respond to each question with up to 1 page per que... </a> </td> <td>Psychology</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/156752-prepare-a-final-research-paper-u116106"> Prepare a Final Research Paper </a> </td> <td>Psychology</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/156751-with-the-introduction-of-the-new-iphone-last-week"> With the introduction of the new iPhone last week,... </a> </td> <td>Computer Science</td> <td><span class="price">7.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156750-reading-about-the-testing-movement"> reading about the testing movement </a> </td> <td>Psychology</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/156749-what-factors-helped-support-and-spread-psychology"> What factors helped support and spread psychology </a> </td> <td>Psychology</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/156748-i-need-help-with-the-following-java-project-i-don"> I need help with the following java project. I don... </a> </td> <td>Computer Science</td> <td><span class="price">9.00</span></td> <td>1</td> <td>0</td> <td>-</td> </tr> <tr> <td> <a href="/q/tutorial/default/156747-differential-reinforcement-of-successive-approxima"> differential reinforcement of successive approxima... </a> </td> <td>Psychology</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/156746-choose-a-popular-television-show"> Choose a popular television show </a> </td> <td>Psychology</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/156745-how-to-access-and-use-databases"> how to access and use databases </a> </td> <td>Psychology</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/156744-educational-psychology"> Educational Psychology </a> </td> <td>Psychology</td> <td><span class="price">10.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="bb654ca270afb2004af3e9aa3f04e22e" 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>