Edit csv mysql query jobs
Hello, I run a Wordpress store with Woocommerce. I want to display a top 10 sales charts of "recent" sales on a page. I'm looking for a custom script / query to display a vertical list of the 10 products that sold the most copies in the last 30 days (like a current top sales charts). I would like to have it usable via a shortcode, so that I can display
...intervention of study (using outcome_measurements table) 4. Find the number of trials that started after 2005 and ended before 2010 5. Distribution of trials by state All code query must be provided for the work to be completed. I will help along the way with any questions and also be checking the results are in line with what has been asked. An expectation
...need a SQL query that will return a set of frequently used patterns / word combinations in a field, as well as the number of matches found for that pattern in the field. Any amount of text could exist before or after the pattern that's shown. I should be able to add Where clauses to the query to filter the dataset that's used for the query. Example:
...that all use the same Point of Sale software (Junction 6). This software has been configured to generate and email a daily sales report once every 24 hours that attaches as a .csv breakdown of sales every day. We would like this dropped into a Google Sheet so that we can have an Automatic Daily updated report (dashboards are linked to this Google Sheet)
BIDS OVER $100 WON'T BE HIRED. VIDEO INSTRUCTIONS = [login to view URL]
I am looking for googlesheets integration with the eventbrite api. I would like to be able to run a query like this: [login to view URL] and have the results returned into a googlesheet with each event
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
Project Duration: 30 minutes ONLY - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU
Project Duration: 30 minutes ONLY - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU
Project Duration: 30 minutes - full 1 hour will be paid Project Type: MySQL/SQL Output Required: SQL Query Project Overview: Find & Replace query to replace a string of text in one db table. Character escaping required YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU
need to find out how to view sql query history that shows who ran the query, how many records affected, where it was run from etc..
I need some changes to an existing website. I already have a design, I just need you to build it. I would like a query display on a page that shows current unpaid customers.
I need a query to activate "Status Stock" In stock on all my products Type: Configurable Product Issue: There was a load of products but the Options Status Stock is Out Of Stock and it display the products on the front "Out Of Stock" even when the variables has stock on it.
Hello! Who can write me a script, which is catching the csv file from my wholeseller to my ftp server? With Cron every 20 minutes? My wholeseller has an open api to catch it. Here is the documentation: [login to view URL] Thanks!
I am searching for a skilled freelancer who is able to grab a decent amount of products from an online shop which the link i will give you later on. Datas I need in that .csv file are: product-title product-price product-description image 1-x product-category product-subcategory technical-informations ATTENTION: I need everything in the correct formatting
I am looking for someone who can create a form with multiple inputs ...a column in a table. - the values for the drop downs will also be from a column in a database table. Once the form is created, it will need to work as a search "system" to query a table in the database and display a table with the returned values. Using AJAX, PHP, JavaScript etc!
API Using the [login to view URL] POST /rest/catalog/productsstockbyreference We need to generate a simple XML based on multiple SKU query. This will then be imported into WordPress daily. This is a temporary measure until a full connector has been built by our third party.
I need assisted with Power Query. I have a project to create a Query that will allow me to pull data from Q1 and Q2 and print quarterly reports.
...and PHP as well as the importation of large CSV files to go through this in more detail. We need offers offers from companies who can resolve this within 2 days. we are able to provide some initial test data in CSV format for you to load which would be a 25 product CSV sheet. We can then provide a larger CSV to test after this although no matter what
***********************************READ THIS FIRST**************************************** INDIVIDUAL PROGRAMMERS ONLY - WE DO NOT WANT YOUR TEAMS, YOUR COMPANIES, YOUR FIRMS, YOUR SUBCONTRACTORS OR YOUR FRIENDS/PARTNERS. IF YOU CAN NOT COMPLETE OUR PROJECTS YOURSELF - DO NOT APPLY - DO NOT MSG ========================================================================= About the Application and Sk...
The problem is that part of the query is passed from another file. I think it will be easy to fix
I need someone who can write me a Query for PHP/MYsql to update 2 tables, I have about 5 warnings in error_log file after upgrade to PHP7.2: count(): Parameter must be an array or an object that implements Countable (2x) Illegal string offset 'content' (: eval()'d code) array_key_exists() expects parameter 2 to be array, null given count(): Parameter
...two pieces of a WordPress project: 1. First off, I need a custom post type query ordered by a custom field. Both the post type (events) and custom field (start date) are created by the EventOn plugin. The event start date field appears to be stored in UNIX format. The query is already written, we just need it sorted by the custom field. 2. Secondly
Need Help in SQL Query in order to get proper sequence number.
On savesnote click I want to add Orderontes to Ordernotes table using AJAX and also save it to database without refreshing the page.
...DNS query to a single specified DNS server (the function you create must accept the IP address of the DNS server as a variable) to lookup a specified domain (again the function must accept the domain name as a variable). The application must compile under gcc version 4.8.5 with -std=gnu++11 or it will not be accepted. After sending the query to the
I need to do a query with cypher to merge nodes with the same property and create a list with another properties not unique
Necesito crear un query que busque en los meta de la orden rangos entre dos fechas.
report page works. [login to view URL] we need the html mess removed. and css put in. simple row output. we need a search box for company / url only. we need a status sorted link to work. view code before bidding. will block those who don't read description before bid. want it done right now. not waiting. don't bid. new york time zone.
Project Duration: 30 minutes - full 1 hour will be paid Project Type: MySQL/SQL Project Overview: Find & Replace query to replace a string of text in one db table based on two sets of criteria. We have tried to use the phpadmin find & replace function but it can't seem to find the required text YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK
Hi, I have a defined table schema and a data set in excel. my project requires me to design the SQL query which will give the output as the data set. For someone who knows SQL query, this should be 10 minutes tasks.
Please review the attached word document. It explains what we are looking for.
Project Duration: 30 minutes - full 1 hour will be paid Project Type: MySQL/SQL Project Overview: Find & Replace query to replace a string of text in one db table based on two sets of criteria YOU MUST BE ABLE TO START WORK IMMEDIATELY 5* FEEDBACK WILL BE LEFT FOR YOU
YOU MUST BE AN SQL EXPERT OTHERWISE PLEASE DO NOT WASTE TIME BIDDING. I need occasional help with writing very short, simple and basic SQL queries to extract data from a database. Its mainly for SQLite. I just need the queries to be written. If the price is right it will be on a regular basis (for an SQL EXPERT the queries needed are very simple, very short an straight forward). Details for this p...
I retrieve google spreadsheet in this way: https://docs.google.co...way: [login to view URL]{key}/pub?{gid}&single=true&output=csv but then my problem is it doesn't update instantly as data changes. (It takes approx. 5-10mins randomly) I want a solution on instant changes of my google spreadsheet data to a cloud csv with an url
...example: [login to view URL] Plugin zip file here. [login to view URL] Takes 2 minutes to setup (please delete when finished) PAGE 1: $10 file name: [login to view URL] IMAGE: mobile image QUERY PAGE1 Nothing fancy just a list with some css styling to match example: I use to see quick list of clients and website on iphone. needs to be responsive and prettier than example
I need a new website. I need you to design it from scratch
I need a SharePoint form created in InfoPath that can query and display results of a second list when the second list field meets a certain criteria entered in the form. The list items that meet the criteria will also need to have several fields updated from within the form using workflow. This is a vanilla SharePoint 2010 Enterprise server with
... Takes 2 minutes to setup [login to view URL] (please delete when finished) PAGE 1: $10 file name: [login to view URL] IMAGE: mobile image QUERY PAGE1 Nothing fancy just a list with some css styling to match example: I use to see quick list of clients and website on iphone. needs to be responsive and prettier than
...example: [login to view URL] Plugin zip file here. [login to view URL] Takes 2 minutes to setup (please delete when finished) PAGE 1: $10 file name: [login to view URL] IMAGE: mobile image QUERY PAGE1 Nothing fancy just a list with some css styling to match example: I use to see quick list of clients and website on iphone. needs to be responsive and prettier than example
...to write a job which runs on Windows 2012 Server Task Scheduler. The job starts at a time specified in some file. The job fires a query on the MySQL database and fetches the resultset. Our developer will give you the query and take care of the steps after that. We should be able to specify when the job auto starts. It will be a daily running job. Post
Hi I need to be able to list all the email addresses both primary and alias that exist in a domain (Exchange 2010), and place those into a SQL Server table. I would therefore like a powershell script that populates a table with: Username, EmailAddress, PrimaryOrAliasIndicator. The script will be run as a scheduled task once per day. Therefore, it should run without user interaction. It is quit...
i need to do a mysql query where i have 3 tables: users -id veiculos -id veiculosremovidos -user_id -veiculo_id so now what i need is to query all on the table veiculos removing the ones that a especific user have removed so if i have in the veiculosremovidos (user_id=1, vaiculo_id=7800) it is not listed, i can explain in detail in chat
I have postgresql installed on a server, and I have created a database and table. I am looking for someone who knows how to load data from a .csv file in the table already created.
I have a complex SQL Server query that needs a performance improvement. The query is the return of a function (ie, the function returns the query statement). I think that performance improvements on this query should be: indexes to be created on tables involved and create one or more indexed views (I know there are limitations, specifications and commands
...for a developer who can help us "convert" complex Excel formulas into a php / mysql query or other Ajax / Jquery (we are open to any solution) In the attachment Excel document, you will find 2 tabs. - data: In column A "Balance", this is the dynamic data that is in a Mysql table. (Cellula F3 is a fixed data). The purpose of the calculation is to obtai...
looking for someone who is fluent in magento and can help change and optimize a few sql queries.
Hi, I need mySQL query for database is Magento 1.9, I need select attribute from table: catalog_product_flat_1 sales_flat_invoice_grid sales_flat_invoice_item Last 10 Invoice one random product, costumer name, Country, product name, Time (h), image path, product link. I need only Query like this: SELECT * FROM sales_flat_invoice_item, sales_flat_invoice_grid
Hi there! I'm looking for an expert MySQL query writer who can optimise my query so that it runs "near-instantly". Here is my problem: - I have a table called "Map" that stores the lat/lng pairs of certain global co-ordinates. The Map table currently holds about 4,000 rows, but I expect this will grow to many millions in future. - I also have a User
