Joomla database edit jobs

I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websit...

I need a skilled WordPress developer to edit my book site. Key Requirements: - Ensure the booking function is working properly - Add a booking button to the middle of the homepage - The booking button should have a minimalist and modern style Ideal Skills and Experience: - Strong proficiency in WordPress development - Experience with implementing booking functions on websites - Ability to design and integrate a minimalist and modern booking button into a website Please include examples of similar projects you've worked on, especially those involving booking systems or custom button designs.

You will take screenshots from various reddit subreddits and make a simple video similar to the format of these videos: @rSlash/videos You must be able to create a quick thumbnail similar to the above with each video. Can use ElevanLabs for voiceovers. -You have an eye for detail - no mista...ElevanLabs for voiceovers. -You have an eye for detail - no mistakes. -You are able to create a large quantity of videos, and you do not miss your deadline. Budget: $15 per long form video. They will be in batches, and this has potential to be long-term. If interested, please title your application "Video Editor for Faceless Youtube Channel." Add a link to your past editing samples + confirm that you edit in Adobe Premiere Pro. We will proceed with a short trial assignment.

I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of the cu...

...Proficient in working with ready-made scripts - Prior experience with minimalist animation is a plus Brief Documents for 3 Video's Below: Video 1 - Annuity Payout Options: Video 2 - Diff between fixed and indexed: Video 3 - What happens when the MYGA guaranteed period ends: This is an excellent opportunity to showcase your creativity and animation skills. If you're confident in your ability to produce high-quality, engaging content in this style, then I'd love to hear from you. This could lead to on going

We are seeking an experienced Flutter developer to integrate 's video and call streaming services along with Firebase database into our existing Flutter application. The primary tasks include implementing 's features for seamless video streaming and call functionality, as well as utilizing Firebase database for efficient data storage and retrieval. The ideal candidate should have prior experience with SDK and Firebase integration. Additionally, the developer will be responsible for updating the app to meet the requirements for submission to both Apple Store and Android Store. If you have the necessary skills and expertise in Flutter development, we'd love to hear from you.

...products. The focus of the website will be on selling products directly to customers. Key requirements include: - Integration of Credit Card payment method: I want to provide a seamless shopping experience for the customers and to do so, I need to integrate credit card payment method. This will be the primary payment gateway for the website. - Product Management: I need to be able to easily add, edit and manage products through an intuitive interface. I'd like some simple features like inventory tracking and discount codes, but I'm open to suggestions on how to best manage the products. The ideal freelancer should have: - Proven experience in E-commerce website development - Expertise in integrating credit card payment systems - Understanding of product management sy...

...column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One administrator is sufficient More agentes are necessary. ADMINISTRATOR PAGE: The administrator can add, edit or remove an agent. Just Name, Surname, phone, email, username, password The administrator can see the list of products, delete one, add another line, edit one line. AGENT PAGE: If the agent logins he can see a list of all the products with quantity bigger than 2. On each raw we want to put a simple dropdown...

...combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be a...

I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-...

I'm in need of a skilled UI/UX designer who can create a mobile interface that's minimalistic and modern while prioritizing user engagement, ease of use, and brand consistency. JOB DESCRIPTION FIXED BUDGET Stage 1: UI/UX Research - $30 Research and ideation: Analyze similar apps. Conduct qualitative and quantitative surveys. User flow: Develop flows for key features. Stage 2: UI Style Guide - $15 Includes typography, icons, and colour schemes. Stage 3: Screen Design Simple Screens (e.g., Onboarding, SplashScreen, Login): $5 each Medium Complexity Screens (e.g., Account page): $15 each

I'm seeking a video editor with programming-related video editing experience. This project involves editing corporate videos. Requirements: - Proficient in JavaScript and React. - Able to edit corporate videos. - Comfortable using programming skills to enhance the video editing process. A candidate with experience in creating video content for corporate clients and knowledge of video editing software will be prioritized. The ideal freelancer should be able to marry their programming skills with video editing expertise to bring out the best in our corporate videos.

I am seeking a talented video editor to edit programming tutorials on Javascript targeting beginner-intermediate levels. The project involves: - Editing raw footage to produce concise and engaging 10-25 minute tutorial videos - Revamping the content where required to make it easily understandable for beginners - Implementing graphical elements to clarify and highlight key points Ideal candidates should possess: - Experience in video editing, preferably with similar projects - Familiarity with Javascript to ensure accurate representation and explanation of concepts - The ability to creatively present complex information in a simplified and engaging manner.

...updated color scheme and font Content Updates: - Updating text: The text content on the website needs to be refreshed to be more compelling, accurate and engaging - Adding new images: Incorporating new images to add visual appeal and relevance to the content - Removing outdated information: Clearing out obsolete information to keep the website current and relevant Functionality Improvements: - Edit Wordpress Astra Pro essentials Theme: Enhance the theme and improve its YOAST SEO - Layout Enhancement: Refine the layout of the website to be more user-friendly and visually appealing - Pages & Features: I have a specific set of pages (6), a video, a contact page featuring a map, and an enquiry as well as email form. The ideal candidate should have: - Proficiency in Wordpress...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new

I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advanta...

I have this proyect and I am looking for a developer that has time available to work on the proyect. It is a long term proyect. I need someone with experience in PHP, Laravel, HTML I need to create a copy of a product page. Here is the info needed on the page; this proyect and I am looking for a developer that has time available to work on the proyect. It is a long term proyect. I need someone with experience in PHP, Laravel, HTML I need to create a copy of a product page. Here is the info needed on the page;

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I am looking for a skilled individual to customize and install a website template for my project. The ideal candidate will have experience with website design, development, and template customization. Requirements: Proficiency in HTML, CSS, and JavaScript Experience with website templates (e.g., WordPress, Joomla, HTML templates) Ability to modify and customize templates to meet specific requirements Knowledge of web hosting and installation processes Attention to detail and good communication skills Responsibilities: Customize the website template according to my specifications Install the customized template on the web hosting server Ensure the website is fully functional and responsive What

I am l...Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or similar projects is an advantage. - Knowledge of color-coding and its application within floor plans to ensure the clarity of the evacuation routes. The final deliverable should be 12 separate editable floor plans, color-coded using Red for the evacuati...

...informational tool. It will include capabilities such as listing businessmen on call and posting guards for the workplace. Proficiency in creating robust e-commerce platforms is desirable. 2. Inclusive Database: The platform should be capable of maintaining a database for recorded guards. Experience in backend database development is vital for this role. 3. User Authentication System: The website should provide a secure username and password login system. There are two different logins: admin and user. : Admin : Can make shift assignments for employees. Admin can also delete, edit and activate or deactivate them User : Can only observe the shift list and observe it through filtering. The perfect candidate for this project would have experience with mul...

I'm in need of a skilled audio engineer who can help me with sound editing, mixing, and mastering for my car show. The estimated duration of this project is less than 1 hour. Key Responsibilities: - Sound Editing: You will be required to edit the recorded audio to ensure it aligns with the feel and message of the car show. - Mixing and Mastering: Your role will also involve mixing different audio elements and mastering the final product to ensure it's of professional quality. Ideal Candidate: - Extensive experience in sound editing, mixing, and mastering. - Familiarity with the car show genre or a willingness to learn about it. - Ability to complete the project in a timely manner. Looking forward to working with a competent professional who can elevate the audio quality...

I am in need of a highly skilled WordPress developer to create a one-of-a-kind digital card making website. The site will have the main purpose of enabling users to create NFC cards, generate QR codes, and edit their unique links. Key Features: - The website is to be built on WordPress, so expertise in this platform is a must. - Users should be able to select templates for their cards, upload images, and customize text. - Crucially, they must be able to input their desired content and have the system generate NFC cards and QR codes accordingly. This implies a seamless, automated process that requires expert coding. Ideal Skills and Experience: - Proficiency in WordPress, with experience in developing custom websites. - Strong knowledge of NFC card creation and QR code generation...

Hi Freelancer, I'm interested in designing and editing some stickers and if like the work we can continue for a bigger venture

I'm in need of a skilled photo editor to work on a batch of 10 raw images initially. If the initial batch is to my satisfaction, I have more photos that will need editing. The photos are of jewellery (earrings, necklaces, bracelets), so the metal and stone colour should be clear. Requirements: - Expertise in working with RAW format (NEF to be precise) - Ability to edit photos in a natural and subtle style - Proficient in cropping and grading images The edited photos will be used for online publication, so it's important that the quality be top-notch. If this goes well, I will have more work for you in the future.

I'm searching for an experienced video editor to professionally edit our wedding footage into a final, 5-10 minute cinematic movie. This transformative effort should take raw footage and create a compelling story, imbued with emotion and beauty. Ideal Skills & Experience: * Mastery of Adobe Premiere Pro, Final Cut Pro, or iMovie. * Proven track record of cinematic-style video editing. * Strong sense of storytelling through film. * Keen eye for detail and creative flair. * Experience with wedding videography is a plus. Your task will be to sift through raw footage, select the best shots, and seamlessly assemble a captivating, cinematic narrative. Your creative input in the editing choices is strongly encouraged as you work towards creating a cherished keepsake of our spec...

...a need to edit the content for a professional tone. This means ensuring that all text is well-written and suitable for a corporate environment. - The overall theme for both the PowerPoint and the video should be corporate and professional. It's important that the final outputs reflect the values and image of our company. - For the video editing specifically, I'm looking for enhancements such as transition effects and text overlays. Enhancing visuals would be a great addition. Ideal Freelancer: - Proficiency in PowerPoint and video editing tools like Adobe Premiere Pro. - Experience in creating professional and corporate visuals. - A good eye for design and the ability to turn complex information into easy-to-understand infographics. - Excellent language and writing ski...

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system fe...

I'm in need of a freelancer who can help with integrating Klaviyo into my Joomla Gridbox website. Key Requirements: - E-commerce Integration: The primary reason for this integration is to enhance the e-commerce capabilities of the website. I want the Klaviyo integration to be seamless and optimized for the products on the platform. The ideal candidate should have: - Proficiency in Klaviyo integration - Experience with Joomla Gridbox - E-commerce integration expertise. Your role will be pivotal in ensuring a successful integration that improves overall efficiency and boosts the e-commerce functionality of the website.

I'm seeking an experienced freelancer with strong attention to detail to perform data entry into my database. The data to be entered is text-based and extracted from various sources which may have distinct formats. Below are specifics about the job: - Handling Text Data: The job will entail entering a variety of text data into the designated database. - Format Diversity: The data comes from diverse sources, so it does not adhere to a specific format. The ideal candidate must be adaptable in handling different data formats. - Correcting Discrepancies: The freelancer will need to spot and correct discrepancies or inconsistencies within the data sources. Accuracy and keenness to details will be crucial. Ideal Skills: - Proficient in data entry - Strong attention to d...

I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.

I'm in need of an experienced video editor who can help me create visually engaging and dynamic content for my social media platforms. Specifically, I'm looking for someone who is well-versed in editing Instagram Reels and Youtube Shorts. Key requirements: - You should be able to edit videos to fit within the 1-3 minute timeframe. - The ability to add text overlays, transition effects, and color grading to enhance the overall visual impact of the content. Ideal skills and experience: - Proficiency in video editing software. - Strong understanding of social media trends and what makes content engaging. - Ability to work creatively within the constraints of short-form video content. If you have a knack for storytelling through short videos and can bring a fresh and modern...

Please Sign Up or Login to see details.

...• Quality Microphone Ready to take your sales career to the next level? We are! How to Apply? (Do the Following to be considered, copy and paste the template below and use as your cover letter) 1. Record Your Voice: Read the following sales script with your voice: 2. Speed Test Goto: Change server to any Los Angeles, CA Server. Screenshot or link me to your test result. 3. Are you able to work in USA Time? (-8 PST) working 8am-4pm or 8am-5pm? 4. What is your Sales Experience and Website Design knowledge? 5. Are you able to make 100-200 calls per day? 6. Do you have a quality mic and quiet working environment?

Hi, I want a video editor who can edit according to my given instructions. PROCEDURE: I will send you trimmed video of raw footage. A document will be provided with all instructions what to add in stock footage, text animation, transitions etc. all the stock footages will all provided by me. I will provide this for both Instagram reel send YouTube video. I will also send you subtitles file for Instagram reel. You only have to follow the instructions and first send me the first draft of edited video. I will tell you the required changes in the video. After doing all the changes you have to send me the project file. The changes will be only 1 time not multiple times. REQUIREMENTS ADOBE PREMIERE PRO EXPERIENCE IN INSTAGRAM AND YOUTUBE VIDEO EDITING. TIMELY DELIVER VIDE...

I am in need of someone who can promote and edit videos for my residential real estate Project I have some clips and a reference video Also I need someone who can help me with describing the popular location surronding my site using "google earth" which i have a reference Project needs to be completed within today If anyone available Kindly BID

Hello, please do...Authenticity Customer Complaints and Restricted product policy violations. I need an expert to help me write an excellent appeal that will get my account reinstated. You must have experience and provide proof that you are well versed in Amazon and have successfully helped other sellers get their accounts reactivated. You need to know the ins and outs of submitted successful appeal letters. You need to edit a few invoices for three products according to Amazon's instructions as I am unable to provide genuine invoices. The right candidate will have a comprehensive understanding of what constitutes Amazon violations, specifically Product Authenticity Customer Complaints and Restricted product policy violations. If you are confident you can help me, please ap...

...enhance our Products page and other sections of our site, highlighting the benefits and features of our software for small-medium dealerships. Project Details: - Budget: 80 NZD $ - Delivery Timeline: 2 days - Number of assets: 21 - Page Link: Design Spec Example: ---Experience in creating professional, high-quality website images/animations ---Ability to understand and visually communicate the key benefits and features of our software ---Fast turnaround time without compromising on quality ---Familiarity with the automotive dealership industry is a plus Job Scope: ---Create images/animations that blend real-world problems faced by small family-owned dealerships

I'm looking for a skilled animator to create an old style pencil animation gif for my upcoming wedding event. Key Requirements: - The animation should be in an old style pencil animation format. - The animation should be long, over 20 seconds. - It should include the couple's names, ... Key Requirements: - The animation should be in an old style pencil animation format. - The animation should be long, over 20 seconds. - It should include the couple's names, the wedding date and the wedding venue. Ideal Skills and Experience: - Proven track record of creating animated gifs, especially in the pencil animation style. - Proficiency with relevant software and tools to create and edit such animations. - Attention to detail, as the animation needs to include specific inf...

replace the word teacher with "Leader"

... (in ) - Float Player: This function enhances the user experience by ensuring that the media player remains visible on the screen even while scrolling. (parts in + + ) - Generate Thumbnail: The ability to automatically generate thumbnails for posts, easing the process of content management. () - Edit Post Generate Thumbnail: This function allows users to make changes to their thumbnails easily. () Specific Requests: - The desktop existing layout remains the same it has been done through elementor, the mobile/tablets version have to be edited by you. - The pagination function should be applied to the Home Page of the new website. Ideal Candidate: - Proven experience in web development and transferring functions between

...possess an excellent command of both Spanish and English, with extensive experience in translation and document editing. **Responsibilities:** - Translate a variety of documents from English to Spanish and vice versa while maintaining the content, context, and style of the original material. - Convert PDF documents into editable Word formats, ensuring that the layout and formatting are preserved. - Edit and format Word documents to meet specific client requirements. - Ensure translated documents meet the quality standards and timelines set by clients. **Requirements:** - Must be a native speaker of Spanish with an excellent command of English. - Proven expertise in translation with a strong understanding of linguistic nuances between Spanish and English. - Proficient in convert...

I am looking for a video editor to edit a series of 1-minute travel vlog videos for the week of May 21-28. The final videos need to be fun, energetic and engaging. I am gone on a trip doing a race through europe from may 21-28. I need someone that is skilled at editing and can put together 1 min videos that are entertaining, with graphic overlays, music (does NOT have to be copyright free music) Must be able to make these edits between 4pm EST to - 4amEST. I will send all video files to a shared drive for the day before I goto bed. I can give a quick outline of how I would like the video but I want you to be able to watch the videos and know what parts need to make the cut. I will try to edit the videos so there may be 15-20min of videos for you to look though at the max...

I'm needing a highly skilled photo editor and retoucher, capable of completing a time-sensitive project. You'll be handling 60 images, taken from a recent event, and the task includes the following: - Color correction - Crop and resize - Remove blemishes A natural and realistic touch is desired, maintaining the originality and authenticity of the event. The project is urgent and needs to be completed within a day. Once finished, send the final edited photos through a file transfer service. Ideal freelancers for this job should have experience with fast-paced projects, superior skills in photo retouching and editing, and an ability to correctly interpret and satisfy photo aesthetics requirements.

Sorry I forgot to add the video I wanted to be edited. Its now here under "can you make it" please review Looking for someone to add 2 edits to this video : 1: at :07 when i say no money, no credit cards and no plan. I...with fat heads, traveling from Milan, Italy all the way to Berlin Germany. Looks at the video I attached I would like the dotted line to follow them all the way to Berlin. Also it doesnt need to be straight line to berlin make sure it moves around a little bit. I am also looking for an editor to hire for a week while im in europe, so if you are able to do a good job on this I may hire you to edit 7 videos, 1 per day ~$50-$100 per video. Please show me what you can do and feel free to send any other vlog style videos you have done in the past so I can...

I need to create alternating colors for rows 19 to 28 and specifically for cells F29, F30, F31, and F32 using fill colors #F2F2F2 which is light gray and #F2F2F2 which is white. There will be a lot of hiding and unhiding of rows for this range and I need a solution that always displays alternating colors despite frequent hiding and unhiding of rows. Can anyone help me with settin...of hiding and unhiding of rows for this range and I need a solution that always displays alternating colors despite frequent hiding and unhiding of rows. Can anyone help me with setting up a conditional formatting rule that automatically alternates the row colors, regardless of row insertion, deletion, or hiding? https://docs.google.com/spreadsheets/d/1SwqtiYIrZdO8p6YOxKsOx5MTgE3qQwAajTKIImYWHmE/edit#gid=...

...Description: Position Overview: The Digital Media Specialist will be responsible for video editing, creating compelling thumbnails, managing digital marketing campaigns, and overseeing our social media channels. The ideal candidate will have a strong background in digital content creation and marketing, with a keen eye for detail and a passion for education. Key Responsibilities: • Video Editing: • Edit educational videos, promotional content, and event recordings. • Ensure high-quality output with creative transitions, graphics, and sound effects. • Collaborate with educators to produce engaging and informative videos. • Thumbnail Creation: • Design eye-catching thumbnails for YouTube and other video platforms. • Utilize graphic design software...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complex...

I am experiencing slow query processing and management issues with large ...experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall d...

Make these photos cinematic/colorgrade them/make them look futuristic. Or make them look like a futuristic sci-fi movie poster You can change the background or keep it the same. Add "Glitchmodo" to the photos if you do good, ill have you edit more photos DONT USE AI OR I WILL BE ABLE TO TELL