| |
|
|
Job Summary:
|
| |
| Job Type: |
Project |
| Budget: |
$ 100-250 |
| Required
Skills: |
,
,
,
|
| Attached
Files: |
db_schema.txt
|
| |
|
| Status: |
Closed for bidding
|
| |
|
|
|
Buyer Summary:
|
| |
| Username: |
|
| Feedback Score: |
        
4
reviews
|
| Award Reliability: |
9 posted 4 paid |
| |
|
| Location: |
Middlesex, United Kingdom
|
| Member Since: |
July 14, 2008 |
| |
|
|
|
| Invited Users: |
There are no invited users
|
Description
MAXIMUM BUDGET = .00 (no higher please)
Hi Coders
I need an SQL query, you must be very experienced in SQL for MySQL as there are multiple tables to query and to join. Please quote within my budget, this is not a commercial project, it's a private project and have very limited funds. If you cannot quote within my budget please do not waste your time or mine.
I have a celebrity photo website that currently has 100,000 celebrity photos and need a fast and precise search feature that will display results in order of relevance. The search form only contains one text-box and the user can search names, keywords, headline, caption and contributor id all in one string. My DB is structured well, using associative tables.
I like the full-text search features but if you have a better suggestion I am happy to listen.
The DB tables to query are: Photos PhotoKeyword Keywords PhotoPeople People PhotoContributor.
The DB fields to match the search words to are: Photos.Headline Photos.Caption People.People Keywords.Keyword PhotoContributor.ContributorRef
--------------------------------- Example Searches
A user could search: "Brad Pitt Angelina Jolie Sunglasses @mg" and should return all photos where Brad Pitt and Angelina Jolie are together and a pair of sunglasses can be seen by a contributor called @mg. I am aware that it could return a celebrity named "Jolie Pitt" (if there was one) - I am happy with this but somehow need to order the results by relevance.
Another user could search only: "Dorchester hotel" and should find the phrase dorchester hotel from the caption or headline field.
--------------------------------
For an exact idea of what I want, please visit (gettyimages.co.uk/EditorialImages/Entertainment) and try searching "Brad Pitt Angelina Jolie Sunglasses", check results page 1 and 2 and then check the last page. You will see the relevance of the results changing.
I have attached a text document which contains my DB structure. If necessary I can provide a MySQL DB data dump, which contains all of my data - so you can run tests at your location.
I hope this explains the project. It should not take long for an SQL expert to produce a query for me.
I look forward to speaking with you further.
Additional information:
Submitted on 09/06/2011 at 8:38 EDT
Attached file...
Reminder
You may not start working in this and any request before
your bid is accepted. Users who violate this policy
may have their accounts permanently suspended.
|
| Shortlist |
| Decline Bid |
|
|
Ahmedabad,
IN
location |
US$100
bid amount
|

         
(72
reviews)
feedback |
4 day(s)
delivery time |

|
| |
Hello sir
I have understand the requirement
Please initiate the chat and discuss your project in detail
One of my customer had an exactly similar website requirement few time back and I have designed and developed a very wonderful website which covers all the aspects needed.Any matching technology will be adopted or even customized work will be deliver as per what we discuss and conclude.
Also I would like to share my 10 years of experience in web design and development and working with hundreds of new clients from all over the world and give my ideas which will help you to flourish your business and good profit out of it.
I would like to show you our work portfolio of past 7 years and I am sure you will be very impressed.Before initiating the chat with us you can see our ratings and feed backs which speaks better of our expertise.
I could not post any links here so kindly initiate the chat with us.We will provide you instant response
Regards
Bid Time: 09-06-2011 00:53
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Hyderabad,
PK
location |
US$100
bid amount
|

         
(68
reviews)
feedback |
1 day(s)
delivery time |

|
| |
right away...!!
Bid Time: 09-05-2011 21:45
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
kolkata,
IN
location |
US$90
bid amount
|

         
(54
reviews)
feedback |
1 day(s)
delivery time |

|
| |
I will create search facility it will search through all the table and It will bring the data matching with all the word user specify,if fails then it will narrow the search like if user types "Brad Pitt Angelina Jolie Sunglasses" then it will search using this keyword,if not found,then it will try to search with "Brad Pitt Angelina Jolie". I am ready to do this.Please check my feedback also. Thanks SM
Bid Time: 09-06-2011 23:09
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Krishnagar,
IN
location |
US$100
bid amount
|

         
(54
reviews)
feedback |
4 day(s)
delivery time |

|
| |
Hi;
Please open PMB so that we can discuss further on the project and also show you the best work from our portfolio.
Thanks
Bid Time: 09-06-2011 00:20
|
|
|
|
| Shortlisted |
| Decline Bid |
|
|
Dhaka,
BD
location |
US$65
bid amount
|

         
(43
reviews)
feedback |
3 day(s)
delivery time |

|
| |
Hi, firstly i want to know how relevance search result you expect,suppose as in your example, if any user search "Brat pitt angelina jolie" it will try to search with specifically every words in the searched text but if any user type "Brrat patt",it will be little top to search this word in database,because its a program not a human.You can see my previous words where i did movie searching project.I will try my best to provide better performance.Thanks.
Bid Time: 09-06-2011 12:46
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
India,
IN
location |
US$100
bid amount
|

         
(35
reviews)
feedback |
3 day(s)
delivery time |

|
| |
Hello,We are php / mysql expert.Please open chat for more discussion.Thanks
Bid Time: 09-07-2011 15:38
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Patna,
IN
location |
US$90
bid amount
|

         
(33
reviews)
feedback |
1 day(s)
delivery time |

|
| |
sir, i will complete this job within a day.. waiting for your response...
thanks,
Bid Time: 09-06-2011 00:09
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Ahmedabad,
IN
location |
US$100
bid amount
|

         
(24
reviews)
feedback |
2 day(s)
delivery time |

|
| |
Hi, we will deliver you optimized database query. There isn't any text file attached. Can you please upload? We can finish your job within time frame and estimated cost. Please start chat. Regards!PAVANS
Bid Time: 09-06-2011 01:25
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Ahmedabad,
IN
location |
US$75
bid amount
|

         
(2
reviews)
feedback |
2 day(s)
delivery time |

|
| |
Hi,
We have seen the project requirement and understood your initial requirements quite clearly. We have expertise, creative team of web Designer, .NET C#, PHP,open socurec like; joomla, maganto, wordpress, Java Iphone/Ipad application and many other technologies that we can provide you best possible solution.
Please open the Chat session so we can discuss further.
Thanks,
Igex Solutions
Bid Time: 09-06-2011 02:02
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Lahore,
PK
location |
US$100
bid amount
|

         
(23
reviews)
feedback |
3 day(s)
delivery time |

|
| |
Hi, I have just placed this bid to discuss it with you, please start chat box to further discuss, we have no problem to do this work as we are expert in this regard. Thanks
Bid Time: 09-06-2011 14:33
|
|
|
|
| Shortlisted |
| Decline Bid |
|
|
jaipur,
IN
location |
US$120
bid amount
|

         
(8
reviews)
feedback |
7 day(s)
delivery time |

|
| |
Hi,
I am php developer and working form last 4 years. I will work for you on time.Please intiate the chat, so we can discuss.
I will create a sql view for searched fields then i will search in view.It will run fast, because it will only use one sql object at a time and get required table where need to search, after we find more data from table and will display according to desired sort order.
Thanks,
Xit
Bid Time: 09-05-2011 23:19
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
pune,
IN
location |
US$250
bid amount
|

         
(4
reviews)
feedback |
10 day(s)
delivery time |

|
| |
would you please invite me to chat for further discussion.looking forward.
Bid Time: 09-09-2011 09:24
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Sofia,
BG
location |
US$60
bid amount
|

         
(1
reviews)
feedback |
1 day(s)
delivery time |

|
| |
Hi, this is really simple for me (I have 15 years experience in RDBS).
I just would help you, don't want your money.
Bid Time: 09-09-2011 13:40
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
delhi,
IN
location |
US$100
bid amount
|

         
(1
reviews)
feedback |
2 day(s)
delivery time |

|
| |
Hello Sir
I got your attached file and i can do this work well.
Please start the chat session for details.
Thanks
Bid Time: 09-07-2011 06:09
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Ahmedabad,
IN
location |
US$100
bid amount
|

(No Feedback
Yet)
feedback |
5 day(s)
delivery time |

|
| |
Dear Buyer,
We are the team of 15-20 People including developers and designers.
Our team includes experienced persons in field of different
technologies. Our Customer set belongs to Europe, USA , Australia and
many other countries around the Glob. We are providing our services to
many different and advanced technologies. Our work field includes CMS
(Content Management System), Web Technologies, Application Software
Development and Real-time Software development. We have more than 7
years of experience to work with Joomla, Drupal, Wordpress, Magento,
VB.net, C#.net, ASP.net,JAVA, J2ME, JSP, VB, PHP, MySQL, MSSQL, C,
C++. Visit our portfolios to know about my work and We are not a
premium member of GetaCoder so can't add more then 5 portfolios.
Please connect via chat for further discussion.
Thanks
Regards
Softcoder05
Bid Time: 09-05-2011 22:54
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Linger,
LU
location |
US$60
bid amount
|

(No Feedback
Yet)
feedback |
2 day(s)
delivery time |

|
| |
Hi,
I thought of 2 stored procedures to handle this. This gives me also the possibility to calculate the relevance and sort on it. Please send me a private message if you want more details.
Kind regards
Sven
Bid Time: 09-06-2011 16:31
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Gurgaon,
IN
location |
US$60
bid amount
|

(No Feedback
Yet)
feedback |
2 day(s)
delivery time |

|
| |
Hi, Greetings from NeuroGen !!! We have gone through your requirement detail and would able to delivery the structured query for the full text search. For doing that we need an small dump of data for the mysql. Please kindly initiate the Chat at GAC instant messenger for more queries and to make an deal with us. Thanks and best regards, R.Das, NeuroGen Technologys.
Bid Time: 09-06-2011 17:06
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
hyderabad,
IN
location |
US$250
bid amount
|

(No Feedback
Yet)
feedback |
14 day(s)
delivery time |

|
| |
Please send the SRS ... We shall have a discussion upon that. Thanks.
Bid Time: 09-06-2011 19:06
|
|
|
|
| Shortlist |
| Decline Bid |
|
|
Kolkata,
IN
location |
US$100
bid amount
|

(No Feedback
Yet)
feedback |
5 day(s)
delivery time |

|
| |
Hi,
I have gone through the requirements of your project and I am looking forward to work on this. Please open a chat session to discuss further about your project and also to show you some sample work.
Thanks,
Arena
Bid Time: 09-08-2011 04:51
|
|
|
|
|
|
|
|
| |
| Get the Free
Step-by-Step Guide on How to Use GetACoder |
The act of
outsourcing jobs has become easy in the past few years
thanks to GetACoder. However, our team aims at making the
whole process even easier. So, it has now come the time to
provide you with a step-by-step guidance on how to use this
service and succeed in the outsourcing world totally for
FREE.
It doesn't matter if you are a more experienced user or a
novice; using GetACoder will become even simpler with the
help of this E-book. There are two major sections: a Buyers
section and a Coders section.
Buyers will learn:
- How to outsource safely
- How to pick the best freelancers
- How to manage time and money
Coders will learn:
- How to get the best jobs
- How to secure their payments
- How to build a long-lasting relationship with buyers
...and MUCH MORE
Clear examples and pictures illustrating key situations,
great tips and real testimonies of some of our best users...
all in this Outsourcing Guide. So don't loose the
outstanding opportunity to download GetACoder FREE E-book.
|

 |
|
GetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online. One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day. Thousands of Satisfied Customers - Submit/View Quotes
| - | This website works. There are 100s of project posted every month and the users are very easy to work with. - | | - | GetACoder is really great for me. I get a lot of projects from here and also grow up my business. - | | - | This site works great! Exceeds my expectations by FAR! - |
|
|
| |
© 2004-2012 GetACoder. All rights reserved. |
|