Database Sql Queries Server Overload In Joomla 2

hi
i have a website with a big database using a joomla component called jreviews
there is one sql request that is too long and causes server overload
i know what it is and dont have time
need someone to fix it right away

here is a link with the debug system on so you can check the queries

Need a quick help to edit a header in Joomla 2.5 template.
I will pay $ 30 for helping insert picture and text into template.
You will be able to connect remotely to my PC using teamviewer, and from my PC you will make some changes to the template, using necessary tools.

cessful bid) :

Management Report writing + few descriptions ( about 1600 words)
Use Case Modelling & ERD Development using UML (full specifications for each Use Cases[2 or 3] and brief report/presentation of all)
Oracle Database in ORACLE 11g & SQL Queries creation
+commentaries on what was done

The whole project and some instructions will be sent after a successful bid
It should take about 10-15 hours

ve, is to install the setup on a new server and migrate the site over - hopefully leaving behind any errors on the old server. If this ends up being the option, you will also be hired to assist with this project.

Please bid on the troubleshooting of joomla on the existing server. We understand that it is not always practical to do a definite bid when the problem is unknown, so if it becomes rather complicated we can renegotiate.

Joomla 2.5.xx. So far I've been using Synk component in Joomla 1.5.xx. I have several subordinate websites. It is desirable also to be able to synchronize the Virtuemart component items and if you can also transfer images via FTP from the contributions from master to slave away. It is also preferable that in the case of deletion of the contribution to the master page, delete the post on all sides of Fame including the associated images

testing the template once I load it on our server
c. 20% payment at the end of 30 days from you sending me the template.
In return you will receive prompt milestone payments and very detailed feedback upon full completion.
IF YOU DO NOT FULLY ACCEPT THE TERMS AND CONDITIONS AS SPECIFIED ABOVE DO NOT BID ON THIS PROJECT. DO NOT SEND US JUNK RAPID FILL RESPONSES THAT DO NOT ADDRESS OUR REQUIREMENTS - THEY WILL BE DELETED UNREAD.

Need 2 things fixed in wordpress - note we have corephp extension which puts wordpress IN joomla

1. rss feed not working -needs a redirect
2. need to move the words Comment above the tags

Max budget $ 14

Need a Joomla expert installer/developer to troubleshoot install of virtuecart 2.06. Currently using extension manager to upload package but this returns a blank page.

Please state your experience with Joomla 2.5. Possibility of future development work with Joomla 2.5 so please confirm your development/design experience for customising extensions.

component in joomla 2.5 for in what I would liek to have a form submited by AJAX and have the page consequently updated without page reload. I use the mootools-more form.request function and manage to upadte the page once. But that I cannot figure out how to bind back all the javascripts: modal popup, tooltips and the ajax upadate function itself to work again.

So I need someone who will finish this script for me.
Thank you.

Vemod newsletter component (attached) made to be Joomla 2.5 Natively Compatible. No modifications other than what is required so that it will install and work correctly in Joomla 2.5.

This is NOT a site-specific project. There is NO design work. This is a simple project of taking the current installable component (attached) which is compatible with Joomla 1.5.x and altering it to be compatible and installable to Joomla 2.5.x.

I need the shape 5 city portal template converted from Joomla 1.5 too Joomla 2.5.

- Website editing needed in Joomla 2.5

- Navigational links to be made horizontal

- Banner size need to be changed

- Image slide show to be integrated on homepage

- An online appointment form required where user can select any date from the calender to book an appointment

- Google map to be integrated on contact us page

Deadline : 2 days

I need the Vemod news mailer component (attached) made to be Joomla 2.5 Natively Compatible. No modifications other than what is required so that it will install and work correctly with full functionallity in Joomla 2.5.

ould contain all objects/project linked to a given contact.
This way when we select a contact in the frontend a list with all objects linked to that contact should appear.
The 3rd table should contain the advancement state for each project (customer contacted, customer met, form shipped, documentation complete, etc etc.)
I think this is not a complicated project and I could program it by myself but I don't have time to do it.

throw some customizations (made by myself so not big deal) and I would like to keep them.
I need the site running in joomla 2.5, and I need installed and set Community builder and sh404sef components (I already have them both, only not installed). Community builder with some extras like groupjive (also purchased it already)
I need the content and, most important, all the users (over than 600 users) and profiles migrated to j2.5!

I want a re-design of my website www.pat-training-now.co.uk, this re-design needs to be in Joomla as I need to be able to update the site.

need a wedding website in joomla urgent.

you can use any good theme you want. Any previous website done in joomla using light colors would also do.

Just want it quick. 8 pages required max, including contact us page.

thanks

---

Additional Info (Added 9/26/2010 at 8:19 EST)...System Message: This is a reposting of project wedding website in joomla (1282921155).

M for details and requirements.

---

Additional Info (Added 1/5/2010 at 0:00 EST)...Removed file: dti_flowchart.odg

---

Additional Info (Added 1/5/2010 at 0:01 EST)...Attached file: dti_flowchart.pdf

---

Additional Info (Added 1/9/2010 at 10:10 EST)...System Message: This is a reposting of project reservation forms in Joomla (1262630537).

oration: none;color:#68778E" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">http://sofix.com.au/ Please give me exact time and budget. Low bid with high reviews will win this project. DON'T POST UR PORTFOLIO

---

Additional Info (Added 1/3/2010 at 7:25 EST)...System Message: This is a reposting of project Upgrading site in Joomla (1261921480).

ll views link list items to edit record)
1. My records of a static Section=1(will define lable later)
2. My records of a static Section=2(will define lable later)
3. ADMIN All of a static Section=1 where (Submit for review) = yes
4. ADMIN All of a static Section=2 where (Submit for review) = yes
5. Columns Title,Status(Working or Submit for review or Requirements Met when yes), Last Modify Date
6. Sortable Column headings, Default sort Title