Mysql limit order by desc jobs
...custom button rather than the native link of the accordion. If I post an offer for a hotel, that offer should only be visible for that specific hotel. However, at the moment, it is shown in all hotels, even though I select the hotel to associate these offers with from a select box in the control panel during the posting phase. This involves creating custom queries for WordPress. I usually use PHP/MySQL, but for this new version of the site, I am using WordPress. The total budget is 15 USD it's not a demanding job for an expert. I am attaching images to clarify what I am talking about. You can see button "dettagli offerta" and i want to use this for open and close the accordion where there are offers details This offer are for 1 hotel, but the same offers now sho...
you will need to be Expert in PHP understanding existing PHP Code along with knowledge of MySql and JS to handle a small game that will post results to a table in the data base then show on a leaderboard style page. $40 Job
...6 shop, we are facing a problem with the importing process of pictures submitted via XML; the image files are also hosted on the same server. The current script only imports a few images at random, and most of the images are not imported at all, without generating any errors. The import script runs until the end but skips most of the pictures. Skill requirements: good knowledge of Shopware 6, mySQL, PHP, Smyfony !!! it's an urgent project so pls. don't bid if you haven't got enough time (max. 2 days). If you have questions pls. don't hesitate to ask, i'll provide all the infos u need. !!! IMPORTANT !!! Please don't give a quote if you don't have enough capacity, the project should begin immediately. Please don't give a quote if you'...
I have purchased a VPS from hostinger. Now, It supports Linux. I am looking for a proficient Linux expert who can assist me with installing software packages on my VPS. I want to install PhpMyAdmin, MySQL, Laravel, Email Server, DB Performance Tools and Server Performance Tools, React, others. Key requirements: - Proficient in Linux system administration - Experienced in VPS management - Capable of installing software packages effectively Project will be considered as complete only once it is working fine. You need to perform it on our machine as we will share our screen with you as we need to document all steps. Kindly mention your bid and time required while biding. Also, mention which Linux Version is preferable as per your expereince.
...have experience in ebay and shopify listings. It is essential that you are able to work Australian time 9 to 5pm. AUD$2/hr Responsibilities: - Customer Support: You'll need to efficiently handle customer inquiries and resolve issues in a timely manner. - Product Research: You should be able to conduct thorough product research, helping me to identify the best products to list on my platforms. - Order Fulfillment: You'll be responsible for ensuring that orders are processed promptly and accurately. - Product Listing: You'll need to have a good eye for detail and be able to create appealing product listings on both ebay and shopify. The virtual assistant will be required to work 40 hours a week. Experience with listings on both eBay and Shopify is highly desired. ...
I'm in need of a proficient Android app developer who has a strong understanding of Google Sheets API and real-time data integration. App should be able to display rates, track order status, display quote of products and other basic tabs like upload of pdf documents of catalogues, contact us, about us and social media links etc. I have attached a basic pdf document of what the app should look like. Will need UI improvements in it too. Key Responsibilities: - Develop an Android application that dynamically displays data from certain cells in Google Sheets. - The app should be designed to pull updates in real time, refreshing every minute. - It should provide a manual refresh data option for immediate update. Ideal Skills: - Extensive Android app development - Knowledge a...
whell... i have a laravel dashboard, PHP 7.4 laravel 7, MYSQL, repocitory on github (private)... i need continue working on it, but my normal freelancer is bussy right now... so open vacant... Please let me know u questiongs. Br. Im prefer spanish lang for choise my freelancer, but all are whelcome...
We are seeking a skilled developer to create a comprehensive time management website aimed at assisting users in optimizing their productivity and organizing their schedules effectively. The website will feature a user-friendly interface, leveraging HTML and CSS for frontend design, and backend functionality will be implemented using robust technologies to ensure seamless performance a...seeking a skilled developer to create a comprehensive time management website aimed at assisting users in optimizing their productivity and organizing their schedules effectively. The website will feature a user-friendly interface, leveraging HTML and CSS for frontend design, and backend functionality will be implemented using robust technologies to ensure seamless performance and scalability. MYSQL...
I need 4 buy limit button with tick offset 4 Sell limit button with tick offset First button 1 tick offset second button 2 tick offset and so on. I want those buttons in trade panel.
I have a script written in AHK for Windows. I would like this script to be rewritten for MacOS using Python. In order to ensure that the MacOS script is as close as possible to the original Windows script, the sound functionalities need to be replicated exactly. doesnt have to be python if u know something easier and simpler to maintain i dont care Key Skills Needed: - Proficiency in Python - Experience with MacOS scripting - Understanding of AHK (previous experience with this language would be beneficial) - Proficient in sound control within scripting The ideal candidate for this role would be someone who has a good understanding of AHK and Python, and is able to adapt the sound functionality of the AHK script to MacOS, while keeping the original features and functions of the s...
We are seeking a skilled freelancer to customize our school SaaS ERP control panel by integrating WhatsApp and inbox SMS APIs. The goal is to create a dynamic frontend and backend system that allows seamless communication between the school, students, and parents. The ideal candidate will have expertise in Laravel, MySQL, and Firebase technologies. Responsibilities: Customize the school SaaS ERP control panel to integrate WhatsApp and inbox SMS APIs. Develop a dynamic frontend interface for easy navigation and user interaction. Implement backend functionalities to manage message sending, delivery, and history tracking. Ensure smooth integration with existing databases and systems. Create a secure authentication system for users accessing the platform. Test the system thorou...
...Translation: Develop a mechanism to interpret buy and sell signals generated by the algorithm and translate them into executable orders on the trading platform. 3) Order Placement: Implement functionality to automatically place orders based on predefined criteria, including quantity, price, and order type. 4) Testing and Optimization: Conduct thorough testing to validate the functionality of the automated trading system and fine-tune parameters for optimal performance. Requirements: 1) Proficiency in algorithmic trading and API integration. 2) Experience working with trading platforms and their APIs. 3) Strong programming skills, particularly in languages such as Python, JavaScript, or similar. 4) Familiarity with order execution protocols and trading strat...
We are seeking a skilled freelancer to customize our school SaaS ERP control panel by integrating WhatsApp and inbox SMS APIs. The goal is to create a dynamic frontend and backend system that allows seamless communication between the school, students, and parents. The ideal candidate will have expertise in Laravel, MySQL, and Firebase technologies. Responsibilities: Customize the school SaaS ERP control panel to integrate WhatsApp and inbox SMS APIs. Develop a dynamic frontend interface for easy navigation and user interaction. Implement backend functionalities to manage message sending, delivery, and history tracking. Ensure smooth integration with existing databases and systems. Create a secure authentication system for users accessing the platform. Test the system thorou...
make reviews on website not go live automatically but ONLY after admin approval. to AVOID SPAM and false reviews (also create email alert for notice of "new review pending" status when created - to go to signsdelivered@gmail .com)
...functionality to preview and download existing quotes via the web and mobile applications. Additionally, assisting the client in installing the latest version on their local host to facilitate their participation in the testing process. Project 2: Software Enhancement and Bug Resolution Our second project is a comprehensive web-based software developed using HTML, Bootstrap, PHP, Laravel, and MySQL. We are not aiming to completely redesign the system but to improve upon the initial version, which encountered several bugs post-launch. We have initiated the development of a new version, currently 40% complete, that restructures and refines the existing tables and functionalities. Unfortunately, our lead developer is currently unable to continue due to health issues. We are seeking...
Looking for php/mysql developer to integrate discount coupon backend into admin panel. Straight forward. The admin panel is already working with a mobile app. We need to add that functionalitiy so we can later integrate it on mobile app
...improvements for readability, maintainability, security, performance and other aspects of code quality Executes work efficiently and meets agreed on deadlines Completes most development activities independently Requirements Core Requirements: Strong background in data warehousing concepts, ETL development, data modeling, metadata management and data quality Strong knowledge of SQL running on SQL Server, MySQL, and Snowflake including but not limited to: extensive experience working with complex stored procedures, table definitions, and a proven track-record of performance optimizations and troubleshooting of SQL logic. Proficient at C# running on .NET Core and/or other similar .NET frameworks including but not limited to: writing Unit Tests and implementing algorithms and data ...
...Day Programs and Transportation members for over 10 years. The business owners are Deaf and have over 300 hearing employees and 30% of our current employees are Deaf, including Deaf management staff. We have high rich experience skilled in our field. We are now looking to brand our services at Phoenix Day School for the Deaf, Arizona State school for the Deaf, and Sequoia School for the Deaf, in order for us to be able to post our services or working closely with them, we have to get their school broad approval therefore, I'm seeking a skilled marketer for an inclusive email campaign. This project will aim to both deaf and hearing individuals. The essence of this campaign is to promote services for the deaf with development disabilities. Key Attributes: - Expertise in E...
...optimization (SEO), and lead generation campaigns. Key requirements: - Social Media Advertising: I need someone who is well-versed in creating and running successful social media advertising campaigns. The candidate should have a proven track record of generating leads through platforms like Facebook, Instagram, and Twitter. - Search Engine Optimization (SEO): A good understanding of SEO is crucial in order to ensure that my business ranks well in search engine results. The candidate should be able to use the most effective SEO techniques to drive organic traffic to my website. - Lead Generation Campaigns: The successful candidate should be experienced in creating and managing lead generation campaigns. They should be able to use a variety of tools and techniques to generate ...
...coordinate assignments by selecting, editing and positioning photos in print and web publications. The successful candidate will be able to collaborate with editors and photographers to decide on which photos will be published and ensure deadlines are met. Ultimately, you should be able to create photo content to compliment text in a creative way. Responsibilities Coordinate with the editor and the team members to identify photography needs Assign projects to photographers and keep track of the deadlines Review photos, edit and make necessary changes Decide which images to publish Ensure all assignments are shot and edited on time for publication Manipulate photos to achieve highest quality using the appropriate tools Ensure all photo equipment is used properly and order...
I require a proficient Ansys Fluent user to conduct a study on the aerodynamic characteristics of the DrivAer model with the estate-back form: - Mesh independence study of baseline model, using Spaceclaim to prepare geometry and defeature it before meshing. Study must use symmetry to conduct the simulations over half of the body of the car in order to save time and computational costs. - Design of Experiment for a Roof Spoiler: Using three geometric parameters for the shape and position of the spoiler, which will each be tested at three different values (for a total of nine simulations), with the effects of adding the spoiler compared to the baseline model. - Design of Experiment for a Rear Diffuser: Similar to the above, but this time for the purpose of determining the design of a...
Looking for someone to create an asset that would allow for quick planet creation with ease, similar to Orbis () but will allow custom terrains, GameObjects to be placed and able to customise the world, environment, atmosphere and allow multiple placements of planets. Must also be able to be seamless similar to No Man Sky.
As the client, I would like to create a personal video collage, centered around the theme of Growth and relationships, presenting a sequence of images that follow a thematic, rather than chronological, order. The video will be accompanied by the rich tunes of Denver-jack harlow. The finished result should resemble a music video, created for personal enjoyment and reflection. I would like the video to be in a 90's VHS Style. Skills and Experience Required: Applicants should have solid experience in the following areas: - Video editing - Music synchronization - Thematic sequencing A solid portfolio showcasing previous video montage work, particularly within the realm of personal videos or music videos, is desirable. This project requires a keen eye for storytelling th...
I'm in need of a skilled graphics designer to create a modern logo for my business. The logo should be modern in style, showcasing a d...be modern in style, showcasing a degree of professionalism and sophistication. The design needs to incorporate a specific symbol that holds significance to me and my brand. Here's what I'm looking for: - Experience in modern graphic design, particularly with logos. - Ability to work in design elements specified by the client, in this case a unique symbol. - Great understanding of color theory, as I want a harmonious and visually appealing logo. - Good communication skills, in order to understand my requirements and give life to my vision. If you meet these requirements and feel that you can bring my vision to life, I'...
I'm in need of a skilled professional to 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
I'm looking for a talented, experienced React JS and Laravel developer to join my t...need to be proficient in React JS, with the ability to create attractive, responsive user interfaces. - Back-end development: Strong Laravel skills are essential. You'll be responsible for building and maintaining the core functionality of our platform. - Bug fixing: You should have a keen eye for detail and be able to identify and resolve bugs in both the front-end and back-end. - Experience with mySQL is a must. In your application, please include your relevant experience in React JS and Laravel. I'm looking for someone with a proven track record in both technologies. Communication is key, so we'll be using instant messaging as our primary form of contact. I look forward ...
I'm seeking a talented graphic designer to create a vector image of a perfume bottle. The design needs to be vintage-themed, capturing the essence of the original image.. The final design must also incorporate the brand name. The ideal freelancer will have: - Proficiency in vector image creation - Expertise in design Attention to detail is crucial for this project, in order to maintain the accuracy and beauty of the original design while adding the necessary branding elements. This graphic will be used on product packaging, so quality and impact are vital. The file is required in an AI file and layered PSD file. I need two versions, one like a line drawing version and the other a more of a block version with some details. I have attached examples.
I'm seeking a talented graphic designer to create a vector image of a perfume bottle. The design needs to be vintage-themed, capturing the essence of the original image.. The final design must also incorporate the brand name. The ideal freelancer will have: - Proficiency in vector image creation - Expertise in design Attention to detail is crucial for this project, in order to maintain the accuracy and beauty of the original design while adding the necessary branding elements. This graphic will be used on product packaging, so quality and impact are vital. The file is required in an AI file and layered PSD file.
...a designer with a professional, minimalist approach to develop a "Sold By Four Leaves" image using elements from my logo that I've supplied. My commercial property business is called Four Leaves, and I want an image I can put on properties I've sold which says "Sold by Four Leaves". You could include some imagery, or it could be a simple word image which says "Sold by Four Leaves". Key elements: - Color scheme: Mainly featuring light green (4fb420), dark green (006440), and white. - Design Style: Should radiate professionalism, akin to a modern and minimalist sensibility. - Imagery: I invite creative suggestions and ideas. While I didn't specify particular elements to be included, ensure it communicates the 'Sold...
“Storecheckers are a Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits. This visit is to an Examination Centre, checking that the security standards are being met, in order to ensure that there is no possibility of cheating at any stage. The exam content and result are irrelevant to this exercise. You will need to be observant and discreet in order to undertake this visit. You need to remain in the test centre and complete the exam as if you were a genuine entrant. We have full guidance notes to assist you, which give a very clear background of the environment. The actions that you need to take are actions that test takers attempt, so do not be worried about carrying them out. After the visit there is a report to complete, i...
...with my shop. Key Responsibilities: - Product Optimization: Focusing on Seo and how to get the product sold as well as the correct pricing. - Inventory Management: Managing stock levels, ensuring timely restocking, and helping to forecast demand. - SEO & Digital Marketing: You should have a strong understanding of SEO and digital marketing strategies, particularly as they relate to Etsy, in order to drive sales. Ideal Candidate: - Proven experience in managing Etsy shops and generating sales. - Strong understanding of SEO and digital marketing strategies, particularly in the context of e-commerce platforms. - Experience with product listing, and a track record of optimization that has led to improved sales. - Excellent organization and communication skills. - Ability to a...
...a versatile Project Template with Task Management features. In addition, I need a Work Order Template made that can integrate with D-tools for easy part number and work detail import. Key Requirements: - A Project Template with robust Task Management capabilities. - A Work Order Template that allows for moderate customization. - Direct integration with D-tools to import part numbers and work details. It's crucial that both templates are user-friendly and straightforward to understand and use. The Work Order Template especially must be set up to work seamlessly with D-tools, ensuring a smooth import process for the necessary data. Ideal Skills: - Experience in creating project management and work order templates. - Proficiency in tools like D-tools. ...
...products, process orders, and handle cancellations efficiently. Admin Backend: Construct a robust admin panel to oversee order processing, site settings, and overall platform management. System Overview: Showcase popular services through a slider on the front end, adjustable by the admin. Customize service display based on date, name, or cost, with admin control. Implement a commission structure for admin's revenue, configurable via the admin panel. Key Features: User Authentication and Registration Product/Service Listings with Descriptions and Pricing Search and Filter Options Shopping Cart and Secure Checkout Process Comprehensive Order Management User Reviews and Ratings Personalized User and Supplier Profi...
The SEO status of my website currently stands at fair. My main goal is to elevate the rank of specific keywords in order to increase visibility. Key Requirements: - Proven expertise in SEO with exceptional knowledge in boosting keyword rankings. - Ability to devise and implement strategies that will help rank for our chosen keywords. - Comprehensive understanding and experience in on-page and off-page SEO. Ideal Candidate: - You have a proven track record with portfolio in Designing SEO strategies. - You understand how keywords ranking works and have had success enhancing rankings in the past. - You have an in-depth understanding of search engines' algorithms and can adapt strategies accordingly.
...job: - Proven experience in creating professional, engaging, and high-quality 2D animations. - A good understanding of corporate environments and the ability to translate this into an engaging and informative animated video. - Prior experience in creating induction videos for new employees would be a significant advantage. - Excellent communication skills and the ability to work collaboratively in order to understand and represent the key benefits of our company....
We need few customizations done for Perfex CRM and Custom Module Development for Perfex CRM. If you have experience in creating custom modules or customizing core of Perfex CRM, then you'll easily understand requirements. I have a detailed list of features I need developed, I'll share that document with those who are shortlisted for this project. You must mention "Dell" in the proposal in order to be noticed. Here is a brief for List of Features. 1. Invoice Currency Conversion using API and storing conversion rate in the database with date 2. Storing invoice value in base currency that is calculated based on conversion rate in the database so the total revenue is correct. 3. Invoice Custom Field Behavior changing, width of dropdown, custom field value and ...
I am seeking an expert graphics designer to create pencilized art which will be used as illustrations. The style I am after is cartoonish, providing a fun, engaging perspective to my images. Key tasks & requirements include: - Translating existing images into pencilized, cartoon-styled art - Delivering visually engaging illustrations in a fun, creative...transforming existing images into engaging, illustrated art - Great attention to detail and adherence to project specifications - Fastidious time management and ability to meet deadlines. I HAVE ATTACHED A REFERENCE PLEASE CONSIDER! I need for both pictures. I am eager to work with someone who can breathe new life and excitement into my images with their artistic touch. Your creativity is your limit! LISTING FOR @draco01ar...
“Storecheckers are a Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits. This visit is to an Examination Centre, checking that the security standards are being met, in order to ensure that there is no possibility of cheating at any stage. The exam content and result are irrelevant to this exercise. You will need to be observant and discreet in order to undertake this visit. You need to remain in the test centre and complete the exam as if you were a genuine entrant. We have full guidance notes to assist you, which give a very clear background of the environment. The actions that you need to take are actions that test takers attempt, so do not be worried about carrying them out. After the visit there is a report to complete, i...
“Storecheckers are a Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits. This visit is to an Examination Centre, checking that the security standards are being met, in order to ensure that there is no possibility of cheating at any stage. The exam content and result are irrelevant to this exercise. You will need to be observant and discreet in order to undertake this visit. You need to remain in the test centre and complete the exam as if you were a genuine entrant. We have full guidance notes to assist you, which give a very clear background of the environment. The actions that you need to take are actions that test takers attempt, so do not be worried about carrying them out. After the visit there is a report to complete, i...
Original project: I am seeking an expert graphics designer to create pencilized art which will be used as illustrations. The style I am after is cartoonish, providing a fun, engaging perspective to my images. Key tasks & requirements include: - Translating existing images into pencilized, cartoon-styled art - Delivering visually engaging illustrations in a fun, creative style I...transforming existing images into engaging, illustrated art - Great attention to detail and adherence to project specifications - Fastidious time management and ability to meet deadlines. I HAVE ATTACHED A REFERENCE PLEASE CONSIDER! I need for both pictures. I am eager to work with someone who can breathe new life and excitement into my images with their artistic touch. Your creativity is your limit...
We are seeking a skilled and experienced java developer to create a custom JMeter backend listener that can send real-time test results directly to a PostgreSQL database. This project aims to enhance our testing capabilities by enabling seamless integration of JMeter results into our PostgreSQL environment, similar to existing solutions for MySQL like the one found at "" Requirements: Proven experience with Java programming and JMeter test development. Strong knowledge of PostgreSQL and experience in integrating it with Java applications. Familiarity with the JMeter API and backend listener framework
I am in need of a skilled email marketer who can target potential clients within web design agencies. The goal of this campaign is to promote a particular product awareness and sales Key Responsibilities: - Develop a strategic email marketing c... Ideal skills and experience: - Proven experience in executing successful email marketing campaigns - Specific experience targeting web design agencies is a plus. - Working knowledge of renowned email marketing software. - Excellent written communication skills - Strong understanding of B2B marketing - Ability to analyse email marketing statistics in order to adjust the approach as necessary The success of this project will be measured by the number of positive responses and engagements, so if you've got what it takes, I loo...
I'm in need of a skilled developer proficient in MySql, Php, HTML and Css, who can add a functional back office and payment system to my existing website. Key Requirements: - Your primary task will involve adding a back office and payment system that will be database-driven. - The system should include user management capabilities, payment processing functionality, and robust sales and customer record tracking. - Specific features for user management include: user registration, login, and profile management. - For the payment system, you'll need to integrate a payment gateway, provide for invoice generation, and ensure that the system maintains comprehensive transaction history tracking. The website is already designed, so your task will be to add the necessary function...
...interface that works flawlessly on the TradingView platform and setup the stock indicators below the chart. I want the scan results calculated using a one hour period and one month time range to pinpoint when the PPO line is about to cross or has just crossed the PPO signal line and the +DI line is about to cross or has just crossed the -DI line. The indicators are below the stock chart in the order of PPO, ADX, Williams% R, Full Stochastics %K, ATR, RSI, Accumulation / Distribution and MFI. The stock chart will show the EMA(9) and the EMA(15), candlesticks and the Parabolic SAR. Also, I would like an alert sent to my cellphone when a stock meets the criteria above. Here is the script I have used with StockCharts where x means crossed over the value listed after the x. ...
I need a talented freelancer to help me with a special project - removing a person from wedding photos. The wedding party is medium-sized (11-25 people) and I need 9 photos edited. It is important that the project gets done as soon as practicable. Ideally, I would like to see a portfolio of past similar work completed successfully. Attention to detail and a high degree of accuracy are a must in order to produce the best results. If you think you have what it takes to complete this project for me, I look forward to hearing from you soon! Thank you!
SCOPE OF SERVICE Support Service for cases of massive crashes of the ElasticSearch Search Platform (NodeJs + ElasticSearch). It must cover critical outages of Search Services outside of business hours, weekends and holidays (see details). The service must also include preventive analysis that will allow us to establish whether the platform is “healthy” in order to reduce these types of events. DETAIL OF EXTENDED SUPPORT The Extended Support service will have the following scope: • Support Hours: Monday to Friday from 18:00 to 23:00 and Saturdays, Sundays and Holidays from 9:00 to 23:00. The service will cover the resolution of critical incidents (service outage) in this time slot. • The committed SLA, for this time slot, will be 3 hours from the report sent ...
I'm in need of a skilled professional who can create a Terraform script to build my AWS infrastructure from scratch. Key Components: - The infrastructure should be deployed inside its own VPC in AWS - The infrastructure should deploy an RDS database, specifically MySQL, that is securely accessible from the backend and frontend servers, but not accessible from outside the VPC or internet. Instance size: , allocated storage: 100Gb. Admin user/password should be supplied as variables -- I will specify them in the command line. Also a separate user account should be created to access this database. The user should have read/write access, I will again supply the username and password via command line. - The solution should include a set of servers to run both backend and frontend ...
In order to propel my business forward, I'm seeking a seasoned expert to provide professional legal advice. Specifically, I'm keen on: - Understanding the implications and processes of a sole proprietorship structure - Business structure documentation: how it should be reviewed, what key updates are needed Ideally, you are someone with substantial experience in business law, especially with regards to sole proprietorship. If you've previously worked with clients in a similar business stage as mine, please highlight that experience in your proposal. Your expertise will play a critical role in the evolution of my venture, so assure me that you're up to the task by demonstrating your legal acumen. Please provide examples of similar work in your applicatio...
Need fulltime laravel developer immediately individual developer only Minimum Experience- 6month to 2 year Database- mysql knowlegde Salary 10000 inr to 25000inr only Remote desktop interview on ruskdesk software mandatory coding interview
