Movie similar databasecông việc

2 tables and 1 index is corrupted. DDL & DML is slow. tried DMS_Repair but didn't work. We are facing ORA-1578 and ORA -1110 These are two oracle errors. We are unable to write to the tables. We need someone with expertise in recovering Oracle Database and not mysql or any other databases. No trial and error but the expert please. And we need someone quickly! DB Size : 1.5 TB Table size for the tables which are corrupted is , 1st one 350 GB and 2nd one is 12GB, One index corrupted is around 4GB 12:15 PM just to correct myself total databse size 2.5 TB

I am looking for a skilled developer to create a mobile game with a similar style to Flappy Bird or Robot Unicorn Attack. The game should be developed for both iOS and Android platforms. The desired level of difficulty for the game is moderate, with the difficulty increasing as time goes on. The game should have a total of 1-10 levels or stages. Ideal skills and experience for this job include: - Proficiency in game development for both iOS and Android platforms - Experience in creating games with a similar style to Flappy Bird or Robot Unicorn Attack - Ability to design and implement progressively increasing difficulty levels - Strong understanding of game mechanics and user experience - Ability to create engaging and visually appealing graphics and animations. - ...

I am looking for a freelancer to help with a project for my existing business. The main task is to extract information from a spreadsheet that contains 5000 rows of data. We would like the freelancer to provide us with formulas and templates that will allow us to reproduce this information every week. The output file should be in XLSX format. We do not require additional assistance in interpreting the extracted data; we only need the data extraction itself. Ideal skills and experience for this job include: - Advanced knowledge of Excel and experience with creating formulas and templates - Attention to detail to ensure accurate data extraction

...have a query that performs a calculation that pulls data from my api. I need that query put into a new table, for faster access. 1. So task is put query into db and have a schedule to be done daily More Detailed for 1) a. when query is ready to be put in table, use an optimized query to reduce the no. of calculations and data that needs to be pulled from the API b. Create the Table in the Database c. Map out the columns according to the data fields your query will be returning d. Create a Stored Procedures of the query that is going into your table e. Configure the Stored Procedure to run on a daily schedule programmatically f. Monitor the query's performance to ensure it's pulling the data as expected 2. Diagnosing and fixing the profit and loss calculations...

I need an experienced freelancer to help me consolidate and optimize several Google Sheets databases for personal use. This task will involve the analytical merging and organizing of data, ensuring its accuracy. Key tasks and responsibilities: - Analyze multiple Google Sheets databases - Use my specific criteria to merge and organize this data - Ensure accuracy at all times The ideal freelancer for this job will have: - Solid experience with Google Sheets - Strong data management skills - Excellent attention to detail - Experience meeting strict deadlines. It is essential that you know how to navigate Google Sheets and are comfortable working with databases. This project is integral to my personal organization and data management, so it is crucial that everything is accurate and ...

I am seeking an arabic speaking knowledgeable freelancer able to customize my exi... - The candidate will need to develop and integrate functions that allow retrieval of product details. 2. **Data Updating:** - The specialist should also engineer capabilities to update these product details in the database seamlessly. 3. **User Information Management:** - Lastly, the project will involve creating mechanisms to retrieve and update user personal identifiers such as name, contact email and number. 4. **Manage permissions of employees** - Create permissions for employees The ideal freelancer should possess experience and proficiency in database management, programming for retrieval and update of data, and understanding of privacy norms regarding handling user pers...

...ReactJs developer to create a web application with a unique feature of dynamically switching between multiple databases based on the URL. This project is based in Salem, Tamilnadu and selected candidates will be required to sign an NDA. Key requirements: - Database support for MySQL, - User authentication - CRUD operations - Responsive design Ideal candidate should have: - Proficiency in ReactJs and experience in creating dynamic URL-based applications - Expertise in MySQL, - Experience in building applications supporting multiple database systems - Adept in creating user-friendly and responsive designs Candidates who can contribute innovative ideas to enhance the functionality and user experience of the upcoming web application are more than welcome to bid. Mini...

I'm looking for a highly skilled VBA developer who can efficiently manage Access databases with advanced functionalities. The expert will be specifically focusing on: - Maintaining and managing our inventory database which includes advanced features like queries, forms, and reports. - The developer should be proficient in dealing with Access databases with several tables and relationships. The ideal freelancer should be experienced in VBA development, Access database management, handling sophisticated database relationships and advanced features like queries, forms, and reports. Exceptional knowledge and experience with inventory-related databases will be a significant plus.

I'm seeking a proficient .NET developer with expertise in handling back-end development and managing small databases up to 1GB. Your tasks will include: - Structuring, implementing, and manag...in handling back-end development and managing small databases up to 1GB. Your tasks will include: - Structuring, implementing, and managing the back-end of the .NET application. - Administering and maintaining our database, ensuring the integrity, performance, and security of the transactional data stored within it. The ideal freelancer for this project has a strong understanding of back-end processes, .NET framework, and has experience in dealing with transactional data. Essential skills include being detail-oriented, demonstrable problem-solving abilities, and efficient database...

I am looking for an Employee Database for our Ed-Tech Company. We are looking for a database in the US region for Teachers for English Programs. - I want a fresh database (B2C) for our e-learning courses program and services. - Need "Teacher's" personal data, especially for recruiting purposes and our online courses. - Teacher should have excellent knowledge of English subject. - I needed data with the below field, Data required field: 1. Personal Contact Number 2. Email IDs 3. First Name 4. Last Name 5. Job Titles 6. LinkedIn Profile Note: Data must be verified or cross-checked, and missing and wrong data will be replaced by a freelancer. - The Maximum number of Email IDs should be Yahoo, Hotmail, Gmail and Outlook client-based data. - Geo: USA -...

I am looking for an Employee Database for our Ed-Tech Company. We are looking for a database in the India region for Teachers for Math, English & Coding Programs. - I want a fresh database (B2C) for our e-learning courses program and services. - Need "Teacher's" personal data, especially for recruiting purposes and our online courses. - Teacher should have excellent knowledge of Math, Coding and English subjects. - I needed data with the below field, Data required field: 1. Personal Contact Number 2. Email IDs 3. First Name 4. Last Name 5. Job Titles 6. LinkedIn Profile Note: Data must be verified or cross-checked, and missing and wrong data will be replaced by a freelancer. - The Maximum number of Email IDs should be Yahoo, Hotmail, Gmail and...

I am seeking a skilled designer to create a Jasper invoice that is connected to Apex. This invoice design will be based on a specific sample I have, in PDF format. Critical elements to be included in the invoice are: - Invoice number - Date - Company information and other details for items Additionally, I require the inclusion of some branding details such as: - Company Logo - Color Scheme The ideal freelancer for this project should have experience with both Jasper and Apex, and a keen eye for design detail. Familiarity with converting PDFs into other formats and incorporating logos and color schemes into designs is a must.

I urgently need a proficient developer to begin working on moving an API query into a database table. This is a task that requires prioritization and immediate attention. I need someone that can work 100% on my project and deliver within 1 day, even if they get no sleep. You would be expected to work until task is completed. Once this is accomplished, the next steps will involve: 1. Diagnosing and fixing the profit and loss calculations for race, event, and range that are currently malfunctioning. 2. Resolving the limitation issue with filter odds, which is currently not performing as expected. The ideal freelancer for this job has substantial experience in: * Database architecture * API Integration * Debugging and problem-solving skills Please note, I need this wo...

I am seeking an experienced server developer with an emphasis in database server development. The primary technology required is MySQL and the key requirement is to deliver high performance and scalability. Requirements: - Expertise in database server development with a focus on MySQL - Experience in building scalable server solutions - Understand the concepts of high performance databases - Ideally, able to provide examples of previous work on similar projects This project requires both scalability and robustness in terms of performance. Therefore, the ideal candidate must be up to the task, being able to ensure the best possible performance is extracted from MySQL. If you believe you are the right person for this project, I look forward to receiving your bid.

I'm in need of an expert who is highly proficient in Excel database formatting and sorting. This project predominantly concerns sorting data into a customized format based on my own requirements. • Key Task: The key task here is to arrange the Excel database according to a specific data field. It requires careful attention to details and solid understanding of Excel's data sorting capabilities. • Unique Requirements: The desired Excel database format isn't a simple alphabetical order or based on a certain data column. It's more specific, the data has to be grouped together by a specific data field. • Ideal Skills: The perfect candidate would be an Excel specialist with a solid understanding and experience of complex data sorting...

I am wanting to start in PHP but I don't have the patience to configure all of the Backend/Web server stuff. I need: - CodeIgniter 4 Framework 4.3 on live site and domain. name pointed to it on my Hostinger VPS - I'll give you root access - Assign Domain name to this site and it should be live - even if it just goes to the CI4 welcome page - Database set up - I have a sql file for it so it shouldnt be any problem - Ideally have VIsual Studio COde (i have it on my Macbook) dset up so i can make changes on my local mac book - and then it would very easily be able to go live. If you ahve any better recommendations that would be basically i just want to be able to not worry about the back end stuff. - Create env/backup of the finished set up and thatis it. I like

I need an experienced freelancer to help me consolidate and optimize several Google Sheets databases for personal use. This task will involve the analytical merging and organizing of data, ensuring its accuracy. Key tasks and responsibilities: - Analyze multiple Google Sheets databases - Use my specific criteria to merge and organize this data - Ensure accuracy at all times The ideal freelancer for this job will have: - Solid experience with Google Sheets - Strong data management skills - Excellent attention to detail - Experience meeting strict deadlines. It is essential that you know how to navigate Google Sheets and are comfortable working with databases. This project is integral to my personal organization and data management, so it is crucial that everything is accurate and ...

I need to carry out an easy project. Attached information in pdf.

I am looking for a developer to create a searchable database for GPS images of public works issues. The database should have the following fields: location, issue description, and tailored fields to suit this project. Attached is a more detailed selection of detail, an older version we used to use which we are refining this from and one sample offender report. The database should be accessible on both web and mobile platforms. Additionally, I would like the database to have the ability to generate both standard and custom reports. Ideal skills and experience for this project include: - Database development - GPS photography integration - Web and mobile application development - Extensive search and report generation functionality

I’m looking for someone to make me a couple of these quick designs. I am putting them on a hoodie and need designs to send over

Wir haben eine Anwendung entwickeln lassen ...Interoperabilität nötig. Darüber hinaus suchen wir jemanden, der regelmäßige Überprüfungen der Anwendung durchführt und sie somit auf dem neuesten Stand hält. Wenn Sie über das nötige Wissen und Können verfügen, dann laden wir Sie ein, unser Projekt zu übernehmen und uns beim Unterhalt unserer Anwendung zu unterstützen. Adjustments once 1. Listening to music / Play Button, 2. Delete a movie / now cant delete a old Movie now the music can only be heard in the movi 3. change the letters in text editing mode, the letters to bold. 4. Zahlungs Link von Stripe integrieren If everything goes we'll go online. Gerne stelle ich ihnen die Anwendung vor die...

I'm seeking a skilled 3D animator to bring my fantasy-themed script to life in an engaging and vibrant YouTube movie. Key responsibilities will include: - Developing high-quality 3D animation consistent with the script - Creating realistic recreations of a fantasy world - Ensuring that the pacing and flow of the animation aligns with the script's intentions Ideal Skills: - Proven experience in 3D animation - Strong understanding of animation techniques and storytelling - Experience creating fantasy-themed animations - Proficiency in 3D animation software I am providing a script, which means I'm looking for freelancers who can work closely and precisely with the given storyline. I need someone who can effectively translate my vision to an immersive animation...

Make steel draws very simple for 3d pieces. As easy as this, low price but many pieces per month.

...that involves saving real-time stock market data from an API into a MySQL database. The ideal candidate should have experience working with real-time data and integrating APIs with SQL databases. Requirements: - Expertise in working with stock market data and APIs - Proficiency in MySQL database management system - Strong understanding of real-time data updates and handling - Ability to design and implement an efficient database schema for storing the API data - Experience in optimizing database performance for handling real-time updates Skills and Experience: - Strong knowledge of stock market data and APIs - Proficiency in MySQL database management system - Experience with real-time data updates and handling - Database design and optimizatio...

I am looking for a developer to create a page where members can add and manage information about performers/artists, concert dates, and locations. The page should be divided into three categories: concerts, stand-up, and cinema. Fun...Functionalities: - Members should be able to add, edit, delete, and search for information on the page. - There should be a link to upload and edit content. Sorting: - The page should be sorted by the performer/artist name. Ideal skills and experience: - Experience in web development and database management. - Proficiency in HTML, CSS, and JavaScript. - Knowledge of server-side programming languages such as PHP or Python. - Familiarity with database systems such as MySQL or MongoDB. Please provide examples of similar projects you hav...

I'm looking for a PHP database programmer. I have already Created PHP basic Contact form and receiving customer inquiry but just need to ad to the Database and admin view so I can login and view the of the inquire posted by customers. Bear in mind the information for bidders isn't provided so be ready to explain eloquently why you are the best fit for this project.

I'm looking for a PHP database programmer. I have already Created PHP basic Contact form and receiving customer inquiry but just need to ad to the Database and admin view so I can login and view the of the inquire posted by customers. Bear in mind the information for bidders isn't provided so be ready to explain eloquently why you are the best fit for this project.

...create a user login application that connects directly to my MySQL database. The app's primary purpose will be to collect specific details from multiple users - specifically, email (required), phone number, and name (required), which will then be securely stored into a MySQL database of my server. The ideal candidate for this project should possess: - Extensive experience in mobile app development - Proficiency with MySQL databases and their integration in apps - A firm understanding of data protection and privacy concerns - Proficiency with creating user login flows and managing user credentials This project is crucial and requires a detail-oriented developer with a strong grasp on user login mechanisms and database connectivity. Your responsibilities...

... The “client” is the front-end desktop application. Have a remote database that multiple desktop clients can access remotely and: - See the documents and related information on the database (from the client) - Delete documents of the database (from the client) - Add local documents to the database (from the client) The database/client should be able to do the above for the following file types: - .xlsx - .xls - .doc - .docx - .pdf - .ppt - .pptx Multiple clients (up to 5 at a time) should be able to add files and remove them from the database asynchronously. Example: 3 people are trying to add a file to the database at around the same time, the database should be fine with handling that asynchronously. The da...

...of a web browser content using shortcuts, 'Print screen' key and 'Shift + Win + S' - Prevent from capturing browser content using Windows screen capture programs like Windows snipping tool. - A proven track record with similar projects - The browser can be Chrome, Edge or other browsers - Support for Windows 10 and Windows 11 - The desktop application should be working as both foreground and background - If you are going to use a way to limit Windows clipboard, Windows text clipboard should work and you can only limit image clipboard. - If you try to capture a Netflix movie on browsers, it won't work, even if you try any other screen capturing tool. This is exactly what I want The goal is to restrict taking screenshots of the web browser content. ...

...WordPress database optimization to improve performance. Specifically, the queries are taking a long time to load which negatively impacts the user experience. Key project goals: - Speed up query load times on homepage and blog pages. - Implement a caching or performance optimization plugin. - Ensure the website can efficiently handle a peak traffic volume of 100-500 users. The ideal candidate will possess: - Proficiency in WordPress - A strong understanding of databases, more specifically, MySQL - Experience with performance optimization plugins - Strong problem-solving skills - Capacity to work under pressure and handle high volumes of traffic Your task will include diagnosing the current issue, proposing a solution, and implementing that solution to carry out the necessary...

...am looking for a developer with experience in Django to work on my visualization app. The app uses a Postgres Database and represents data in dashboards, tables, and charts. Skills and experience needed: - Strong knowledge of Django framework - Proficiency in working with Postgres Database - Experience in developing dashboards using Django and visualization libraries - Ability to create interactive and user-friendly dashboards - Familiarity with data analysis and visualization techniques The project requires the following: - Developing dashboards to visualize data from the Postgres Database - Implementing specific metrics as requested by the client - Accessing data from the database using API and direct Queries If you have the necessary skills and experi...

Backend Work - I would like add a hotel component from a backend db. UI Work - Master Page Redesign CSS and JS Compatiblity in exisiting project Search-package Create-Itinerary Details View-Itinerary Send Quote Save Quote Print Quote Edit Code Confirming Booking Generate Invoice Generate Voucher Service Delivery Calendar Other supportive actions

I am looking for a talented 3D sculptor, specialized in action figures, to bring my ideas to life. The type of action figures is not bounded; they could be superheroes, animals, movie characters, or even more. KEY REQUIREMENTS: - Past work: In your application, it is crucial to include examples of your past work. This will help me gauge your experience and style. - Detail: Your role would be to create sculpt models that capture high detail and realism. I'm not just looking for basic shape and features, but intricate textures and a lifelike representation. SKILLS & EXPERIENCE: Ideal candidates will have significant experience working with 3D sculpting, preferably in action figures. In your application, demonstrate your ability to work with intricate details and realism. De...

I am seeking an experienced animator with the right skills to create a vibrant, engaging 2D traditional animation movie. This project's aim is to create a fantasy-oriented animated feature specifically for an adult audience. Key requirements: • Proficiency in 2D traditional animation techniques • Experience with adult-targeted content creation • Ability to infuse elements of fantasy within animation If you have a strong background in creating 2D traditional animations, especially in the fantasy genre and for adult audiences, I encourage you to place a bid. Deep understanding of adult fantasy narratives and passion for storytelling through animation will be highly regarded in this project.

I am looking for a freelancer who can help me with extracting table data from a specific website and storing it in a MySQL database. Website Extraction: - The freelancer should be able to extract both text and numeric data fields from the website. - The website URL will be manually provided by me. Data Storage: - I am looking for a specific structure or format for storing the data in the MySQL database. - The freelancer should have expertise in determining the best structure or format for the data storage. Skills and Experience: - Proficiency in web scraping and data extraction. - Experience with MySQL and database management. - Ability to determine and implement an appropriate structure or format for the stored data. If you have the required skills and experience...

...create a user login application that connects directly to my MySQL database. The app's primary purpose will be to collect specific details from multiple users - specifically, email (required), phone number, and name (required), which will then be securely stored into a MySQL database of my server. The ideal candidate for this project should possess: - Extensive experience in mobile app development - Proficiency with MySQL databases and their integration in apps - A firm understanding of data protection and privacy concerns - Proficiency with creating user login flows and managing user credentials This project is crucial and requires a detail-oriented developer with a strong grasp on user login mechanisms and database connectivity. Your responsibilities...

I am looking for a skilled developer with strong experience...The project involves integrating the Paytm payment Gateway into my existing website and capturing specific transaction details. The developer will be responsible for: - Implementing Paytm payment gateway into my website. - Ensuring the database captures the following details from each successful transaction: Transaction ID, Amount Paid, and Customer Details. This data will be then used to operate my machine. The successful applicant will need to have a solid background in Paytm gateway integrations and PHP. They should possess the ability to manage database records effectively. Understanding the privacy and security implications of handling customer data is also critical. Please, only contact if you are interest...

Project Title: Update my database on a program Description: I am looking for a skilled database expert to update my MySQL database on a program. Skills and Experience: - Strong experience with MySQL database management - Proficiency in data collection and entry - Ability to work efficiently within a tight deadline Project Requirements: 1. Data Collection: The client requires assistance with data collection for the database update. 2. Database Update: The selected freelancer will be responsible for updating the MySQL database on the program. 3. Timely Completion: The project must be completed within 1 week. If you have the necessary skills and experience, and can meet the given time frame, please submit your proposal.

As the creative behind this project, I'm in search of a proficient graphic designer to craft a compelling movie poster for a thriller movie. The tone, mood, and feel of the design should align powerfully with the genre to entice potential viewers. Key requirements include: - A visual representation of the movie's thriller theme - Implement creative freedom while respecting the genre's traits - Deliver a polished, professional, and engaging final product While primary details of the movie have been kept under wraps, a freelancer with a keen understanding of the thriller genre, its nuances, and its aesthetics is vital. Prior experience in designing movie posters is a plus but not a necessity. Please include: - Samples of past work, preferably ...

...Authentication: • Allow users to register and authenticate accounts. • Implement secure methods for email/mobile verification. • Provide options for social media login. 3. Restaurant Bookings: • Integrate a reservation system for restaurant bookings. • Include options for selecting dining preferences, date, and time. 4. Movies, Entertainment, and Events: • Provide a platform to browse and book movie tickets and event tickets. • Include event details, showtimes, and venue information. 5. Order Groceries and Medicines: • Develop a system for users to order groceries and medicines online. • Include categorization, search, and delivery tracking. 6. Booking Train, Bus, Cab, and Flights: • Integrate a travel booking system for trains, b...

Project Title: SEO for movie website Description: I am looking for an experienced SEO specialist to help increase website traffic for my movie website. The primary goal of this project is to increase website traffic and improve search engine rankings. Specific Areas for SEO Focus: - The main focus will be on optimizing the home page of the website. Target Keywords: - The client has specific target keywords in mind. Ideal Skills and Experience: - Proven experience in SEO and improving search engine rankings - Knowledge of on-page and off-page optimization techniques - Familiarity with movie websites and the film industry - Ability to conduct keyword research and optimize content accordingly - Understanding of website analytics and ability to track and measure res...

Download from: https://livingatlas.arcgis.com/landcoverexplorer/#mapCenter=-48.79%2C-22.488%2C15&mode=step&timeExtent=2017%2C2022&year=2022&downloadMode=true The files have the extension geoTiff. We need specially the Brazilian database area (for all years) in a KML format for each year.

Here's what's expected: - Reliable face swapping: The model must be designed to provide high-quality results consistently. the model should give results similar to inswapper from insightface. I can provide the computing resources to train the model, or any workforce necessary like providing the data or tagging the images. All that is required is the programming, setup and giving the correct directions. Once the model gives satisfying result close enough to what we can get from Insightface, the job will be considered done

Querido Freelancer, Estoy buscando a alguien con habilidades en automatización de capacitaciones y formación de facilitadores para un emocionante proyecto. Necesito desarrollar un sistema eficiente para automatizar las clases y sus asignaciones a través de una plataforma en línea, como Google Class Room. El objetivo principal es crear un ambiente virtual de aprendizaje que permita a los facilitadores impartir clases de forma interactiva y atractiva, al tiempo que brinda a los participantes las herramientas necesarias para completar las asignaciones de manera efectiva. Como Freelancer, te pido que consideres tu experiencia en el diseño e implementación de soluciones de automatización en plataformas como Google Class Room. Es fundamental qu...

I am looking for a skilled database developer to create a customer database using either Mysql or Oracle. I am open to either option. It needs to be run as a webapp that I can run both locally and later over the internet as a webapp with ability to add multiple users with 4 different roles. Database Design: - I have a specific design in mind for the database and would require the developer to follow this design. Please see the PNG layout enclosed. Volume of Data: - The expected volume of data to be stored in the database is more than 5GB. Required Skills and Experience: - Proficiency in Mysql or Oracle database management systems. - Experience in database design and implementation. - Ability to work with large volumes of data. - Strong at...

I need a legal expert who has experience with handling issues related to databases. Specifically, I require assistance regarding a severe fine that needs to be removed from the Vicroads database. Skills and Experience: - Proven experience in Legal Advice. - Experience in database-related legal issues is a plus. - Excellent communication skills. The successful freelancer must include their relevant experience in their application. Your bid will be more favorably considered if you've handled similar cases before. Please note that a detailed step by step plan is not required for this project, but proven experience is critical.

We are looking for an experienced web developer to create an e-commerce website for our business. Our basic requirements for the website: Database Design: Design a database schema to manage product inventory, user information, and sales data. Include necessary tables for users, products, and any other relevant entities. User Authentication and Accounts: Implement user registration and login functionality. Users who pay should have accounts, and only registered users should be able to add, remove, and update their information. User Profile Pages: Create a dynamic page template that displays user-specific information from the database. Allow users to upload and manage personal files (pictures, strings, etc.) associated with their profiles. Page for Information and ...

I'm in need of a proficient software developer to create a unique application that performs data migration from another app. The primary function of this software would involve: - Migrating content data, specifically, text posts in a convenient and efficient manner. The ideal candidate for this project would possess the following skills and experience: - Strong knowledge and experience in software development. - Experience in data migration particularly content data. - A keen understanding of data structures and databases. - Knowledge in coding language optimal for this kind of task. This project poses a unique opportunity for you to exercise your data migration and software development skills in real-time, and on a practical scale. If efficient, reliable, and clean codes are your...

I am i...in need of a freelancer who can help me recover a Microsoft SQL Server database that has been affected by ransomware. Skills and Experience: - Extensive knowledge and experience in recovering SQL databases from ransomware attacks - Proficiency in Microsoft SQL Server - Familiarity with ransomware removal and recovery techniques - Strong understanding of database backup and recovery processes - Ability to assess and understand the extent of the ransomware damage to the whole system - Excellent problem-solving and troubleshooting skills - Attention to detail and ability to work under pressure Please note that the whole system has been compromised, so it is crucial to have the expertise to not only recover the database but also ensure the overall security and ...