Access data query formtrabajos

Tengo una página web desarrollada en Joomla, y desde ayer tiene un error que está realizando una sobrecarga al servidor, por lo que ha sido suspendida. necesito arreglar dicho error lo antes posible

Necesito agregar un query en mi model file y pasar la variable al archivo view, de preferencia solamente español para esta pequeña tarea. Me gustaría comenzar una relación de largo plazo comenzando con una tarea muy pequeña para evaluar la forma en que programas. Gracias.

Micro task to apply query to read price inside my model file, current query is working with static info in view section Micro tarea para aplicar un query para leer el campo de precio, el query funciona bien en este momento en la sección view con datos fijos, por lo que necesito aplicarlo con las variables en el archivo model

Necesito crear una newsletter en HTML, para enviar por correo a mis clientes. Esta debe ser responsive, creada en HTML5 y Media query, EDITABLE. Todos los textos e imagenes deben poder ser cambiados. Se utiliza Blade (laravel) como motor de plantillas.

Me dedico a dar soporte a un sistema administrativo el cual se apoya en SQL como motor de Base de Datos. El sistema, como todo sistema NO tiene todos los informes tal cual el cliente necesita, y por lo tanto, me piden la generación de nuevos informes. Yo se algo de SQL por lo que en general armo la base de las QUERYs pero cuando las mismas superan mis conocimientos, necesito de alguien qu...

Tengo un script que envía un mensaje a una sala cada 10 minutos. Entonces los usuarios al ver este reclamo me mandan un mensaje privado y al instante reciben una respuesta automática del script. Necesito que se responda a los usuarios uno a uno y con un margen de 30s~1min entre cada envío ya que la red detecta flood al mandar varias respuestas por privado en pocos segundos.

Tengo problemas con un query que contiene funciones las cuales provocan que la consulta a la base de datos sea muy lenta, necesito optimizar ese query lo mejor posible.

Tengo problemas con un query que contiene funciones las cuales provocan que la consulta a la base de datos sea muy lenta, necesito optimizar ese query lo mejor posible.

Necesito desde una page consultar una base de datos y despleagar informacion de estudiantes. Como las del adjunto

Necesito persona con conocimientos en Postgresql, que sea capaz de confeccionar un "código SQL Query personalizado" dentro de una tabla, para que los resultados que devuelve sean guardados en una columna dentro de esa mimsma tabla...

Desarrollar MS SQL Query para consultar información e imprimir etiquetas con Bartender. Tenemos un sistema ERP Dynamics AX 2009, en Dynamics AX el equipo de distribución introduce información de los envíos que va a realizar, ahora bien, quiero realizar un query en SQL para conectarme a la base de datos y obtener información que será impres...

Requiero para un sitio con wordpress y woocomerce lo siguiente: Agregar un formulario con 3 campos a un producto y que con los parametros ingresados por el usuario, antes de agregarlo al carro (Idealmente con un boton) se realice una consulta a una base de datos y mostrar el resultado de la consulta, agregando luego los parámetros y el resultado a la órden. Actualmente con el a...

Tengo que realizar una busqueda en l...realizar una busqueda en la base de datos con los criterios que introduce el usuario a traves de un formulario. Necesito que me hagan la query segun los criterios introducidos por el usuario, el resto lo hago yo. Es una query algo compleja y como no soy experto en sql necesito que me hagan esta parte del trabajo.

Por favor, regístrate o inicia sesión para ver los detalles.

solve complex SQL sever query

As decribed via mail

Tengo trabajo en curso relacionado con proyectos anterioresmake the featured users apears first on search and create a new query '

Requerimos un profesional de programación que pueda picarnos el QUERY para realizar una búsquedad de datos en dos páginas especificas con el programa Inspyder Power Search Podeis descargaros la DEMO para ver el Query a redactar y testear su buen funcionamiento. Nosotros tenemos la versión oficial para aplicarlo. [iniciar sesión para ver URL]

Requerimos un profesional de programación que pueda picarnos el QUERY para realizar una búsquedad de datos en dos páginas especificas con el programa Inspyder Power Search Podeis descargaros la DEMO para ver el Query a redactar y testear su buen funcionamiento. Nosotros tenemos la versión oficial para aplicarlo. [iniciar sesión para ver URL]

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#. D...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.

Hi need help with a ms sql query, need top select top 1, in a inner join. start comment with "SQL1" i will send you the query

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 be able to create a quert which will show all posts order by timestamp from a user friends. How can I do this in Firestore in Android Studio?

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

Please read a file called "[iniciar sesión para ver URL]" in the zip file

...analyze queries, isolate the functions (and plugins) which are causing the issues, repair (or rewrite) these functions as needed, and resolve most (or all) of the major MySQL query bottlenecks. Being able to properly optimize MySQL server is a big plus. - This website is hosted on a dedicated server. - This project needs to be completed in a timely manner

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

i need a function to display a table after running a mysqli query $result = mysqli_query($link, $query) or die(mysqli_error($link)); display_datatable($result);

I need to run a query in mysql that give me a count but not count some of the records fld1 is a date fld2 is a customer# fdl3-10 i only want to count a customer once per day.

...there) #2 – User Access to view/search/view/submit requests based on first unit, department, admin (admin all access, unit within that unit only, department within that department only one department can have many units., DEPARTMENT can also have multiple entries so that person A can have access to department A and B. Admin obviously access to everything

Por favor, regístrate o inicia sesión para ver los detalles.

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 10%) and days (90 days)fixed so the final number ...

...transfer this data into Xero to create invoices. 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:

Hi I need the mysql query to consult the Grade History, where can be configured the required Course (by Course_id) to Moodle 3.4 BD . It's required experience over Moodle Database and Grades tables , grade_items_history. Just 50 dollars available to this query. By example, the data is same obtained by the same Moodle on "Grade History" Report disponible

Want to built a hana query for BOM

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: [iniciar sesión para ver URL]). Please put the word Mongo as the first word in your ...

Hello, I have following query: SELECT * FROM WWW_Stock_Cpnr_Winkel WHERE ArtikelKode = 'MKN198A005107M/659' I either want to select all products that start with same data before the backslash /. Any idea to make this? Thanks. Keep in mind the Artikelkode change each time. This query is just one example

here is the detail of my project: [iniciar sesión para ver URL]

Need help with the sql query for the following: Need to add a subquery to the Supplier table script - select supplier ID (d1_fornece) and invoice date (d1_emissao) from table SD1330, join to SF1330 (as in the Invoice query) and then from that table to SE4330 where payment terms are in the field E4_DESCRI. Select only the most recent record, by invoice

Hello, I need a programmer with experience in: 1. Python - jupyter notebooks 2. lxml library to parse xml file I will send you a large XML ~1.2Gb with a reasonable schema (large list of relatively simple and flat xml tags) The result should by a single jupyter notebook that parse this file and then executes 5 simple queries on it (simple queries such as search for all elements that has a sub-eleme...

Need some one to work on multi-level complex SQL Query

We are looking for a front end UI/UX developer with the ability to design and connect. We are a big data company that is looking for a fresh look. The problem we are solving is bringing great AI based recommendations to our users. We love the ease of use of a "Slack" like platform with individual channels and chat bots telling our users what's new

I have 10 excel workbooks with indentical excel sheets (same structure). I want a query (in power BI - DAX) to retrieve the information in these sheets in a single data sheet.

I have an Oracle Database File I would like to pull a simple query out and export to excel.

Develop small app based on Python or Google Go to bulk query rest api, with 3000 database entry and store all response in same database

Hello We built an application using code codeigniter and MySQL database (MariaDB), we are facing server issue to getting few record results takes 1-5 min to execute the result. We need DBA to consult us on the solution and fix it.

I have created a Microsoft Access database that consists of 2 tables. I need someone to create queries, and reports for me. This is a basic project but I am finding myself very short on time.

Goal: #1: Using "Report" Sheet when a user types in the Start Date and End Date of data they need, the query will search the "Returns" sheet and display all the rows that fall between those two dates. #2: On "Report" Sheet in Cell B5, total Column G (Price) *Returns sheet will have an infinite amount of rows