MySQL queries needed

Budget $30 - $100 USD
Bids 17
Average Bid $26

I have five queries that I need help creating.? I have a database with multiple tables linked to a core table and have to select a subset of the main table but order it by a field in one of the linked tables.

## Deliverables

Let's assume I have a table called 'main' and a related table called 'notes'.? There is a field [url removed, login to view] that is linked to a field notes.id.? In 'main' 'id' is a unique value, but in 'notes' 'id' is not the index, but just a reference to the value in 'main'.? 'main' has a large number of fields in addition to 'id' that I need to be able to access from the query.? 'notes' has additional fields 'datetime', 'entered_by', 'entry1', 'entry2' and 'entry3'.? A given row of 'notes' will have values for 'id', 'datetime', 'entered_by' and one of the three entry fields, but never for more than one of the entry fields per row.



Query1:? I need to select rows from 'main' where [url removed, login to view] is not an empty field (i.e. is the one of the three entry fields with a value) and order the rows? by the most recent [url removed, login to view] value for each [url removed, login to view] .? The result of the query will be iteratively displayed ( but you won't be coding this, I already have.? I just need the Select statement? written).

There is a table 'users' that has the fields 'username' and? 'userclass'.

Query2: I need to run Query1, but where the username value in the notes.entered_by field has a userclass of "Admin".

In addition to the 'notes' table, I have a 'status' table that has the fields 'id', 'status', and datetime.

Query3: I need to select rows from 'main' where? the most recent 'status' associated with [url removed, login to view] has a [url removed, login to view] value of more than 5 days before now and sort the rows from 'main' from the oldest [url removed, login to view] to the most recent.

Query4: I need to have a true/false output for a search of a given [url removed, login to view] about whether the most recent [url removed, login to view] is over 5days old or not.

There is a fourth table 'questions' with the fields 'id', 'question', and 'answer'.?

Query5: I need to select all rows in? 'main' where there are 'questions' associated with [url removed, login to view] that have no 'answer'.


* * *This broadcast message was sent to all bidders on Saturday Mar 20, 2010 3:22:23 AM:



Thank you for your bids. I have selected the bidders I wish to work with at this time.

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • rajoo1 Profile Picture
  • kumargupt117 Profile Picture

    kumargupt117

    India

    BIO SACHINGUPTA SOFTWARE DEVELOPMENT PROFESSIONAL PROFILE Technically sophisticated, analytical mind &result driven professional, with an excellent and rewardingcareer of around 3+ years in the software industry. Articulated professional experienced with the latest trends andtechniques of the field, having aninborn quantitativeaptitude, determined to carve a successful and satisfyingcareer in the IT industry. Having Expertise in development tools Visual Studio 6.0,8.0, Visual Source Safe, VC++ & DBMS concepts. Having expertise in Automation of product plus havingstrong technical knowledge in SDLC. Equipped with the knowledge of various softwares, organizingtechnical demonstrations, with soundunderstanding and skill of creating new softwares &systems, designing, analysis, testing, database development andcoding for modules while structuring customized solutions to meetcustomer?€™s specific needs. Excellent RelationshipManagement skills, with the ability to conceive profitableand efficient solutions utilizing technology. Industriousindividual, Team Player, Quick learner, thrives on achallenge while working effectively with all levels of managementand the people therein. Languages C/C++, Visual C++, Visual Basic Databases SQL Server, Oracle 8i, MS Access Design Tools UML, Rational Rose 2000 Operating Systems Windows, UNIX, Linux Development Tools Visual Studio 6.0, Visual Studio 8.0, Visual SourceSafe PROFESSIONAL EXPERIENCE TATA CONSULTANCY SERVICES,Oct?€™09-Mar'10 Business Associate Key Accountabilities: Development of softwareproduct from existing system study, new requirement study tore-designing, coding, unit testing and debugging. Professional Projects Undertaken: Title CONSULT-IV Diagnostic Tool Role Team Member Environment VC++, Windows Module Title VDR Controller Description Consult-IV is a handheld diagnostic tester for various invehicle electronic systems, enabling accurate diagnosis and repairsand shortening waiting time for customers. VDR an added functionality in 4th version of Consultapplication, to diagnose vehicle in conditions thatcan?€™t be simulated in lab. Responsibilities ·System study, Involved in creation of Architecture / DesignDocuments. ·Implementation and Unit testing of allocated sub modules/class. PALADION NETWORKS,MUMBAIJul?€™06 -Jun ?€™09 Software Developer Key Accountabilities: Responsible for requirementanalysis & information gathering plus Mapping businessrequirements with architectural components. Divert efforts acrossmonitoring Server and deployments of scripts. Successfully handle thetask of developing/managing different Application Modules as perclient requirement. Providing technical support acrosstroubleshooting and debugging. Gained exposure inend-to-end development of software products from requirementanalysis to system study, designing, coding, testing anddebugging. Handle productionmonitoring and development of server communication. Professional Projects Undertaken: Title Data Leakage Prevention System (DLPS) Duration Area of Expertise C/C++, Visual C++, Visual Basic SQL Server, Oracle 8i, MS Access UML, Rational Rose 2000 Windows, UNIX, Linux HTML, DHTML COM

    PHP, C Programming, Engineering, and SQL

  • setiawanutama Profile Picture

    setiawanutama

    Daerah Khusus Ibukota Jakarta,  Indonesia

    I'm a web developer experienced in various PHP projects. My favourite job is data mining (web scraping).

    PHP, Javascript, XML, and Delphi

  • ghoof Profile Picture

    ghoof

    Islamabad,  Pakistan

    ASP, Javascript, Script Install, and Graphic Design

  • jack0stone Profile Picture

    jack0stone

    One you can rely on ------------------------------------ Experienced Professional Expert, Not Beginner, Not Student No Silly Remark, Please

    Graphic Design

  • morpheeen Profile Picture

    morpheeen

    Paleu,  Romania

    Microsoft certified web application developer (MCTS 70-515), with 9+ years of programming experience (ASP .NET, Windows Azure, MVC, C#, VB.NET, JQuery, Html5, CSS, Angular JS, Kendo UI/Dataviz, TDD, Entity Framework, Sql, MySql, PHP, Smarty, API Integrations, etc). Clean code, following best practices. If the customer is happy I am happy.

    PHP, ASP, XML, and Visual Basic

  • dale4id Profile Picture

    dale4id

    Jakarta,  Indonesia

    I'm self motivated person, who willing to learn something new. Right now I working in the company as web developer, using ASP Clasic, ASP .Net, VB .Net, C# .Net 2008 to make booking engine, for hotel reservation I am also freelance programmer using VB6, excel, VBA as my main area to create program

    PHP, ASP, Javascript, and Visual Basic

  • PACIFICALTD Profile Picture

    PACIFICALTD

    Benha,  Egypt

    Programming languages: ====================== Java - C++ - Objective C * 8 years in mobile development * 15 years in C++ and native programming * Complete many projects to shipping * cross-platform development great experience. * Samsung Smart app challenge winner http://devpost.com/software/direct--2 * I Created 90% the native and low level stuff in this profile: https://scopicsoftware.com/portfolio/

    C Programming, Java, Adobe Flash, and Visual Basic

  • baburam Profile Picture

    baburam

    Bhopal,  India

    Yukti Solutions is a leading provider of software and consulting services. We offer a broad range of service offerings including technology consulting, custom application development, process and technology re-engineering, and formal testing. Using a global delivery model, we provide high quality solutions on schedule. We build long-term partnerships with our clients, providing value on a sustained basis, leading to mutually beneficial engagements. Yukti Solutions is quality-focused company. We continuously strive to attain higher organizational maturity to provide better value to our clients. Our domain skills, technology expertise, and business and engineering processes ensure that we are dependable business partners to our customers. Our management team comprises a judicious mix of technocrats and professionals with specialization in a wide spectrum of industry segments. With varied dimensions of services in the offing, we provide vital and valuable opportunities to clients at large to optimize their corporate communication attributes with much more effective, impressive and distinctive outlook. Our knowledge backbone leverages the cumulative experience of several client engagements. Optimal automation of internal business processes results in progressively shorter turn-around cycles. It's been our commitment to strive hard to render service unto satisfaction with sustenance and will continue to do so. We, as an organization, have surpassed the age of triages, having earned the credibility of trust and support of myriad of customers on the basis of service commitment and living upto the same. By far we have seen and modulated transcendence through our service that reflects our innovative curve. Our commitment has been illustrious unto dedication and accomplishing tasks maintaining quality as per international standards. Our approach towards work, revolve around the following key factors: Understanding Requirements Developing Correct Strategy Delivering the best of design and technology solutions Work Methodologies Project Management Quality Assurance Client Satisfaction

    ASP, Javascript, XML, and Visual Basic

  • j2eesoafree Profile Picture

    j2eesoafree

    Chennai,  United States

    java j2ee, web service, bpel, xml, web technologies, application server, websphere, weblogic, oc4j, jboss, tomcat

    Java, JSP, XML, and J2EE