Sql query find child parent items tableJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Vissa utvalda produkter kräver en funktion som inaktiverar köp-knappen innan kunden har tittat på en säkerhetsvideo i en javascript popup. Funktionen ska läggas till i ett child theme för att inte försvinna när modertemat eller Woocommerce uppdateras. Funktionen ska dokumenteras för att det enkelt ska gå att lägga till och ta bort utvalda produkter från funktionen. Funktionen ska läggas till och testas på en test-site. När arbetet är slutfört och godkänt behöver jag dokumentation för att enkelt kunna flytta över funktionen till den riktiga live-siten. Bifogat finns en beskrivning av hur scriptet fungerar.

Find email adress

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Jag behöver en funktion till Woocommerce (Wordpress) som lägger till en knapp direkt efter ett av lageralternativen (Restorder) som finns i Woocommerce. När man klickar på knappen ska en popup komma upp med text för olika leveranstider för olika typer av varor. OBS! Funktionen måste kunna läggas i ett child theme, dvs inte direkt i Woocommerce-filerna.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Hej pvnordic, jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Hej rosew100, jag letar efter någon som kan hjälpa till att slutföra min Woocommerce butik. () Jag behöver hjälp med följande: 1. Intallera "child theme" (temat jag använder heter Nielsen och är från Themeforest). Just nu är allt inmatat i originaltemat. - hade en "utvecklare" som skulle göra detta men han missade totalt... 2. Jag skall använda klarna checkout och swish som betalsätt. Behöver hjälp att lägga upp dessa betalval på sidan för varukorgen, samt val av frakt/hämta butik osv. Orders över 500kr inkl moms skall automatiskt bli fraktfria. Fraktkostnad för ord...

Hej rosew100, jag letar efter någon som kan hjälpa till att slutföra min Woocommerce butik. () Jag behöver hjälp med följande: 1. Intallera "child theme" (temat jag använder heter Nielsen och är från Themeforest). Just nu är allt inmatat i originaltemat. - hade en "utvecklare" som skulle göra detta men han missade totalt... 2. Jag skall använda klarna checkout och swish som betalsätt. Behöver hjälp att lägga upp dessa betalval på sidan för varukorgen, samt val av frakt/hämta butik osv. Orders över 500kr inkl moms skall automatiskt bli fraktfria. Fraktkostnad för order under 500kr = 29kr. Klarna checkout plugin och swish plug in är installerade o klar...

adfsadsfadfs adfs adfs adfs adfs

Excel - quickbooks - finacial plannning

Im looking for a lead generator. Someone who can bring me leads. CPL CPM CPA CPC. We want a big ammount. Its needs to be Swedish Geo.

online market research & data entry

...-the customer don’t get any confirmation email neither do we -we sell both to companies and individuals and it must be clear that the prizes are excluding VAT and then what the price including VAT is also (25% on all our products is the VAT in Sweden) - The cart and the checkout mix Swedish and English terms - bargains field disappears (called the Rabatt kupong field) when an order is made - find a smart feature for the freight, now it says that "shipping of SEK 200 within Sweden is added but that the freight is free when you do an order over 2000 SEK. at the same time it says "no shipping requirement”. These are the things we first need to fix, it is much more, but this must be done first....

We're reaching out to find an ambitious Swedish copywriter to write sales focused and professional product information texts for a new e-commerce project. It's imperative that the person we select for the job has a proven record of producing high quality copy. The content produced will set the standard of our textual communication in terms of bringing out the quality and relevance of the products and ultimately forming the "right touch". Who you are You are motivated to engage our customers with your texts in an innovative and creative way. You make the reader feel involved. You understand and implement texts based on SEO requirements. You transform an already existing text to something unique and fun to read. You focus on the quality of the...

I'm engegerad in an entrepreneurial project for a cloud-based IT service service called Opcore. I now want to create a corporate video including voice matching with the goal to be able to use it as a teaser and introduction to our meetings, etc. Enclosed please find a draft script.

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

We have an existing app with a me...standard dropdown. Right now we have 26 cities that have to be included The backend CMS work both for android and iOS Ideal skills for this project include: - App design experience, particularly with menu systems - A good understanding of user interaction and interface design - The ability to balance creativity with practicality We're looking for a freelancer who can bring fresh ideas to the table while also respecting the existing structure of the app. The goal is to improve usability without introducing unnecessary confusion. You can search the app on google it is online' Looking forward to hearing from you

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be...formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA shift and 2 middle shifts, i want a report table showing me this for all the employees. i also want to be able to edit the fields and tables if required at a later stage. FOR AN EXCEL EXP...

I'm seeking an experienced website designer to create an e-commerce platform for my business. This platform will serve to highlight and sell our range of products, and we expect to list between 100 and 500 individual items. Key Project Elements: - An intuitive and attractive product listing and description feature, ensuring our customers can easily browse and understand our offerings. - A user-friendly and secure shopping system, giving clients confidence in their purchases. Ideal Skills Required: - Experience in web design, ideally with a portfolio of e-commerce sites. - Knowledge of SEO best practices to optimize product visibility. - Strong graphic design ability to ensure the site is visually appealing. - Experience in creating user-friendly interfaces for easy navigation...

I'm looking for a talented graphic designer to professionalize my existing logo design. The business is focused on physical security consulting. The logo design needs to embody a bold and striking style. - Colors: A mix of blue, black,...to embody a bold and striking style. - Colors: A mix of blue, black, and grey colors should present in the design. - Elements: While I have my own design, expert guidance to embellish or subtly incorporate physical security symbols would be welcome. Ideal Freelancer: - Demonstrable experience in creating eye-catching professional logos. - An understanding or background in security-related items would be a bonus. - Ability to communicate effectively and take creative feedback on board. - Provide different format files and color codes used ...

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

...intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from a drop-down list. They should be able to start typing the name of the exercise and the drop-down list should filter based on their text. Eg. if they type 'squat', the contents of the drop-down list should narrow to all exercises that contain the word 'squat'. - Exclusive admin rights: I would l...

I am in need of an experienced freelancer who can help me create an iOS storyboard for my project. At this stage, no designs or wireframes have been created, hence your inputs and creative touch will be extremely necessary and appreciated. Key Requir...storyboard. - Generate unique, intuitive and compelling ideas for the storyboard. - Experience in iOS development and designing. - Critical thinking and problem-solving skills. - Proven ability to work effectively within deadlines. Please download the attachment for the project details. Your application should clearly showcase your relevant experience and past projects you've handled. Also, I hope to find someone who can understand and effectively use the specific features I have in mind for my storyboard. Thanks for consider...

I require an individual with keen attention to detail and excellent organizational skills to assist in a product sourcing and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 29 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 29 bottles must be labeled in a manner ...

I require an individual with keen attention to detail and excellent organizational skills to assist in a product sourcing and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 4 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 4 bottles must be labeled in a manner th...

I am in need of a professional Android developer to create a live streaming app with the three key features of live chat, virtual gifts, and social media integration. Key Features: - Live Chat: The app should allow users to chat in real-time with streamers. - Virtual Gifts: Users should be able to gift virtual items to their favorite streamers during live broadcasts. - Social Media Integration: The app should seamlessly integrate with popular social media platforms, allowing users to share their favorite streams. Ideal Skills: - Proficient in Android app development - Experience with live streaming technologies - Familiarity with in-app chat and gift systems - Previous work involving social media integration

...product configurator for garage and workshop furniture. Market research has found that our customer base found IKEA's PAX Planner the most useful configurator style. Here, they could change the dimensions of their room, and then drag and drop IKEA's items into the space and 'clicking' together before generating a CPQ and bill of materials. This will require the writing of 'rules' that suggest the user adds products that are necessary for the construction and use of some units. Research has also shown that customers responded well to items rendered in Unreal Engine or Unity. Please consider the cost of this within your quote, or suggest similar alternatives at a lower cost. Key Requirements: - The technology for the configurator should be b...

I'm looking to establish a successful e-commerce platform on Amazon UAE specifically focused on Home and Kitchen products. The ideal candidate for this project requires: - Experience in e-commerce development, specifically with Amazon UAE (preferred) - ...Proven ability to identify trending products in UAE and source local suppliers - Skilled in developing search and filter functionalities - Knowledge in boosting sales for Amazon sellers in the UAE Key features I aim to incorporate in the e-commerce platform include: - Robust product search and filter options - Capability to identify trending products in the UAE that could be profitable - Ability to find local suppliers to reduce shipping costs and time - Strategies to increase the sales of the products listed in the Amazon U...

Need a solution A barcode app to print and track our inventory. (Barcode&QR desirable)Online - Webbased. ProductCode/SupplierCode/Category/SubCategory/Batch/Colour/Size/Expiry/Selling PriceA/X/X/X/X/X/XX/XX/XXXX/XXXXXX.00Item description must print on the lable More details: We wish to use this app to count our inventory using bar code scanners Also when items are placed in a box to transfer between two shops, we need it to be able to use the scanner and count accuracy. Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP

...drawer at Home Depot. The system should have a focus on reporting and analytics, real-time bin shrink, and work with an electronic keypad and analog/digital interface. Key Features: - **Reporting and Analytics:** The system should provide insightful reports on inventory levels and trends. This will help us make data-driven decisions. - **Real-Time Bin Shrink:** I need to know if the quantity of items in the bin matches the recorded amount. - **Interface:** A mobile app interface will be ideal, making it easy for staff to work on the go. Inventory Tracking: - The system should involve manual entry for inventory tracking. The system should be user-friendly and easy to use for our staff. Skills/Experience: - **Mobile App Development**: You should have experience in d...

I'm looking for a freelancer with experience in Amazon listing optimization to collaborate with me on improving my clients' product descriptions. - The main objective of this project is to create or improve product descriptions to maximize their appeal to potential customers. - Items in product listings I need help with include product titles, bullet points, and product descriptions in addition to product features. - I am also looking for help optimizing keywords for both organic search results and advertising campaigns. Ideal skills and experience for this job include: - Proven track record of successful Amazon listing optimization projects - Proficiency in writing attractive and persuasive product descriptions. - Strong knowledge of SEO and keyword optimization. - F...

I am in need of a personal stylist to help with personal shopping and outfit coordination. This project is for a professional audience, so a keen eye for style and professionalism are key. Key Responsibilities: - Personal shopping: Finding affordable, professional attire that alig...aligns with my personal style. - Outfit coordination: Suggesting stylish outfit combinations for various occasions. Ideal Candidate: - Previous experience in personal shopping and outfit coordination. - A great understanding of professional dressing. - A good eye for style and current fashion trends. - Excellent communication skills and a professional demeanor. - Ability to work within a budget and find affordable options. Please provide your portfolio and a brief description of how you'd approac...

I'm seeking an experienced developer from VIETNAM who can proficiently use CodeIgniter 2 framework and Microsoft Graph API for my project. I need someone who has worked with the MS Graph API to collect all items availible from teams (with call register)

title: human trafficking on the dark web description - this is a research paper and i have some sources on how i am going to use it I i also write my introduction and below are the specific question on which my research is based • How do human traffickers utilize the dark web to conduct their activities? • What are the most common forms of human trafficking found on the dark web? • How do victims end up being trafficked on the dark web? • What measures are law enforcement agencies taking to combat human trafficking on the dark web? • How effective are current laws and regulations in preventing human trafficking on the dark web? this is how my paper starts A great chance to shine transformed into a living nightmare for one teenage model. Yes, you read that ri...

...as if dissolving into the entity. ***The Faceless Phantom slowly fades, leaving Thomas standing at the same spot. ***He stares at sleeping Faye with glazed eyes. ***Body rigid, his face twists as if tormented. Mouth wide open as if fear clogged his throat. ***His head sags. Goes back to sleep, still standing erect. FADE IN: INT. POLICE DEPARTMENT - INTERROGATION ROOM - DAY Cold and stark with a table and two chairs. There is a one-way mirror window on one of the walls. Thomas, haggard and disheveled, with dry bloodstains on his clothes, slumps in a chair. Across from him is DETECTIVE (30s, stone-cold, hawkish). DETECTIVE Mr. Hahn, were you in the room all night? Thomas looks distant. Not here. DETECTIVE WONG Mr. Hahn? Thomas barely nods. DETECTIVE WONG And yet you don’t kn...

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the pr...

I'm looking for an expert in EA (Expert Advisor) to optimize the performance of my current EA system. In particular, I'm interested in: - Enhancing the trading algorithm: You should have a profound understanding of trading algorithms, as this task will require you to optimize my EA's functionality substantially. - Implementing better risk management: Yo...focus on improving the risk management aspect of the trading algorithm. This means you have extensive experience with risk analysis and how it's applied in trading algorithms. Having background knowledge in finance would be beneficial for this task but isn't necessary. However, strong analytical abilities, problem-solving skills, and an eye for detail are a must. Bring your expertise to the table and ...

"I am looking for an experienced programmer to develop a logistics management program with integrated travel services. Key features: Inventory Tracking: The system must efficiently monitor our inventory in real-time, updating stock levels when items are added or sold. I also need assistance with travel-related services. Specifically, I need the system to manage: Travel details: When we load the goods, divide them by type of merchandise, recipient, and number of contracts. Delivery tracking: Keep track of shipments in transit, providing real-time updates on their status. Payment tracking: Indicate whether travel services have been paid for or not, allowing us to monitor outstanding payments."

...promotes teamwork, problem-solving, and following directions. Build it Together: Many museums have interactive building areas with blocks, Legos, or other materials. Challenge your pre-teens to work together to create a structure inspired by a museum artifact or historical period. This fosters creativity, communication, and the ability to compromise to achieve a common goal. Art Collaboration: Find a large blank canvas or mural space in the museum (with permission, of course!). Ask pre-teens to brainstorm a theme inspired by the exhibits and then work together to create a collaborative piece of art. This activity strengthens communication skills, builds trust, and teaches the value of diverse perspectives in a final product. Cultivating Critical Thinkers: Fact or Fiction...

Design a DJ table as per the sketches and drawings provided.

...frame. #Requirements: - Extensive experience as a Data Engineer, Database Architect, or similar role with a strong focus on rapid project execution. - Expertise in handling tight deadlines and delivering complex projects quickly. - Strong understanding of API integrations and experience with RESTful services. - Proficient in relational database design and development, preferably with experience in SQL and NoSQL databases. - Experience with ETL tools and processes under strict time constraints. - Familiarity with CRM and MAP platforms like Salesforce and HubSpot. - Capable of creating detailed entity-relationship diagrams and data flow diagrams quickly. - Excellent problem-solving skills and ability to work independently in a fast-paced environment. - Fluent in English with outst...

I'm in need of a skilled web developer to construct an E-commerce website for my retail business. Key characteristics that the website must have are: - A shopping cart for customers to review their selected items before purchasing. - A product review feature that allows customers to share their thoughts and experiences about the product. - A robust stock management system to keep track of inventory and sales. The ideal freelancer for this project should have previous experience developing retail E-commerce websites. Experience with shopping carts, product review systems, and stock management system implementations is a must. Knowledge in SEO-friendly designs, mobile-first strategies, and secure payment systems are also crucial for this project. Your success in this project...

...time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many of those samples will result in a DNA match? b. What is the mean time to process a sample? c. What percentage of samples meet the police force’s ambition to process samples in less than one day? d. Is there any stage of the process t...