...need a query to update a table based on another table.
I have two tables – SwitchPorts & SlaveSwitchPorts.
When the SwitchPorts .ClientID changes the associated ‘salve’ SwitchPorts (listed in the SlaveSwitchPorts table) are updated with the new ClientID also.
(Note that the SlaveSwitchPorts is a static table it is only referenced by the query and not

I'm looking f...looking for someone to optimize a website's performance and improve load times.
It would be an advantage if you are familiar with W3 Total Cache and Cloudflare. These are already installed on the website but perhaps not configured correctly and so we're seeing less than ideal load times. The website is built on the Genesis framework.

see user-owned device with apollo-server-graphql,
I want to see which user belongs to the device.
I would like to find the following query by username field.
query {
user(username: "fatih") {
username
password
userDevices {
deviceName
username
}
}
}

I am looking to get a react desktop view built with a single component that is repeated multiple times, these components will then load in data from a firebase database. Also needed is the ability to query the database for a keyword search then restack the loaded data based on this.

Have two tables
T_products
ProductID
Name
T_products_used
ProductID
CustomerID
Description
The first...CustomerID
Description
The first table is showing all different products, the next table is showing all products selected by a customer with description added.
I want to make a query who shows ONLY products not selected/used by CustomerID = 25

I need someone who has real experience with SOLR accessing it using C#. Do not apply unless you can explain the attached C# code file. I need someone who can help with SOLR Search. It would involve the application SOLR code to search the indexed data. The schema is already defined. The person will need to modify the schema based on requirements.

I moved my website from Opencart to Magento, and i have some queries used on Excel for get information on Opencart Db that i have to use for the same extraction for Magento. I'm looking for someone able to send me back a tested queries for Magento for get the same informations
In atthacmente the queries, i will give you db structure when you will accept my job

I want to create an Android app, a social one. I am hiring someone to create the database model. Firestore is a NoSQL database so you can't use foreign keys. How can I achieve what I want? Please help me.

...please do not apply for the project
If you do understand Toolset, here is the scenario:
Views for a custom taxonomy allows specific query filters, however it is limited so you can not have multiple operators in a query like WHERE ( $something = $something ) AND ( ( $something = $something ) OR ( $something = $something ) )
I require a custom

I have a website designed using ASP.Net by my colleagues and I need help from some one to give me the code that I can add to the home page to open a pop up page for recommended links to the visitors :
as it appears in this page
[kirjaudu nähdäksesi URL:n]:article-slide-in-desktop-text-only&otm_click_id=4a4d6c55-c8b6-4a67-815b-e2d1fd10fd98
thanks

...issues and resolve problems with SQL queries (remove duplicate queries, reduce requests, etc), locate/fix plugin conflicts, and (ideally) be able to adjust MySQL server config settings. Some PHP/JavaScript customization could be needed if plugin conflicts exist.
The main issue we're experiencing is when customers add products to the cart. If they

I have a database system project for my university. I have created a database design and I have 4 query to be solved.
1. Function that takes as parameter month and year and product and returns the amount of money
2. Employee name, customer name, number of orders
3. Customer name, distinct product name
4. Procedure that takes as parameter customer name

Configure two servers with DRBD, HA, load balancing, auto failover and recovery.
Requires excellent experience on linux HA, load balancing, high availability.
This contract will be to setup and maintain the system once configured.
WILL CONTACT EVERYONE WHO PROPOSE ON FRIDAY

I'm looking for someone with experience of Google Cloud Engine to setup a globally available website to scale as needed and possibly load balance.
Website has to be (locally) available in different regions and share a larger size database.
The website has to return large queries, probably as CSV files, efficiently.
Would appreciate pro tips to set

Hello,
I do have an ecommerce website in wordpress / woocommerce.
I would like to add a member area (login/pass) where some buyers can load orders by csv or excel and even manually. They need to be able to pay in advance any amount for what orders they uploaded. I have to be able to setup the cost of products by % or $ and free shipping for those members

I'm having an issue with fonts displaying properly. The child theme I'm using indicates that the two fonts I am using are built in. The fonts, however, do not display correctly. I need some help with loading Google fonts onto site.

MySQL (MariaDB) is causing high CPU load from our PHP chatting application which at times will cause the application to lag.
Need optimization and configuration to bring load down.
The requirements is to start with finding out why it is causing higher load and optimize either the server settings/configuration for MySQL and/or the database to help

...whether the pipe racks can carry the weight of pipes(including it's content) & Insulation with cladding. All the pipes will be subjected to vibration so consider it also for load [kirjaudu nähdäksesi URL:n] piping clamp is sliding type(refer the drawings for details). Also check that the concrete foundation(given in the drawings) is strong enough to carry the pipe

Hello, we need some help on speeding up the load time on our new wordpress themed webstore. We are not sure what the issue is or if it is a design flaw of the theme we chose but we really need help to load it faster. Currently it is over 20 seconds which is absolutely terrible. Help would be much appreciated. We need someone to check the server

Hi, I am looking to create a table in MySQL that calculates the balance (with fixed interest rate) for each user. there are expected to be more than 1 million customers and they will be allowed to withdraw and deposit continuously. 1. Users will have to keep the deposit untouched (no withdrawer) for 90 days (balance_nowithdraw) - interest rate (say

...
I have a query in Access, with data in that i need to export into a Xero csv template.
i need some VBA writing so that :
a: the export file matches exactly what Xero needs.
b: the export file will also need to hold some information that may be dependent on the information in the query.
For example:
if there is a field in the query "Xero" called

I have 2 small jobs in which my scope is the fabrication of steel structures.
I need shop drawings for the steel and simple load calculation for the same.
Job 1:
Steel support for Round sitting area for children play school. ( cad drawing is attached)
Job 2:
Steel support for a partition structure ( 2.5m Height & 3.875m wide) ( cad drawing is

Hi,
I am a developer and I need a more experienced backend developer to make my API production ready.
There are several tasks to complete but for now, I'm looking for someone to refactor my backend queries for speed and stability.
Also I'm having trouble indexing from a new DB (similar to this: [kirjaudu nähdäksesi URL:n]).
Please put the word Mongo as the first word in your...