Query query工作

...preferred language: i. Query the latest block ii. Get a list of all Validators (or subset, but logic in code to get all) iii. A list of delegators for the largest validator (or subset, but logic in code to get all) 2. PancakeSwap Data Script a. Get access to an Ethereum Archive Node b. Context: will be given c. For the Stake Cake Pool, which currently has > 250,000,000 CAKE staked to it, find the following information: i. When was the current staking contract deployed onto mainnet? Please link to the transaction in which it was deployed. ii. Where can we find the ABI and the Source Code for this contract? d. Write a script in your preferred language: i. To query all deposit events for this contract. You do not need to query all of them, but your code should faci...

...preferred language: i. Query the latest block ii. Get a list of all Validators (or subset, but logic in code to get all) iii. A list of delegators for the largest validator (or subset, but logic in code to get all) 2. PancakeSwap Data Script a. Get access to an Ethereum Archive Node b. Context: will be given c. For the Stake Cake Pool, which currently has > 250,000,000 CAKE staked to it, find the following information: i. When was the current staking contract deployed onto mainnet? Please link to the transaction in which it was deployed. ii. Where can we find the ABI and the Source Code for this contract? d. Write a script in your preferred language: i. To query all deposit events for this contract. You do not need to query all of them, but your code should fa...

I need codes for phpmyadmin to query my databse. Mostly for woocommerce reports. current stock value inventory count inventory value fast moving slow moving comparison forecasting tip profit expiration and email notification closing inventory, items sold, items sold per day, days cover, and average cost. top sellers, worst sellers, and year-over-year growth deadstock cost of goods taxes, discount etc thanks

Count the number of times in a row a taxonomy is used in a loop until it's not and store then number, then continue checking the next number of times its used until it's not until the wp query goes through all posts. Full details/example in the attached pdf.

...books. I plan to provide customers with the option to purchase items online and will definitely be offering delivery services. The scope of this project includes creating a website that is both user-friendly and visually attractive. The website should have the ability to easily add and manage new products, while providing a secure payment gateway, Books category display, whatsapp icon for any query, about us page, Cart, login and signup page, order confirmation mail generation. Ultimately, I want my customers to have the feel of an actual bookstore experience from the comfort of their own homes. I also need following things in my website : Website should be responsive (it should work effectively on mobile phones and desktop as well), fast product search tab, recommender syst...

hi guys I have a database currently in emergency mode. The DBCC CHECKDB query suggested repair_rebuild I have put the db in single user mode but the repair option wont run because it says its in emergency mode. Need an excellent SQL tech to assist. thank you

hi i need codes for phpmyadmin to query my databse. Mostly for woocommerce reports current stock value inventory count inventory value fast moving slow moving comparison forecasting tip profit expiration and email notification closing inventory, items sold, items sold per day, days cover, and average cost. top sellers, worst sellers, and year-over-year growth deadstock cost of goods taxes, discount etc thanks

Looking for a Database expert who has extensive experience in Amazon Marketing Cloud and SQL query. Would like to generate some data from the existing tables and optimize the complicated queries.

Hello, I am looking for a concerned freelancer to help me with developing a web scrapper to scrape one specific web-site using multiple queries. The project requires scraping only some specific pages, which need to be done accurately and efficiently. Moreover, I also require additional processing of the scraped data. Most important things for me are: a) ability to query web-site by providing information in three different fields in order to be forwarded to next / output page b) the speed of scraping, supporting multiple threads using socks proxies (for example 100 scraping sessions at once) + updating proxies and rotating them every certain period of time c) convenient method of saving the output data (excel database, text files) - which in future I could integrate with some solu...

...build the following features: 1. Role-based admin logins 2. Bulk upload of influencers through sheets 3. Select/reject profiles features 4. Influencer listing page based on the filters user set like location, follower range, avg video views etc. 5. A details page of the influencer 6. export the list of influencers from the listing page 7. Create/edit campaign form (broken down into 2-3 steps) 8. Query to suggest influencer profiles based on quantitative criteria set in the created campaign 9. Lists - a feature where we can create a list with a specific name and put multiple influencer profiles there 10. Send automated WhatsApp messages to all the shortlisted influencers 11. Capture their responses via WhatsApp 12. Export this list into a sheet 13. A separate form for the influen...

I'm looking for a Google Sheet Query specialist to help me build a project that can automatically track time and generate invoices. The ideal candidate should be well-versed in commonly used Google Sheet functions such as the =QUERY() function and be able to work with external sources of data, if and when necessary. The main purpose of this automation project is to automate the invoice generation process and streamline the tracking of time. The ideal candidate must have a deep understanding of the =QUERY() function and the ability to use =Importrange() and =VLOOKUP() functions, as well. The project may require the use of external sources of data, either in the form of an imported file, or as an online database which needs to be queried. If you feel you possess...

I am looking for a talented and experienced Laravel developer to help me fix the search result and sort function on my website. It is currently running on Laravel 5, but the particular version is unknown. No database query changes are necessary, although it could be helpful. The task does not have a specific time limit, though I do expect the project to be completed in a timely manner. If you have the skills and expertise required, I invite you to bid on this project.

Hi, I need someone to write an ansible playbooks to: Cloudflare: -------------------- Create the zone Add cname record import a zonefile Change SSL mode Create a loadbalancer Runcloud: -------------------- create the app create the db create the dbuser create the db grant ... Other -------------------- upload files using via SFTP execute a mysql query .. I will provide an ansible server and accounts where dev can be done.

I have a filter function where I'm selecting data based on the date in the a dateTimePicker tool. I just need an if checkbox is checked then apply filter adding to it. It is in query syntax and not method syntax so that might be the issue. Should be really simple for someone experienced.

Looking for android and iOS developer for a small sales project. Feature list : Login/Sign Up Listing of queries Admin Can set the status of Accept /Reject for any query Push Notification Edit Profile Logout

my wish is to have a database to track my RFQs (request for quotes), Qts, Sales Orders with vendor orders (Purchase Orders to fill the customer order), invoices, and commissions for my independent sales reps. 1. RFQ includes RFQ#, Customer, RFQ date, Customer, Contact, Due Date, Quantity, Produc...established from Cost ....apply formula based on cost X Risk factor, X Warranty factor, X Margin factor Will figure this out after the first part is in place. i have a spreadsheet that i'm using now and i'll share it when i find the right person to do this project. please advise time expected to get the first tables done, so i can begin populating them. The reports will be payroll which will run a query based on time range, with income received and commission calculated. for th...

Requerimos ayuda para completar un proyecto, el cual requiere construir 3 módulos para un proyecto, y la parte de registro, inicio de sesión, seguridad de usuarios y protección de rutas… El proyecto consta de las siguientes tecnologías: React NextJS React Query React Hook Form TailwindCSS Firebase Auth El diseño y el API ya están hechos, básicamente se requiere que le den funcionalidad al sitio en esos modulos. Los formularios son grandes, de alrededor de 40 campos divididos en 3-4 pantallas o en un modulas en algunos casos… Si se sabe Canvas sería un plus… Freelancers solo de Mexico y America…

...modeling and design: The candidate should be proficient in creating Entity-Relationship Diagrams (ERDs) and designing normalized database schemas to minimize data redundancy and ensure data integrity. Normalization techniques: The freelancer should be familiar with various normalization forms (1NF, 2NF, 3NF, BCNF, 4NF, 5NF) and be able to apply them to optimize database structures. SQL (Structured Query Language): Proficiency in SQL is crucial for working with relational databases, as it allows the freelancer to create, manipulate, and retrieve data from the database. Familiarity with database management systems (DBMS): The candidate should be experienced in working with popular relational database management systems like MySQL, PostgreSQL, Oracle, or Microsoft SQL Server. Da...

I have a ready software where users can upload a data using input field to the database. But I need a system where user will be able to upload bulk amount of data only with PDF or DOCX files. And also a Boolean search(Jira Search Query) You must have the below experiences. *OCR Expert for PDF *Boolean Search (Jira Query Search Filter) Please submit your proposal after reading the description.

The freelancer should have a track record of successfully getting articles approved on Bing Pubhub and Google News. They should be able to demonstrate their expertise and understanding of the guidelines and requirements of these platforms. Also for Google News I need my blogs feature in News section when you search query through Google Search (Refer Screenshot for more info)

visit I am short of time and will require help of professional to complete it. Have loaded woocommerce plugin. 5 sample digital proudcts added to shop page of so that I can initiate process of Payment gateway integration. Visit...types of filters above and in left side bar. I have tried both plugins demo and they are suiting my needs. Will need professional help for designing and usage of appropriate blocks for shop & products pages. Wanted to install membership plugin for subscription feature for viewing excel data in table format. (wpdata table plugin purchased for my site). Need to convert 80k row tables to my sql query so that I can import through wpdatatables. I think, this work should get finished in 3 or 4 days. If interested, then let me know.

I need someone to modify my macro to also have 2 more cases for shift start and shift end times separately. right now it includes the full shift time IE: 3:00 PM to 4:59 PM. I need just the start time in column O and end time in column P. The file is on a VM for the database connection so if you want you can also work on team viewer or I can send you the code and then you can send it back to me.

I already have a NAVBAR. I need a searchbox to fit in it (align) on the rightside both for regular and for media queries. The search box should show input box with magnifying glass at the end to send the query back to the Python server. I need autocomplete suggestions defined in Javascript.

I am looking for someone to write a query for me. The query needs to be in the Select language and be written for a MySQL database. I am looking for a query that will return the entire contents of the database. I need someone with the expertise to write a high-performing query, so I can have up-to-date information at all times. If you think you are the right candidate for this project, please get in touch.

...standards. Any suggestions that could create additional value to the application are welcome. We aim for the most simple implementation possible at first. The full app will be around 7-10 pages. Requirements (Use Cases): - User shall be able to create an account / login - User shall be able to receive, interact and download content in an "user area" - User shall be able to enter information in a query - User shall be able to search, purchase, access and download digital products - User shall be able to contact employees under certain circumstances via chat and contact formula - Employees shall be able to access information in an "employee area" - Employees shall be able to chat with users under given circumstances Requirements (Technical): - Web-first, but...

...the system should grade the quiz. Show the correct answers, wrong answers as well as the score in percentage. Your tutorial should demonstrate at least five input types. You should use an external style sheet to retain a consistent and user-friendly interface. Demonstrate use of grids, floating element/layout, figure box, background image, figure box, shadow, gradients, 2D transformation, media query, multimedia, and JavaScript. The page should include at least the following structural elements: article, aside, figcaption, figure, footer, header, img, main, nav, and section. You may use additional elements as needed. Choose a color and typography theme for your webpage. Use proper semantic elements. The presentation of the webpage should be controlled by a CSS stylesheet. Add com...

I'm looking for a Freelancer to help me set up Microsoft Power Automation for my business. The primary purpose of doing so is to automate manual processes, saving me time and effort. However, I do have some specific requests related to the setup and I will need you to guide me in my system. Currently, ...purpose of doing so is to automate manual processes, saving me time and effort. However, I do have some specific requests related to the setup and I will need you to guide me in my system. Currently, the process takes time and I'd like to reduce this time in order to improve my efficiency. If you are an experienced professional with knowledge of Microsoft Power Automation flow, desktop and power query and can help me with my setup, please contact me. Your English needs to ...

The Requirement is , need to run queries using data-lake using nodejs currently we are running queries over mongodb but the query time is too high so need to use data lake over mongodb for imporving the quering speeds in nodejs

...new version of the Web site 5. We have a link (plugin configured correctly) between the Facebook/Instagram accounts that works fine and needs to be preserved 6. We have google AdWords configured correctly and needs to be kept as is. This item needs to be offered as a separate item! 7. We need a plugin that could search all sales based on the timeframe: month, week, or day and based on the query it needs to create a downloadable CSV file. All rights for that plugin should be in our name, and we should be able to distribute it as a paid or free plugin depending on our decision. The developer in this case will transfer all the rights to us, and will not have any request further. If we are intending to hire the same developer or somebody else to maintain the plugin that must b...

I am looking for a freelancer to help me figure out how to use Excel Power Query in accessing REST API. I will share my screen and you will show step by step how to to do that. Kindly type AP on the top of your bid.

I am looking for a freelancer to help me figure out how to use Excel in accessing other APIs. REST will be the type of API that will be used. Excel Power Query will be the technology used to access the successful freelancer will have experience with Excel Power Query, APIs, and REST. Kindly type AP on the top of your bid. I look forward to working with you soon!

I want a local transform where I can input a string in Maltego and it returns any ASNs related to that entity Query results from: Two fields to return: Result - only return results starting with AS followed by numbers Description - Please ask any questions first

Simple data entry but need to know excel query files Start bid with " Query"

I need the different excel lines to be turned into posts on my wordpress site. please use the gold/silver/bronze delineation as author. please add category as category. No featured image necessary. Put the purpose in the main area of the post along with the link and access instructions. Also add the purpose as the exerpt. There are about 30 posts that must be made. Must have excel query experience, wordpress experience, and data entry. Nothing too complicated, i will provide login details for the wordpress page upon award but you can check out the excel now. Let me know if you have questions.

Brief: -Produce a report on Adult's shoes performance for the date range 26th-30th of March 2021 -Identify the top 5 products by revenue for each gender (male, female, unisex) SQL Query: Using the “with” construct, write a query to pull the necessary data from the tables performance data and product data (attached). Excel: LARGE, VLOOKUP, Max if functions Joining and aggregating the data together and filtering to match the conditions in the brief. PD: there is not acess to database, it is only an exercise.

...com/pjsip/pjproject/blob/master/pjsip-apps/src/swig/java/ ) So the app has to work on a desktop (macOS) and have to communicate with a SIP provider only. e.g (we will share you a fully working sip account after award) Later (not scope here) ports to iOS/Android required too The caller-URL contains some query parameters, like the callers number. The app can run only one instance and is listening to incoming calls. On incoming call it triggers a browser open of the above caller URL like The full SIP environment will be: - your SIP app, connected to the sipgate-account - optionally other machines also running your SIP app on multiple desktops - one or more SIP

We are in need of a php developer We are looking for a PHP Developer responsible for the following: Build efficient, testable, and reusable PHP modules. Solve complex performance problems Skills: 1. Strong knowledge of PHP web frameworks such as Laravel. 2. a Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3. 3. Experienced in...Developer responsible for the following: Build efficient, testable, and reusable PHP modules. Solve complex performance problems Skills: 1. Strong knowledge of PHP web frameworks such as Laravel. 2. a Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3. 3. Experienced in object-oriented PHP programming. 4. Familiarity with SQL/NoSQL databases and their declarative query languages. 5. SEO ...

Tasks: 1.- Define hardware specifications for a VM, linux distro and version and we'll provide corresponding ...config of GenieACS 4- Create provisioning templates for AVM Fritz!Box (2 models, 7530 and 7590) 5.- Specific to routers: Being able to monitor these parameters from the devices: ping, manage WAN settings (PPPoE dialin or DHCP), manage PPPoE credentials, manage vlans, manage multiple VoIP accounts and VoIP PPPoE login Provisioning data will come from an external RESTful API with JSON response. Query parameter is the provided serialnumber of the specific device. It will return all credentials (PPPoE, VoIP, etc.) at once. A sample will be provided. We need to have the project completed within 2-3 weeks. This project is only opened to people with good TR-069 deploym...

请注册或者登录后来查看详情。

...tasks: We start with a list of countries with root YouTube websites and the corresponding language for that country We have a list of queries 1. Select country from provided list 2. For each country, translate the queries into the target language using the Google Translate API. 3. Prompt the user to change their VPN to the target country manually. 4. Perform a YouTube search using the translated query and the target country's region code. 5. Extract the search result URLs. 6. For each search result, fetch the following information from returned videos: • Video title • Video views • Channel name • Channel subscribers • Channel email (captcha solving will be required) a captcha service recommendation would be needed 7. Save the extracted information ...

Hi, We are a sofware company that have a desktop applicaton similar to a CRM tool, which mainly does invoices and stock reports. This software it's been in the marked for 20 years, and we have reviewed the report layout few times, but we are not getting the fine touch in the design that we would like. I'm not looking to a sql / query expert, we are looking specifically somebody that can change the look and feel of the reports to something more according to modern days. Ideally we will need a crystal template that we can reuse in all our reports in order to get the right color pallet and the layout lines. Attached some samples of reports that we have currently to get an idea. Thank you.

I am looking for someone to help me with a project involving sql (Structured Query Language). I don't need help writing a query, but I don't have an existing database nor do I have the structure set up. I also do not need help creating stored procedures. The project does not involve any of these tasks. I simply need somebody to help me with sql for a particular project.

I am looking for a GCP data engineer to provide online training and support for a small set of batch within a 1-month timeframe. The training and support will be provided using Google Cloud Platform. GCP BIG QUERY, GCP CLOUD PUB SUB, GCP SPANNER, GCP DATA PROC, GCP CLOUD COMPOSER This project requires the data engineer to have an in-depth understanding of GCP and the ability to develop, deploy, sustain, and manage cloud-based data services according to best practices. The data engineer must also be highly knowledgeable of the existing infrastructure and understand the relationship and dependency between cloud service data engineer should also be experienced in delivering clear and concise training to those who require it, as well as providing maintenance and support when needed

...with Oracle SQL Query Tuning and improve Oracle Performance. I will be using Oracle Exadata Database and therefore the successful freelancer should have prior experience working with these versions. The specific work required is Ad-hoc Query Tuning so the applicant should include relevant past work and experiences as part of their application. Detailed project proposals are also appreciated. Scenario: 4 Oracle SQL Queries that we have taking time anywhere from 3-7 minutes and wanted these to be running in less than 30 seconds. So require some one with Oracle SQL Performance Tuning Expertise to rewrite the query or Add any DB Configuration or Indexes or other Performance enhancement tips to cut that runtime down to 30 seconds or less. Amount of data that's com...

Looking for an experienced freelancer to develop an MVP for a WhatsApp-based chat platform that supports text-based query resolution, allows anonymous access, and includes an analytics system to track query resolution. The goal is to create a simple and user-friendly system that provides quick and easy query resolution for users. The ideal candidate should have experience in WhatsApp integration, database management systems, and analytics. Knowledge of text-based query resolution and security is also required. Responsibilities include developing a system that supports text-based query resolution, allowing anonymous access, and includes an analytics system to track query resolution. The system should be built in such a way that it can be easily up...

Deliverables: Query resolution - finding cause of failed reports and fixing them. Prerequisites: Understanding of the Database and Reports. Temporary access to the platform and it's elements.

We’re looking for a Wordpress professional to work with us to set up our Website. We aim to have the site designed and developed by 21st April You must be dynamic and willing to work with us as we design and bring the site to life. Budget for this Project is $250 **Theme** Our preference is to find a developer with experience using the Qwery Theme - Theme here - - Demo site - ** Do respond if - you have extensive Wordpress experience - you have worked with this theme in the past - you have a portfolio of previous projects - you can provide the level of commitment required in the next 4 weeks ** Please do not respond if - you do not have a high proficiency in English - you cannot commit to complete the site in a short space of time (our budget reflects...

...com/pjsip/pjproject/blob/master/pjsip-apps/src/swig/java/ ) So the app has to work on a desktop (windows, linux, macOS) and have to communicate with a SIP provider only. e.g (we will share you a fully working sip account after award) Later (not scope here) ports to iOS/Android required too The caller-URL contains some query parameters, like the callers number. The app can run only one instance and is listening to incoming calls. On incoming call it triggers a browser open of the above caller URL like The full SIP environment will be: - your SIP app, connected to the sipgate-account - optionally other machines also running your SIP app on multiple desktops - one or more SIP

There is an open API provided here: I have a list of postcodes attached. I want a power file with a query that calls the API and returns all results for all the postcodes in the attached file. We will need the ability to add more / change post codes in the future. The key for API can be provided once work starts.

Hi, We are looking for expert who could help us get data on existing report in SQL server reporting services & microsoft report builder, 2 reports are currently not returning data suddenly everything is intact, we are using SQL server 2016. SQL query in dataset is not returning data as of now. connection string / some connection dataset or queries needs to be checked. There is a table created by our team in SQL 2016. We need help in getting the data from database.