Get a Freelance Job

Using the attached file please write the appropriate SQL

step 1
Using the correct tables, create a sub query using either join operation you wish that will list the customer number, first and last name concatenated together, city and number of copies ordered for all customers who have placed an order for the most expensive book (based on retail price). Give the combined customer names column and alias of “Customer Name”.
STEP 2:
Using the ORDER_ITEMS table, create a query using the corr…

Using the correct tables, create a sub query using either join operation you wish that will list the customer number, first and last name concatenated together, city and number of copies ordered for all customers who have placed an order for the most expensive book (based on retail price). Give the combined customer names column and alias of “Customer Name”.

STEP 2:
Back to top

Using the ORDER_ITEMS table, create a query using the correct functions to return the item number, the total qu…

Using the correct tables, create a sub query using either join operation you wish that will list the customer number, first and last name concatenated together, city and number of copies ordered for all customers who have placed an order for the most expensive book (based on retail price). Give the combined customer names column and alias of “Customer Name”.

STEP 2:
Back to top

Using the ORDER_ITEMS table, create a query using the correct functions to return the item number, the total qu…

I need articles to be written and re-written, using a specific spinner syntax, on various subjects related to the Forex market and currency trading.

Bidders should have experience writing articles.

The English and grammar must be perfect and all articles must past CopyScape by being at least 85% original.

They must be at least 500 words each and have the keyword phrase, that I’ll provide, inside the article between 1-3% of the total content (no more no less).

Here are my exact requests:

1) I need an original article to be sourced and written using the keyword I provide.

2) This article will then need to be re-written sentence by sentence using a specific syntax. I will need each sentence re-written 3 different times, with each sentence saying the same thing in a different way. Each re-written sentence should be at least 75% unique from the other re-written sentences.

Example:

Original article sentence that you will source a write:

“Traditionally, auto-trading systems have shown much difficulty forecasting the market, due to their very structure not being able to evolve with live market scenarios.”

Then take this original sentence you wrote and re-write it 3 more times using the following syntax structure:

{For the most part, automated trading robots have not been able to adapt very well to changing market conditions, due to the fact that they mostly create trade setups based on past market data.|The majority of trading programs are not able to successfully conform to market conditions, due to many limitations with technical market analysis.|Looking at auto-trading programs in general, they usually have a difficult time predicting the market, especially when the market is always changing.}

3)The original sentence that you wrote should not be included in the spinner syntax. 3 additional sentences needs to be written from your original that will be included in the syntax.

**The keyword should be included in each version so that each spun version produces the keywords around 1-3% of the time in the entire article**

4)Pay attention to the syntax structure. Each sentence group is surrounded by “{” at the start and “}” at the end. Each sentence within the group is separated by the “|” divider. Do not put spaces in between the “|” that divides each sentence.

5)Notice in the example that this is not a simple synonym swap but requires originality to make each sentence unique.

6)Each of the 3 sentences withing each group need to say the same thing using different words. The entire article should make sense and have excellent flow regardless of which sentence you choose of the three. A program will choose a random sentence from each group starting with the first to the last, and each “spin” should create an article that is grammatically correct and look professional.

7)Each spin of the article should create an article that is at least 500 words long. This means that in addition to the 500 word article that will be written as the original, there will be the spinner syntax version of the article that is 1500 words long (since each spinner version will have 3 additional versions of each sentence).

8)The original article you write should be submitted using Microsoft Word, and then the spinner syntax with the 3 additional versions should be included in the same document below the original.

9)IMPORTANT: A title for the article needs to have the keyword phrase inside it, and also be spun 3 more times using the original.

Example of Original: Automated Forex Trading – The Perfect Profit Solution

Example of spun title: Automated Forex Trading – {A|Your|Its a} {Great|Fantastic|Good|Viable|Nice} {Financial|Success|Money-Maker|Income|Investment} {Answer|Key|Resolution|Ticket}

***The keyword should not be spun but be included in each spun version***

You can use a thesaurus to find synonyms for the title. Each word beside the keyword should be spun at least 4 times in the title.

BIDDING:

I will need 50 articles to start which should be completed in around 2 weeks. Please bid on a group of 50 articles, which includes the 3 additional spinner variations as described above.

TERMS:

Each bidder will be required to write an article in this format using a keyword I provide, so I can see that you understand the format, and have good writing skills. If you win the bid, this article will be included in the 50 articles that need written.

The winning bidder will agree to send each article once it is completed, before starting on another one. Each article will be reviewed for its quality.

Payment will be put into escrow after I have reviewed your second article submission and it passes my review. It will need to be revised if it doesn’t meet the guidelines explained above.

Please do not bid on this if you don’t have experience writing, are not a native English speaker, or cannot commit to finishing the project.

If your work meets my expectations, you will be considered for ongoing work writing 100-200 articles in this format each month.

All copy write will be handed over to me for each article submitted and you agree not to use the work for any other purpose.

All bidders are encouraged to PM me. Please contact me if you have questions or need additional information. Thanks.

Hello,

I have just activated my new business directory site: www.miltonweb.ca

It is using the Sigsiu.net Online Business Directory index2

Problem is: the search feature is not picking up dynamic pages. I need it to search all Business Directory Categories and businesses listed within the categories.

I know it’s an easy fix. Just can’t find the module for it.

*I want visitors to be able to search by name or by category. Default should be “by name” if using the search box located on every page.

Eg: if they search for a business name called “Pizza Hut” search results should show: http://www.miltonweb.ca/Details/Pizza-Hut.html

If they search for category “Pizza”, search results should be: http://www.miltonweb.ca/Pizza.html

On my current site: www.miltonweb.com I’m using the Google Custom Search. If this would make better sense I am open to integrating this into the www.miltonweb.ca website.

Thanks.

Hi I am looking for someone who is able to complete some tasks on my website as my previous development house is not able to commit to it at this stage.

The 1st task would be to analyse and read through information on current website to create an awareness and understanding using the eapi.

1. Modify the order transactions tables to handle sms free text without to much overhead using normalisation.Imeplement archive parameterised process…Making provision for this process to change possibly adding more fields to the db table etc.
- Currently there are two order mechanisms.. online website and the other is sms. SMS is the one that requires the most of the work.
2. Make menu product items clickable on front end to display per service user category
3.Allow a configurable status management process on the order mechanism.(pending,processed,delivered,cancelled)
4.Fix cancel process on previous development as the canceled process is not currently working.

All detailed documentation and reading will be provided once the quote as been approved

See background below on initial project.

I need someone to develop a website which stores login details for, allows registration. This website will have code to invoke a Application programming interface as well as receive information from the api to store in the database.

There will be two types of users:
1. Service Type user – offers services displays service offerings to clients
2. Client Type user- see all service types (category) available

The client must beable to register themself on the website as well as send a plain text to the website to insert details to the database. example (pipe(|) delimited text)
The service user registers via the frontend on the php website

REPORTING

I should be able to draw monthly, quaterly and annual reports from the
website and at the same time purge the data be me setting parameters
from the front end as well as archive period for retention.

LOOK AND FEEL

The website should represent something along the lines of a control
panel where i must be able to setup each clientUSER with his own inbox and
outbox for messages sent using the api. ie login… I will require the
administrator login for administrative purposes (new clients,
products, menu options)

Additional Info (Added 1/6/2009 at 2:23 EST)…

This will be inclusive of full Intelectual property rights.. to change modify and resell all code
Additional Info (Added 1/6/2009 at 8:10 EST)…

client/user:-
-> registration — via website
-> registration — (eapi-sms text)
-> login
-> See services available (Restaurants, take out)
-> See menu available
-> registration is free
-> make order via website
-> place order via (eapi-sms text docs received)

service/user
-> register
-> login
-> post products/services (Menu option with ability to ad logo or branding on menu)
-> This will be initially used in the catering food industry (restaurant etc, take out)
-> registration is free
-> read incoming messages in readable display
-> reply to messges and use the auto reply option based on diffrent peak times, weekends, public holidays etc.
->messges will be displayed in dashboard format so that the progress can be monitored or status driven.. message can be in incoming state, processing, complete states.
-> diffrent views must be available for user to use to allow quick access to these messages. they must also be allowed to go back to archived or purged records at a later stage maybe allow some search criteia.

Incoming message table should be something along these lines

“REFRENCE”,”CUSTOMER NAME”,”ORDER”,”CUSTOMER NUMBER”,”ADDRESS??”
“COLLECT/DELIVERY”

admin panel:-
-> upload menu with thumbnails or small pics
-> edit menu options on account

admin user
–> full access to all resources

PROCESS

->clientUSER will send a message through to the place and order then receive
confirmation of receipt with ref number alternatively error message if
format was incorrect. (REFERENCE should be included if possible at
this stage)
-> Once the order has been received by serviceUSER he will dispatch the
order for delivery if it was in the request confirm completion via message (eapi)
(*funtcionality must be available.)
The reply message api should be customisable with templates…. say for e.g
diffrent times in the day or week would mean that the orders could
take longer so the clientUSER should be able to interface the control
panel and select message to be returned based on certain criteria.. (Time
of day, weekend, weekday, public holiday(negotiable),
easter(negotiable) etc.)
clientUSER must beable to send back manual message as well if they so wish
as they might not be generating as much traffic. I take it that this
will be able to use the one free message api we get to send back.
-> The clientUSER will receive the order at his door alternatively
collect it with the reference number received from confirmation mesagge api

It is important to note that serviceUSers will not beable to see other serviceUsers account details once logged into their own account more so make changes to other service user accounts besides their own
Additional Info (Added 1/7/2009 at 2:08 EST)…

Im not sure if anything similar has been developed… I dont want to make it to difficult for client user to place orders or register therefore im not sure using the api the message sent is very limited 180 char per message i stand under correction could be shorter.

If they should send a separate message to register then a separate message to order… or can it be in one message. The order could be longer so then it would be neccas. to do it in separate messages with separate keywords.

The usage of the keywords are explained on the www.bulksms.com

I plan to use a shared short code initially which should beable to handle our requirements.
Additional Info (Added 1/7/2009 at 2:30 EST)…

Something i need to mention here is that the api will be invoked from a mobile phone which will have internet access but the menu options offered by the supplier or service user will not be displayed correctly on a mobile browser so the website for the menu will need to be displayed in a readable format for mobile phones..

Im not to sure if this is separate or if it is the same and the website caters for mobile or internet interfaces. it is likely that once the user registers they will receive a wap link to browse menu options if they are uncertain in placing a order.

I need articles to be written and re-written, using a specific spinner syntax, on various subjects related to the Forex market and currency trading.

Bidders should have experience writing articles.

The English and grammar must be perfect and all articles must past CopyScape by being at least 85% original.

They must be at least 500 words each and have the keyword phrase, that I’ll provide, inside the article between 1-3% of the total content (no more no less).

Here are my exact requests:

1) I need an original article to be sourced and written using the keyword I provide.

2) This article will then need to be re-written sentence by sentence using a specific syntax. I will need each sentence re-written 3 different times, with each sentence saying the same thing in a different way. Each re-written sentence should be at least 75% unique from the other re-written sentences.

Example:

Original article sentence that you will source a write:

“Traditionally, auto-trading systems have shown much difficulty forecasting the market, due to their very structure not being able to evolve with live market scenarios.”

Then take this original sentence you wrote and re-write it 3 more times using the following syntax structure:

{For the most part, automated trading robots have not been able to adapt very well to changing market conditions, due to the fact that they mostly create trade setups based on past market data.|The majority of trading programs are not able to successfully conform to market conditions, due to many limitations with technical market analysis.|Looking at auto-trading programs in general, they usually have a difficult time predicting the market, especially when the market is always changing.}

3)The original sentence that you wrote should not be included in the spinner syntax. 3 additional sentences needs to be written from your original that will be included in the syntax.

**The keyword should be included in each version so that each spun version produces the keywords around 1-3% of the time in the entire article**

4)Pay attention to the syntax structure. Each sentence group is surrounded by “{” at the start and “}” at the end. Each sentence within the group is separated by the “|” divider. Do not put spaces in between the “|” that divides each sentence.

5)Notice in the example that this is not a simple synonym swap but requires originality to make each sentence unique.

6)Each of the 3 sentences withing each group need to say the same thing using different words. The entire article should make sense and have excellent flow regardless of which sentence you choose of the three. A program will choose a random sentence from each group starting with the first to the last, and each “spin” should create an article that is grammatically correct and look professional.

7)Each spin of the article should create an article that is at least 500 words long. This means that in addition to the 500 word article that will be written as the original, there will be the spinner syntax version of the article that is 1500 words long (since each spinner version will have 3 additional versions of each sentence).

8)The original article you write should be submitted using Microsoft Word, and then the spinner syntax with the 3 additional versions should be included in the same document below the original.

9)IMPORTANT: A title for the article needs to have the keyword phrase inside it, and also be spun 3 more times using the original.

Example of Original: Automated Forex Trading – The Perfect Profit Solution

Example of spun title: Automated Forex Trading – {A|Your|Its a} {Great|Fantastic|Good|Viable|Nice} {Financial|Success|Money-Maker|Income|Investment} {Answer|Key|Resolution|Ticket}

***The keyword should not be spun but be included in each spun version***

You can use a thesaurus to find synonyms for the title. Each word beside the keyword should be spun at least 4 times in the title.

BIDDING:

I will need 50 articles to start which should be completed in around 2 weeks. Please bid on a group of 50 articles, which includes the 3 additional spinner variations as described above.

TERMS:

Each bidder will be required to write an article in this format using a keyword I provide, so I can see that you understand the format, and have good writing skills. If you win the bid, this article will be included in the 50 articles that need written.

The winning bidder will agree to send each article once it is completed, before starting on another one. Each article will be reviewed for its quality.

Payment will be put into escrow after I have reviewed your second article submission and it passes my review. It will need to be revised if it doesn’t meet the guidelines explained above.

Please do not bid on this if you don’t have experience writing, are not a native English speaker, or cannot commit to finishing the project.

If your work meets my expectations, you will be considered for ongoing work writing 100-200 articles in this format each month.

All bidders are encouraged to PM me. Please contact me if you have questions or need additional information. Thanks.

This project is a NEWSLETTER GENERATOR not to create a website.
The idea is to create a e-newsletter generator that is computer based for PC and MAC and also that is web based.
The idea is to create a simple newsletter generator to be used on any computer, so must be compatible with PC and MAC and then using this structure and adapt it to be able to instal on my website hosting space/server, It will be a similar idea of the CMS. This way the same idea will be online, I just have to log in to have access to it and then just customize it.
The text contents could be similar with the text editing of the CMS.
The PC and Mac structure must be very easy to instal, just a simple click to open the application, nothing complex, please.
The online version will be helpful because if I don’t have a computer with me I can use the online newsletter generator and this way it will allows me to have access to it anywhere where there is internet available.
Any of this structures computer based and online must avoid me having to open any document type of document: notepad, text edit or similar in order to create the newsletter content. It will be a similar idea of the CMS.
The online structure must be easy to instal on my server, the same simple way as a html site files are on the hosting space server, something similar or aong the lines of ……….xyz.com/newsletter.
It also this way also allows me to take as long as I want to produce a newsletter content piece because it is on my server. With always the option of saving the scratch text at any time.
In both cases when I finish to customize the contents I can send the e-newsletter by clicking submit.
Must have a simple autoresponder, easy to customize it.
I need to have a newsletter that: 
- I don’t need to buy an extra software to use it and to send it
- I can manage the simple design structure of the e-newsletter with images and text. It
must allow me to insert the pictures and manage the text the way I want. The same idea
as the Joomla CMS that can change/customize the layout using the modules. I’m attaching
the pictures of some simple ideas about the ways it can be customized.

- the e-newsletter CAN’T GO as an attachment, 

- It must be very simple to use, user friendly

- It needs to be done using the basic resources as possible. 
- it must allow me to send from anywhere just using the internet 

I’m looking for something very user friendly. Tell me your ideas.
I’m attaching 2 files 1 is about the text editor idea and the other is the idea for the management of the content frames/layout.
At the end of the project you have to provide me a tutorial file with the instructions for the installation and how to use the newsletter, how to customize it, something like a Word document or any other type of file that could be convenient for you.

I will only choose the programmer after you showing me your portfolio that proves experience on this field and after you giving me the samples about what you’ve done before like this, put them online in order to be able to see them.

Please only apply if you are confident of getting guaranteed:
1- Only programmers who place bids will be considered and I will not respond to copy and paste bids.
2- Only with proof of examples of this type of work. Need a serious and honest programmer so we don’t get any problem or trouble in the future.
3- Make sure you understand, know if you have what I’m asking for.
4- I need a 100% quality work and expert.
5- If you didn’t deliver me the files like you’ve explained to me, if it’s damaged, not according the quality that is demanded, not the correct file or not even send me all the files, I will leave a negative feedback about you. You will only be paid if its according all the quality demanded.
6- In a way of give me a good product and better understand what I want you can ask me all the questions that you really need to know.
7- Don’t bid if you’re not able to accomplish these tasks.
8 – You only receive the payment if you deliver what it was asking for and what you’ve promised to deliver, otherwise I will leave a negative feedback about you.
9

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.

Using the SQL CREATE statement, create the following two tables using the following fields:

Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table’s primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.

(You are to put all your screen snapshots for the items below, each showing the required SQL statements and results, in order, in a single Microsoft Word file. Failure to do so may result in lost points on this assignment.)

Using the database and tables from Week Two, write SQL statements and enter the records into the Employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check the results by selecting all of the columns from both of your tables. You should now have 17 total employees and 9 total job titles (2 points)

Using the database and tables in Week Two, write SQL queries using Between, Like and Union: (1 point each)

Kudler Fine Foods is a

Kudler Fine Foods is a

I am trying to make myself a simple-ish demo to test out auto-complete/display on a site using a few rules.

Basically I’ll have a form with 5 or 6 text inputs, each one an Auto-Complete.

I’ll have 5 or 6 corresponding tables, each 10-20 records on length. The tables will be in something of a Matrix as each will have correspondence to the other e.g. Table 1 / Record 1 will have a value for each of the other Tables e.g.
Table 1/ Record 1
Name
Table2Value=X
Table3Value=Y
etc

so the tables will link.

The tables themselves will also be hierarchical e.g
MainValue
SubValue
SubSubValue

I’ll want to be able to place an AC, give it a display title and then have define which table to access for the AC

Additionally I’ll want to be able to do a limiter on each AC based on the values in a prior AC so:

Input 1: AC from CarMake

Input 2: AC from Table CarModel Where CarModel_Make = Input1_CarMake

Ideally in fact each Auto-Complete will call all values from the defined table but sort using the above ‘limiter’

***

Step 2 will be modifying those selections each of which come from the nested tables and can easily modify either way;

Table 1: MainValue>
Table 2: <SubValue>

Right arrow shows list of subvalues to select

<SubValueV
SubSubValue1
SubSubValue2

User selects SubSubValue 2

Table 1: MainValue>
Table 2: <SubSubValue2>

or from Table 1:

Main ValueV
SubValue1
SubValue2

User selects SubValue2

Table 1: <SubValue>
Table 2: <SubSubValue2>

or can go up a level using the left arrow (only one option of course)

Table2: SubValue <SubSubValue2>

Table 1: <SubValue>
Table 2: <SubValue>

and again

Table2: Value <SubValue>

Table 1: <SubValue>
Table 1: Value>

and of course on the top (or bottom) of the nest no arrows show.

***

Finally, there will be another table, let’s call it Inventory which will have a # of Records with a Name and then a value from each of the tables e.g. (making up all these values as example)

Widget A
Table 1 (Color): Dark Blue
Table2 (City): New York

Widget B
Table 1 (Color): Blue
Table 2 (City): Istanbul

Widget C
Table 1 (Color): Red
Table 2 (City): Chicago

And these now display using the values from the selection shown before

Table 1: <Dark Blue> Widget A
Table 2: <Chicago> Widget C

and if the user now modifies the Table Seleciton

Table 1: Blue < Dark Blue>

the inventory updates

Table 1: Blue > Widget A
Widget B

Table 2: United States < Chicago>

Table 2: United States> Widget A
Widget C

__________________

Pretty straightforward, I should be able to name the tables/fields and define which AC calls what and what the “Where” is.

Doesn’t have to be pretty, if you can do this with existing Ajax ACs and modify for me a bit that is fine too, just experimenting.

I need a website that is using the Twitter API. I need it hosted in an environment where high transaction volumes are possible. No preference for the programming language used, as long as the code is well documented. For precise details, contact me.

Hello,

I am in need of a custom Joomla module. I need to have full ownership rights and sole redistribution rights of the final product.

This module will be used with Overstock.com’s affiliate program. Overstock offers XML feeds of its products and I want to use those feeds to populate the module.

BRIEF DESCRIPTION

This module needs to be able to be customized by the user to create an XML call. Once the XML call has requested the needed information from Overstock.com it then needs to be parsed into a viewable module. (The output should look something similar to the products on this page: http://www.overstock.com/Home-Garden/Living-Room-Furniture/713/cat.html ). If someone is to click on the product, they need to be taken Overstock.com using the affiliate tracking code URL.

FULL PROJECT

STEP ONE: Setting up the XML Call

The user needs to be able to customize the XML call. This should be set up in the

Hello,
Ok I have two different sites, and I am needing someone to merge the two together. Basically I have one site that I purchased that has all the database setup the way I want it to run and the admin panels I need to run my site I want. However on my other site the database and site has alot of errors and making it not run properly. So I am wanting you to basically take my new site I bought and just merge them together using the template from the site that isnt working. Basically we will be using my new site but just changing the template on it long story short.

Here is the domain of the new site: http://www.superrestaurantdirectory.com/

I am needing you to use the template and site layout from this site:
RateMyTable.Com

I want to keep the same layout and template from the site RateMyTable.Com but basically when they click the link “Restaurant Guide” it will start using the database from the site SuperRestaurantDirectory.Com. On my vps server I have all the files already uploaded from SuperRestaurantDirectory.Com and will send you the files from RateMyTable.Com so you can do the merge. I basically need it using the database from SuperRestaurantDirectory.com and the admin panel as well.

Also with this bid I need in the top right the “search” function to be able to search this new database and work properly. Also I have login panels, need to have it setup to login to their account from this new database I am supplying you with.

Also for “message board” I am needing you to install any freeware message board that works with this site and will allow members to login to their account from the login panel you already see on the homepage of RateMyTable.Com

Couple of other minor options I need done as well:

The featured review section that appears on the home page and restaurant guide page should pull from a list of reviews flagged as featured reviews from newest to oldest when you click on more list of featured reviews should show.

Need to change button on user login from power icon to enter

Advertising page needs to have thumb nails updated to screen shots of ads and when thumbnail is clicked on or rolled over enlarges when you click on pricing page the pricing info needs to be there and links to examples and benefits of that ad would be nice to replace map image with pricing info and links to whats included in price

All the forms need to have script sending them to email via server.

Need to have log in for paid advertisers to upload logo, and update menu link in real time

I need 4 step by step guides.

I have designed some baseball cards and baseball frames templates in photoshop.
What i need is a guide to show my customers how to insert a picture into the template and how to change the text. i need one guide on how to do this using the baseball card template doing it in photoshop and another guide using the software gimp. I also need 2 guides as well to do this using the frame template.

The guides will need to have screen shots. i have attached a sample of the templates