Query designงาน

...Remove the "//const MongoClient = require("mongodb").MongoClient;” line 2 - Run ‘docker compose up’ to start the code 3 - Fix the code so it does not crash 4 - Demonstrate a working connection between the application and a remote Mongo Atlas database (you will need to create one yourself or point to one). The data does not matter, I just need to see examples of: a) A READ query, b) An UPDATE query, c) A CREATE new record query Error See this file for a description of the error which needs to be fixed - Debugging The application connects to a remote Mongo Atlas database correctly if the code is run outside the container. I’ve developed a simple Mongo connection js file which tests this. The output is shown here - h...

...processes it in Wordpress. The Incremental link makes a POST request to this script containing the data. In the script you see 3 types of actions in a switch: Add (new vehicle) Change (vehicle exists, adjustment is being pushed) Delete (vehicle is deleted) Below is a brief explanation of the three functions involved: add_post Here I build a Wordpress Query containing data from the POST request. Then I run a "wp_inset_post" function with this query. From that Wordpress function you will then receive a "post_id" with which I will add photos to the post. change_post Same as "add_post" but I use the "update_post" function because I already know the post_id. Then I'll delete all the photos from this post and add them again. I do ...

...essential. Introduction: Join our team as a Data Engineer, where you'll have the opportunity to contribute to cutting-edge projects and drive significant advancements in data analysis and machine learning. We are looking for a highly skilled professional who thrives in a dynamic environment and is passionate about transforming large volumes of data into actionable insights. Responsibilities: Design, construct, install, test, and maintain highly scalable data management systems. Ensure systems meet business requirements and industry practices. Integrate up-and-coming data management and software engineering technologies into existing data structures. Develop set processes for data modeling, mining, and production. Employ a variety of languages and tools to marry systems to...

...JavaScript framework (React, Angular, Vue.js) considering factors like project complexity, team expertise, and desired features. Back-end: Select a server-side technology (Node.js, Python with Django/Flask, PHP with Laravel) based on performance requirements, scalability needs, and developer familiarity. Database: Choose a suitable database (MySQL, PostgreSQL, MongoDB) based on data structure, query complexity, and scalability requirements. Other Considerations: Authentication/authorization, payment processing (if applicable), CMS (if needed). 3. Development Process: Front-end Development: Implement the user interface and user experience using your chosen framework, following component-based architecture for maintainability. Back-end Development: Build your server-side APIs usin...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm looking for a proficient SQL professional with notable expertise in SQL Server 2019. Key tasks will involve: - Query optimization - Database design - Data migration The ideal candidate should have a solid understanding of SQL Server tools and a proven track record in handling similar projects. Your previous experience and knowledge of SQL Server 2019 will be pivotal in this role. Your task will be primarily centered around maximizing the efficiency and effectiveness of the SQL Server. Preference will be given to professionals with certifications in SQL Server 2019 or related fields. Solid written and verbal communication skills are desirable.

As an exper...experience in Laravel and you're familiar with Laravel 11. • You've previously developed websites using Laravel 11. • Your forte is optimizing code efficiency and database queries. • You have a strong understanding of how to improve page load times and database query speed. Your task: • Optimize my existing codes in Laravel 11, for open source project • Main areas for optimization include database queries and code efficiency • The goal is to achieve faster page load times and improved database query speed. • Test subscription and plans, if it works fine or not Please, only apply if you have the mentioned skills and experience and you're able to demonstrate evidence of past projects you've optimized for p...

I am in need of an exp...developer to create an interactive, transactional platform with the ability for information sharing, social interaction, and query resolution. This platform should be accessible both as a mobile app and a website, with seamless functionality across Android, iOS, and various web browsers. The ideal candidate for this job would have the following skills and experience: - Expertise in both app and web development, with a portfolio of interactive, transactional sites/apps. - Experience with Android & iOS app development. - Understanding of user experience, particularly in relation to e-commerce and social networking. - Proven problem-solving skills in the area of query resolution. Please provide examples of your work and detail your experience w...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

ASAP you need to complete all the tasks on this page, take a screenshot with an open notebook (with one text sent by me) and the program to confirm that the query has been completed. In the second word, just the text with all the queries.

...need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server configuration - Ability to work remotely using tools like AnyDesk - Excellent commu...

...need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowledge of query optimization techniques - Familiarity with the file and server configuration - Ability to work remotely using tools like AnyDesk - Excellent commu...

I require a proficient developer to design a functional asp.net / vb template which will be the foundations of an internal business tool/website. A very BASIC MS SQL schema will be provided for Functionality to interact with. The project includes: The development of a lightweight css, jquery design that is simplistic but still looks ok. Static Pages - Home - Contact Us - About Us Functionality Pages - User Registration - User Login - User self management) - Password reset via email. - User Management admin The sample should show, connecting to an ms sql database. Displaying data through a non defined data source eg (a query enbeded in the code) as well as a defined Datasource. The site should use headers and footers. VS2022, has a sample site, it could be poss...

I aim to create a music blog using WordPress, focusing on showcasing different genres and providing readers with insightful articles. Since this platform is not designed for music streaming, key elements will be centered around content...is blogging, ideally, freelancers should: - Have experience designing WordPress websites, particularly blogs - Understand the music industry to some degree - Be able to incorporate engaging visuals that suit the music theme - Possess SEO understanding to optimize blog posts for search engines - Demonstrate creativity in designing user-friendly layouts and easy navigation Though I skipped the query about the main features, I’m open to any suggestions that could enhance the blog's effectiveness, keeping readers' interests and continu...

I am in need of a MySQL expert to develop advanced queries for my database management tasks. Key Responsibilities: - Writing new queries: You'll be responsible for designing and implementing new, advanced MySQL queries. - Query Optimization: While the focus is on writing new queries, any optimization suggestions to existing queries are welcome. Ideal Skills: - Proficiency in MySQL: You should have advanced knowledge of MySQL language and its various functions. - Query Optimization: Experience in query optimization will be beneficial. This project is suitable for a MySQL developer with a proven track record in creating complex, high-performance database queries. It's important that you're able to work efficiently and effectively in order to meet the pr...

...Excel sheet. We also can’t just write code to remove the 30 columns prior to the last column, because all user files might not have the columns in the same order, so a required column might find itself in one of those locations. Based on my test results, one possible solution to the problem might be to write the code such that it only transfers the 10 columns that are needed in a subsequent mysql query. However, any solution that fixes the problem will be great. Here's what I need you to handle: - Diagnose and fix the issue. - Ensure successful creation of tables in my MySQL database from Excel data. Ideal Skills: • PHP • MySQL • Expertise with PHPSpreadsheet • Debugging • Experience with Excel-data moving projects. Informed bidding i...

I'm looking for a proficient PHP developer who can help me with parameterizing a MySQLi query in my project. Specifically, I need assistance with data retrieval operations. Key requirements: - Proficiency in PHP: You should have a strong grasp of PHP programming. - MySQLi Query Parameterization: The ideal candidate should be experienced in properly parameterizing MySQLi queries. - Data Retrieval: The primary task will be focused on data retrieval operations. The project may include: - Handling multiple parameters: You should be comfortable working with queries that handle multiple parameters at once. - Optimization: Ensuring the queries are optimized and secure. It's a relatively straightforward task for a skilled PHP developer with MySQLi experience. If you...

I’m looking for an expert with MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore ...

Hi Yusuf A., I noticed your profile and would like to offer you my project. We can discuss any details over chat. Procedure:  Upload Excel file containing Expediente Codes  Use automation and OpenCV to solve Captcha and download files  Upload files to s3 bucket  Integration with existing system query api sunat use email for login

I need an in-depth and comprehensible 2000-word report on relational databases. This should include: - A focus on normalization and handling of relational database constraints. - An E-R diagram and an SQL query. The project description doesn't specify requirements for these, so use your expert judgment to determine what is necessary. - The report should also be accompanied by a 15-slide PPT presentation summarizing the report's highlights. Ideal Skills & Experience: • In-depth knowledge of DBMS • Expert understanding of relational databases • Proficiency in E-R diagrams and SQL query • Excellent report writing skills • Experience in creating engaging PPT presentations.

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10 must c...

I require a skilled developer to address my Breakdance Builder issue urgently. Here are the specifics: - I am currently unable to retrieve specific content using the existing query to get taxonomy (Meta Box) content in Breakdance Builder. - I prefer the method of rewriting the query from scratch. This way, we can avoid any potential issues within the existing query and ensure the accurate retrieval of specific content. Time is of the essence for this project, so I need someone who can commit to completing it ASAP. Ideal Experience: - Proficiency in Breakdance Builder - Strong background in PHP and MySQL - Previous experience with Meta Box - The ability to work quickly and efficiently Please get in touch if you have the necessary skills and can commit to this projec...

...create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the chatbot should also be integrated. Ideal

...this metadata to construct and manage API endpoints dynamically. 4. ORM Flexibility: Any ORM tool like Entity Framework, Dapper, or SQLkata can be utilized to facilitate database operations. The choice of ORM should align to optimize performance and simplify maintainability. 5. Advanced Data Handling: Column Selection: API users should be able to specify which columns to retrieve in the query. Filtering and Sorting: Support comprehensive filtering and sorting capabilities to navigate through data efficiently. Pagination: Implement pagination to handle large datasets effectively. Aggregation and References: Enable aggregation of data from child tables and retrieval of related data from master tables (e.g., retrieving a customer's name when querying...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

...Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...

I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're the righ...

...integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels (it's the DYMO LabelWriter 450 Turbo) with slightly different fie...

Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

...tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and custom query builders. - Strong analytical and data organizing skills. - Experience in converting independent Excel worksheets into a master file. - Kno...

Postgres data query system Docker across multiple servers

...HTML, and CSS. Responsibilities: - Collaborate with the team to gather requirements and design the application architecture - Develop and implement front-end components using modern frameworks like React Native - Build and maintain APIs and databases for seamless data flow - Ensure the application is responsive and compatible with various devices and platforms - Conduct thorough testing and debugging to ensure high-quality and bug-free code Requirements: - Proven experience as a full stack developer - Familiarity with mobile application development, particularly in the medical industry - Strong programming skills in JavaScript, HTML, CSS, and relevant frameworks - Proficiency in database management and query optimization - Knowledge of RESTful APIs and best practices for...

Need a backend developer to implement bel...client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("919999784665"); 3. For sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If they do, then we...

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play ...

Need a Windows program that logs into an account, allows the user to enter a 2FA code in a browser window, enters queries into a search from an input XLS file, and on output saves the search status for that query.

Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos. A continuación, copio la query que genera el problema (ver captura para más información): SELECT SQL_CALC_FOUND_ROWS from vsnucam_posts left join vsnucam_term_relationships on ( = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on ( = tt1.object_id) left join vsnucam_term_relationships as tt2 on ( = tt2.object_id) left join vsnucam_term_relationships as tt3 on ( = tt3.object_id) left join vsnucam_term_relationships as tt4 on ( = tt4.object_id) where

...automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensure proper email categorizati...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

script for auto replying mail with attached files

...is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price. Also need to be able to generate a barcode in a query and report. See Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says. Inventory dashboard and reports like aging, velocity etc. Sales Should be able to create a customer from the sales order screen. Sales order will be created using customer

I am currently looking to engage an experienced Machine Learning professional for my project. I require analysis to be conducted on text data as well ...as well as numerical data. A strong understanding of Machine Learning concepts and analytical skills are vital. While I have not specified a particular focus area of Machine Learning, I am open to recommendations from the chosen freelancer based on the data provided. Key requirements include: - Proven track record in Machine Learning - Proven track record in Google Gemini and Google big Query ML - Proficient in data analysis and interpretation - Experience working with both text and numerical data Critical thinking and problem-solving skills with attention to detail will be necessary for the successful completion of thi...

MS1: Solana Data INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No) - Optional but great to have: Mint authority status (Permanently revoked, time-limited etc). 5. Liquidity info. - Must have: Percentage of the liquidity locked (%) - Must have: Liquidity burned? (Yes/No) - Optional but great to have: Liquidity lock autho...

...performance of our aggregation pipeline. The focus is on improving the response time and enhancing our capability to handle large volumes of data proficiently. The goal is to reduce response time to under 100 milliseconds without compromising data accuracy or integrity. WE WILL PROVIDE A PYTHON SCRIPT THAT CONTAINS MongoDB AGGREGATION PIPELINE Key Responsibilities: - Review and enhance the query performance - Optimize our large volume data handling - Analyze and understand the existing aggregation pipeline. - Identify potential bottlenecks and areas for optimization. - Implement efficient algorithms and techniques to enhance pipeline performance. - Ensure that the script returns data in less than 100 milliseconds. - Test and validate optimizations to ensure accuracy...

...functionality of the application. Key Responsibilities: - Identify the root cause of the pagination issue - Resolve the bug to ensure the pagination system functions correctly - Test the application thoroughly to verify that the issue has been fixed Ideal Skills and Experience: - Proficiency in PHP and Laravel framework - Prior experience with Laravel's built-in pagination - Strong knowledge of Query Builder - Ability to troubleshoot and debug complex issues - Excellent problem-solving and communication skills It's crucial that the freelancer I work with has a keen eye for detail and a track record of successfully resolving similar issues. The individual should also be comfortable with working in a fast-paced, deadline-driven environment. Here is a video that expla...

I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task should under...

...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...

...the page should not lock up permanently or be flagged permanently with frequent use or fast refreshing of the page. INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. (This check intends to find out wallets with pre-mined tokens). Please have this list collapsed to item 2 below when the page first launches). 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No...