Simple data extract from prestashop sql manager to other service

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
Dear Freelancer

I need u to develop few queries to be used in the prestashop sql manager.
The outpu needed is described here:

Important: queries for prestashop sql manager is not identical with normal phpmyadmin queries.. Its close but not identical.

Any questions, pls ask.

Additional Project Description:
01/22/2014 at 23:42 CET
A simple overview of the data needed to be pulled can be seen here:

I just need the data output on screen in prestashop admin.. I,will then store the data infiles myself :)

Skills required:
MySQL, Prestashop
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 144
in 3 days
$ 206
in 5 days
$ 206
in 10 days
$ 140
in 3 days
$ 201
in 5 days
$ 200
in 5 days
$ 252
in 3 days
Hire fastworkontime1
$ 221
in 3 days
$ 313
in 6 days
$ 144
in 3 days