Wordpress database queries jobs

I am looking for an expert in MS Excel and navigating a website. We will provide a list of certain colleges and universities in the United States, 258 of them. Go to and type the name of the school, then type “athletics staff directory” and hit enter/search. The first site listed will be the staff directory for the athletic department. Scroll down to the Football staff. For every member of the Football Staff who has an email address listed, you need to enter that staff member’s information (School Name, First Name, Last Name, Title, Email Address, Twitter) into the spreadsheet. This is a single project that would need to be completed each year. Pay would be made upon completion of the project. Mode of communication is English.

I'm looking for a professional to help in setting up an SQLite database which will store and manage moderate data with multiple attributes. Key requirements: - The database should be optimized for storing and retrieving moderate data, such as an inventory system with multiple attributes. - No complex data analysis is necessary, just a user-friendly system for managing and retrieving stored data. - Basic search and filter functionalities are required. Ideal skills for the job include: - Proficiency in SQLite database design and management. - Experience in setting up databases for inventory systems or similar systems. - Ability to implement basic search and filter functionalities.

I'm currently experiencing slow performance from my WordPress database that appears to be most apparent when using Mysql/MariamDB which is affecting my admin and dashboard areas. Ideally, I'm seeking assistance from a professional with substantial experience in WordPress and database optimization. The main skills and experience required include: - Knowledge and skills in MySQL/MariaDB - Expertise in WordPress database management - Experience working with websites having more than 20 plugins. Your task will include performing necessary optimizations to significantly enhance the performance of the website, specifically the admin and dashboard areas. Please, include examples of similar projects you've worked on when bidding.

I am in immediate need of a comprehensive database containing information about IT professionals with 2-3 years of experience. This is crucial for a current initiative, thus I need it ASAP. The database should provide: - Name - Phone Number - Skills - Educational Background - Work Experience - Salary Precision is of utmost importance to me. Therefore, an ideal freelancer for this task should have proven experience in data collection and data entry, with a keen eye for detail to ensure the accuracy of the database. Experience in the IT or HR industries would be a significant advantage.

I'm in need of an experienced Salesforce consultant to guide me through the process of publishing my managed...my app for the Security Review process. Your role will be to ensure that the app meets Salesforce's security standards and requirements. - **Licensing Questions:** I'm looking for someone who can answer my queries and provide guidance on licensing considerations. Ideal Candidate: - Strong experience with Salesforce Lightning is a must. - Proven track record in successfully publishing apps on Salesforce AppExchange. - In-depth knowledge of security standards and licensing on Salesforce. - Excellent communication skills to effectively guide me through the process and answer my queries. If you have the skills and experience in this area, I would be m...

...data into a database. While the data entry itself isn't particularly complex, a certain level of basic data cleaning will be required. Key Requirements: - Data Entry: The main task is to accurately input data from PDFs into a database. The data is mostly textual, so typing proficiency and attention to detail are essential. - Database Organization: The entered data needs to be organized in a clear, logical manner to ensure it's easily searchable and can be efficiently used. - Basic Data Cleaning: The data will need to be reviewed and cleaned up to ensure accuracy and integrity. This will involve identifying and removing any duplicate entries. Ideal Skills and Experience: - Proficient in Data Entry: Experience with data entry tasks, particularly those inv...

I am ...customers. The integration is expected to have a significant impact on our business processes by helping with: - Automating Order Updates: This will not only save time but also improve the accuracy and timeliness of information delivered to our customers. - Improving Response Time: By automating certain aspects of communication, we aim to be more responsive and efficient in handling customer queries and concerns. Ideal Skills: - Proficiency in Odoo development, particularly version 17, is crucial. - Prior experience with integrating Odoo with external systems like WhatsApp. - Proven track record of automating processes and enhancing customer communication through technology. - Strong understanding of business processes and the ability to tailor the integration to our speci...

I'm seeking a skilled personal assistant with hands-on experience in the fashion industry. As my PA, your primary responsibilities include: - Scheduling appointments: Connect with models and photographers, set up photo shoots based on flexible schedules. - Managing emails: Maintain proper communication within the network. Respond to queries efficiently. - Researching information: Gather relevant information regarding current fashion trends, potential job opportunities etc. Desirable skills would include impeccable organization, strong communication, and a proactive attitude. Familiarity with Instagram for scheduling and handling correspondence is a must. If you are adept at juggling multiple tasks, widely-versed in fashion, and have a knack for connecting people, I'd lov...

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

For this project, I'm seeking an experienced developer capable of creating a h WhatsApp Chatbot which can handle these tasks: 1. Answer FAQs: The bot must be equipped to respond accurately and timely to frequently asked customer queries. 2. Collect customer information: It should also be able to tactfully gather valuable data from users during its interaction, ensuring confidentiality. 3. Provide product recommendations: Lastly, the chatbot should adeptly suggest suitable products to clients based on their interaction, enhancing their experience and facilitating upsell. This bot will be essentially customer-focussed, thus any previous experience in crafting similar customer-oriented bots would be highly prized. Please provide evidence of similar projects you have completed an...

I'm urgently in need of a skilled professional who can swiftly deploy a database server for me. Key Responsibilities: - Establishing a server primarily intended for databases - Choosing the suitable database management system (DBMS) Ideal Competencies: - Extensive experience with multiple DBMSs as I'm not yet decided on which one to use - Ability to work under pressure and deliver swiftly since the project is urgent - Prior experience with server deployments will be highly advantageous.

I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication.

...an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of accurate and updated reports. Ideal Skills: - Pro...

I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.

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

I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Records to revise. Work needs to start asap and be completed with a good team. This is not a one person job. I need all records completed real time from a file on google drive. Must be complete with 24 hours Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong track recor...

I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp

I am looking for a professional to develop an independen...essential functions of the Chatbot should include: - Resolving frequently asked questions - Displaying our services, along with their prices - Interacting with our customers The chatbot should sport a modern visual design, harmonized with the use experience we aim to provide to our clientele. Furthermore, I desire the chatbot to have limited autonomy. It should be able to independently resolve queries and foster interaction, but should require human confirmation while performing certain tasks. Ideal candidates should have prior experience in developing chatbots, especially for WhatsApp, and a comprehensive understanding of modern design aesthetics. Fluency in Spanish will make communication smoother but isn't stri...

...$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...

I've been experiencing some difficulties with my MS Access database. Error messages appear indicating missing or broken files namely, ‘’ version 7.0 and ‘’ version 1.0. Some occur as soon as I try to open the application. No recent changes have been made to my computer's operating system or the MS Access software. Ideal applicants for this task should be proficient in MS Access, troubleshooting, and database management. You'll need in-depth knowledge of system files and how they might impact the functionality of the application. A knack for solving complex technical problems is also important. In turn, you should be capable of providing a lasting solution to prevent the recurrence of these errors. Cheers!

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.

I am looking to get this done in two weeks. Please see the included specs and html wireframe layout before bidding. I need someone who is skilled in ASP.NET and experienced with mobile apps. I would rather have the app developed with cross-platform software but it will for now be used in iOS.

...partnership deals. Responsibilities: - Lead Generation: Your primary role will be to find potential clients and bring them into our sales funnel. This will involve researching and identifying new leads, as well as reaching out to them in a professional and engaging manner. - Customer Outreach: You will be responsible for establishing initial contact with potential clients. This includes responding to queries, providing necessary information, and nurturing the relationship to encourage further engagement. - Appointment Scheduling: You will need to coordinate and schedule both sales and consultation appointments. This involves efficient time management and the ability to communicate effectively with both clients and my team. Ideal Skills & Experience: - Proven track record i...

I'm seeking a proficient developer to create an innovative web-based chat application using Natural Language Processing (NLP) and AI. This app should be able to analyze uploaded CVs and automatically respond to predefined queries such as years of experience and areas of expertise. Key Requirements: - The application should implement NLTK and Tensorflow as primary AI and NLP technologies. - The solution should not be a copy; it requires originality and a functional outcome. - Importantly, it should feature user authentication and login functionality. Ideal Skills: - Proficiency in NLP and AI, with strong knowledge of NLTK and Tensorflow. - Strong experience in web-application development. - Capabilities in implementing secure login functionalities. - Proven ability to develop...

...and Setup: Assess suitable automation platforms to determine the best fit for my business needs. Configure the chosen system to manage all social media accounts and integrate fully with WhatsApp Business. Workflow Development: Create automated workflows to handle a variety of tasks, such as: Social media post scheduling across multiple platforms. Automatic responses, lead capture, and customer queries on WhatsApp Business. Cross-platform data synchronization for consistent messaging. Customization and Flexibility: Tailor the platform to my specific branding and communication style. Ensure the system is adaptable to future business growth. Target: Marketing & Customer Engagement Technology Replication: Build a custom solution that replicates the core functionality of Metric...

I am seeking a talented developer who specializes in BioTime database development. The database will primarily be used as an attendance system for my staff. Key Functionalities: - Data Entry and Retrieval: You will implement mechanisms to input and retrieve staff attendance records. Data to be Managed: - Staff Attendance Records: The system should capture and store staff's check-in times, check-out times, and leave entries. Ideal Skills and Experience: - Proficiency in working with BioTime databases. - Demonstrable experience in building data entry and retrieval functionalities. - Prior projects dealing with attendance systems or related fields will be a significant plus.

...email responses. 2. Replace contact button from the home page and menu with a simple white band with two dedicated options A) Schedule a call, B) WhatsApp us 3. Blogs based on Keywords and SEO 4. Update About Us section to something precise and much more interactive and interesting with better design. 5. A live chat option on the website for a smoother experience which helps the visitor with a few queries and helps the visitor to select the perfect plan for him/her. 6. Better Testimonial Page 7. Move the scroll bar from the right side to the top of website for immersive and wide viewing of the website 8. Increase the speed of the website with quicker but sleek loader. 9. Footer needs a design update as well. 10. Cache management, google analytics, meta tags, backlinks (inbound an...

...excessively time-consuming. We require a more efficient algorithm to enhance the speed and effectiveness of these exact match lookups. Project Objectives: Develop a Python script that can perform exact match lookups quickly and accurately. Ensure the integrity and accuracy of the lookups to maintain database cleanliness. Key Requirements: Efficiency: The algorithm must reduce the time complexity compared to the current linear search approach. Accuracy: As the script is intended for database cleaning, the precision of matching cannot be compromised. Ideal Candidate Profile: Proficient in Python, with a strong background in data processing and text analysis. Experience with efficient data search algorithms and possibly with text matching techniques. Ability to write clean...

The process is Visit Search for: Drainage companies Glazing repair Boiler repairs in London Open a google sheet and write the following in the sheet: Company name Website Officers name Establish the limited company name and visit Type in the company name and then go to officers and type the name of the officee on the spread sheet. Visit the website and go to the contact us page. Fill out the contact us page Name: Chris Number: Email Message: Hello (enter the name of the officer) I am the CEO of and I came across your business, we are an AI company for trades people and we are looking for a partner we can offer our Job booking AI tool to for free for a month, please can you send me your email and I will send over details for your review.

...structure: The terms and conditions should be logically structured and easy to navigate. - Originality: The documents should be custom-made for my business, not copied from existing templates. While I did not address specific policies or documents in the initial questions, the ideal candidate will be able to guide me in selecting and including the necessary clauses. Should the freelancer have any queries, I am more than willing to provide additional information. Ideal skills and experience for this project include: - Proven experience in creating terms and conditions. - Legal background or expertise. - Clear and professional communication to ensure effective collaboration. Please note that I am open to suggestions regarding the tone of the documents, though they should be app...

I'm looking for an expert in data scraping to effectively extract text data from online databases. Primarily, I am interested in customer details. This data will be pivotal to my operations. Key tasks include but are not limited to: - Extracting textual data from specified online databases - Focusing on customer details during extraction - Organizing the extracted data in an easily accessible format The ideal candidate is proficient in data scraping and has a deep understanding of online databases. Proficiency in using tools and scripts for scraping is necessary. Previous experience with customer data extraction will be a plus. A rigid approach to data privacy and ethical scraping standards is imperative. Accuracy, efficiency, and detail-orientation are crucial skills for this posi...

I'm seeking a skilled graphic designer to craft a brand logo for my publishing house utilizing a particular color and theme. Your creative expertise will help bring my branding vision to life. Key Project Elements: - Color Scheme: The primary color for the logo should be light blue and violet something like the picture. - Logo Style: The style of...creatively incorporate a book and a butterfly motif. Ideal Skills and Experience: - Proficient in Adobe Illustrator or similar software - Strong portfolio of previous logo designs - Experience in branding and corporate identity - Outstanding creativity and innovativeness Delighted to receive your bids, together with work samples showing your aptitude in logo design. Don't hesitate to ask if you have queries concerning the p...

I'm looking for an experienced backend developer to handle database management and API integration for my project. Key Responsibilities: - Implement and manage a MySQL database efficiently. - Develop and integrate APIs to ensure seamless communication between front-end and database. Ideal Skills: - Proficiency in MySQL is a must. - Strong experience in API integration. Experience with other databases and backend technologies like Python, Java, and Node.js would be a plus. The chosen freelancer will need to understand the project's requirements thoroughly and communicate effectively with the front-end team to ensure a well-functioning, reliable backend system.

...clients to browse and select products efficiently. - Shopping Cart: A shopping cart feature is essential to facilitate seamless transactions for our clients. It should allow for easy addition, removal, and payment processing. - Live Chat Support: The website should include a live chat support system to provide real-time assistance to our customers. This feature will be crucial for addressing any queries or concerns promptly and ensuring a positive user experience. Target Audience: - The primary target audience for the website is B2B clients. As such, the site should be designed with the specific needs and preferences of businesses in mind. Experience in B2B website development would be highly advantageous. Ideal Skills and Experience: - Proven track record in website developmen...

...previous loan website design experience, to develop WordPress website for our loan agency. Our main goal is to sell loan services like home loan and mortgage loans to potential customers. We require the following specific features on our website: - Online loan application: Users should be able to easily apply for loans directly on our website. - Live chat support: We need a live chat feature to provide immediate assistance and answer any queries that users may have. - Loan calculator: The website should include a loan calculator tool to help users estimate loan amounts and repayment terms. - Google speed insights speed should show 95+ - All Seo parameters to be followed. The ideal candidate for this job should have experience in WordPress development, web design, ...

I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.

I am searching for a seasoned eBay lister with a min of 5 years experience and a personal active eBay account, for a high-volume clothing listing project. Key Responsibilities: - List 51-100 clothing items per week on my eBay account. - Ensure accurate, appealing, and detailed descriptions of each item. - Ap...provided. Ideal Skills and Experience: - Proven experience in eBay listing, specifically in the clothing niche. - A comprehensive understanding of the eBay platform and its functions. - Strong attention to detail to ensure accurate item descriptions. - Good time management skills to handle a high volume of listings. - Excellent communication and customer service skills for handling post-launch queries. If you meet these requirements, I'd be keen to discuss this oppor...

Project Title: Radiologist Database Creation for Victoria, Australia Project Description: I am looking for a skilled and creative freelancer to compile a comprehensive list of all radiologists currently working in Victoria, Australia. The goal is to create a detailed database that includes their names, contact information, and relevant professional details. Requirements: Research and Data Collection: The freelancer should be proficient in online research and data scraping. Identify reputable sources, databases, and directories where radiologist information can be found. Collect accurate and up-to-date details for each radiologist. Data Fields: Full Name Clinic/Hospital Name Clinic Address Phone Number Email Address (if available) Specialization (e.g., diagnostic radiolog...

I'm currently facing severe slowdown issues with my WordPress website due to slow MySQL queries. I'm looking for a professional who could help me identify and resolve these performance bottlenecks. plz find attached details

I'm building a site in Oxygen with Advanced Custom Fields. I have created a custom post type with several different categories. I have then also created a custom archive template using a repeatable element. However, I can't get the archive template to display just the posts in the relevant categories. When I go to the front end categories, they either display nothing or all of them.

I'm looking for an experienced professional who understands the PayPal payment gateway system and has the skills to configure it within my WordPress website. I am using WP Travel Engine. In particular, I need assistance setting up post-payment confirmation emails. Key Tasks: - Integration of PayPal Payments Standard: The ideal candidate should be able to seamlessly integrate the PayPal Payments Standard service into my existing WordPress website. Note that it is already integrated but there is an error that was not there before. - Confirmation Email Setup: I need confirmation emails to be sent out after a successful payment has been made. Specifically, I'm looking to create and send out two types of emails: order confirmations (which was already implemented but aft...

...are several rounds of approval. File Formats and Specifications: - All necessary working files in formats such as PSD, PDF, EPS, SVG, etc., must be made accessible. The files must be high resolution suitable for production. Language Requirements: - All text elements can be in English Participation Conditions: - Make sure you fully understand the requirements before you submit. Contact for Queries: - For any questions, please contact me directly through the Freelancer.com platform. Additional Notes for the Competition: - Expect constructive feedback during the competition process. - We are looking forward to creative and innovative approaches that not only meet our requirements but exceed them. Good luck! Regards Adwaa...

I am looking for someone to help me create a comprehensive database of art galleries in Dallas, Texas. This will be used for market research purposes. Key Requirements: - The database should include the names, phone numbers, and email addresses of the art galleries. - For each entry, I also need the street address, city, state, and zip code to be included. Ideal Skills and Experience: - Prior experience in data collection and database creation would be highly valued. - Strong attention to detail is crucial to ensure accurate and complete information. - Familiarity with art-related databases would be a definite plus. The end goal is to have a well-organized, accurate and comprehensive database that can be used effectively for market research purposes.

I'm looking for an expert in MS SQL databases to help me with a specific task. I’m using an MSSQL database and need to create a Param scalar. This is to store specific customer information in a structured manner. The ideal freelancer should be experienced with: - SQL, specifically MSSQL - Parameter creation within databases - Experience working with customer information In your proposal, please provide an example of a similar task you've completed in the past.

Hello We are changing server and we are facing an issue to import in phpmyadmin some tables of an extension "amasty gdpr" There is lot of tables like this bottom one, those queries are giving error in phpmyadmin : Errcode: 150 "Foreign key constraint is incorrectly formed" They are talking about same problem and extention "amasty" here : We don't know how fix this It works very well on old server but we cannot migrate to new server because of this problem CREATE TABLE `amasty_gdpr_privacy_policy` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id', `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Date of creating', `policy_version` varchar(10) NOT NULL DEFAULT '' COMMENT 'P...

...presence of my small business. Key Responsibilities: - Develop and implement a social media strategy to meet my business goals, which primarily revolve around increasing conversions. - Create and publish engaging content across our active platforms - Facebook, Instagram, and Tik Tok. - Manage the day-to-day running of these social media channels, including interacting with followers, responding to queries, and monitoring the effectiveness of our posts. - Oversee the execution of paid campaigns on these platforms to broaden our reach and ultimately drive more conversions. Requirements: - You should have a proven track record of managing social media channels for small businesses. - Expertise in creating and curating engaging content that drives conversions. - Proficiency in run...

I'm seeking a skilled PHP developer with sound knowledge in Javascript to handle a unique assignment. It involves integrating a database and implementing specific user interaction elements including retrieving and showing images on the website. Skills and Expertise required: - PHP for back-end development - Javascript for front end development, focusing on user interaction - Proficiency in retrieving and showing images online - Experience in database integration Though no specific frameworks are required, familiarities with Laravel, jQuery, or React.js are a plus.

The task involves loading multiple large data files into a database. These files, approximately 15GB each and in various formats like CSV, .db, .sql, etc., add up to an estimated dataset size of 1-2 TB. Preference is given to keeping the data locally on the machine, thus ruling out cloud storage solutions. The task entails consolidating and organizing fragmented files into a suitable database, whether it's a relational database or non-relational database. Initially, attempting the task with MySQL or any SQL databases is preferred. However, exploration of whether a NoSQL solution is suitable for handling such big data is also required.

This project 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 w...level details will be copied to the asset table when the order is confirmed. Bring up a print screen Send pdf of the sale order if a customer email is available. Administration Need Log-in and user management and security protocols based on used profile. Sample data will be provided to help with the development and testing efforts. Open Questions as this stage: Saving pictures of the product. Database management tools (backup, compa...