Open skype history file jobs
...system Smooth checkout process with multiple payment options (credit cards, PayPal, etc.) Order tracking and history Payment Gateway Integration: Integration with major payment processors like Stripe or PayPal Secure transaction handling Rating and Reviews: System for buyers to rate and review sellers and products Display of ratings and reviews on product and seller profiles Messaging System: Direct messaging between buyers and sellers for negotiation and queries Notification system for new messages and updates Price Tracking and Market Analysis: Historical price data and trends for products Alerts for price changes and new listings Detailed price history, including a 12-month history of trade range, sales, price, average sale price, last sales, current sales, c...
I'm in need of an expert in ASP.NET Core 8, visual studio 2022, and ChatGPT 4 for a unique project. I require a tool/webpage that can seamlessly re-write chapters of my book for me. My book has 25 chapters. Each chapter contains between 10 and 30-pages. Each chapter is written in MS Word (.docx) document and must be converted into FORMAL and PROFESSIONAL-style content. This project requires the following key features: - **Input & Output Format**: - The system must take a Word document as input. - The output should be a Word document while preserving all the original formatting. - **Language Support**: - The tool should be able to rewrite the document in both English and Spanish. - **ChatGPT Version**: - I prefer the latest ChatGPT 4 for the rewriting task. Ideal Ski...
I'm seeking a dedicated researcher and historian to assist me in creating an educational and informative radio program focusing on modern history within the Americas. Key Requirements: - Conduct thorough research and documentation on crucial events, figures, and socio-political developments within the Americas post-1500 AD. - Transform this research into engaging and informative content suitable for a radio audience. - Ensure all content is historically accurate and properly cited. Ideal Candidate: - Profound interest and expertise in modern history - particularly within the Americas. - Experience in historical documentation and research. - Excellent communication skills and ability to craft engaging content. - A strong background in radio production or similar audio ...
I am seeking a proficient historian or researcher, ideally specialized in modern history, who has excellent research skills particularly related to Asia. Your inputs would be instrumental in providing a comprehensive and factual understanding of historical events in Asia during the modern era. Job Responsibilities: - The task involves in-depth research to be based on archival documents and online databases. - Analyzing, interpreting, and presenting findings in a clear and accurate manner. - Ensuring utmost accuracy and detail by counterchecking with multiple sources. Required Skills and Experience: - Bachelor's degree in History/related field, or significant experience in historical research - Proven history of excellent research and analytical skills - Proficie...
I'm in need of expert landing page designer for my two businesses. The landing pages are aimed at providing visitors with comprehensive information regarding the services I offer. Key Requirements: - **Content D...for the landing pages is currently unavailable. Therefore, I need a designer who can also handle content creation. - **Design Style**: The landing pages should be designed in a professional and sleek style. Ideal Skills and Experience: - Proven experience in designing and developing compelling and professional landing pages. - Strong content creation skills. - A portfolio that demonstrates a history of successful landing page designs. Please bid only if you can fulfill these criteria. A comprehensive understanding of user experience and SEO best practices will b...
I need an expert to establish my eBay marketplace for selling individual bottles of syrup for frozen drinks. The ideal freelancer should have experience in setting up and optimizing product listings on eBay, especially within the drink or food industry. Based in Brisbane Queensland Australia. Selling into states on Queensland, New South Wales... Selling into states on Queensland, New South Wales, Victoria mainly. Key Responsibilities: - Create an inviting and accurate description of the product - Set up an efficient shipping and handling process - Handle customer inquiries and concerns. Experience: - Setting up eBay stores - Food and beverage industry knowledge preferred - Exceptional customer service skills. Have a sales/product history and profile from previous business Owner ...
Before you bid, read carefully. Do not ask me about my budget during the ...suspended, why and the bus details what should the administrator be able to do? - blacklist/suspend driver - see driver speed -view route record - Real time tracking of bus location on google map - all drivers send messages push notification - all parents send messages push notification -accept/approve new driver -accept and approve new passenger - assign passenger to a bus - can print out the travel history of each student for an entire year / month - Generate QR code for each student / driver - number of kilometers the driver drives per day to and from the location. budget is indicated if you can do the job in my budget you can bid if not don't bid i will create and release milestone after i have t...
...country-specific sanctions, and provide a detailed report of these connections as well as a option to show a visual mapping. Key Requirements: - Download the complete list of sanctions data from Open Sanctions database - Conduct a thorough database search to identify country-specific sanctions - Create a report summarizing the identified connections The final report should be in an interactive web page format. The visualization should be clear and easy to comprehend, allowing for an intuitive exploration of the connections found. Ideal Skills & Experience: - Proficiency in scripting and data retrieval - Familiarity with Open Sanctions database or similar resources - Ability to create interactive web pages for data visualization - Experience in working with and depi...
...least 100 sample products for demonstration. recommendation system: Generate recommendations based on simple rules and user behavior. For example, you can recommend products that are popular among other users, products in the same category as the ones the user has viewed, or products with similar price ranges. Store and update user view history in the database. Display recommended products on the user dashboard based on the user's preferences and view history. Search with Basic Recommendations: Enhance the search functionality to provide basic recommendations. Modify the search algorithm to consider user preferences and recommended products while retrieving search results. Implement autocomplete or search suggestions based on user behavior and popular search terms. Co...
I need a talented designer to creatively illustrate a company overview brochure with an artistic style. Your task involves using relevant design elements that bring color and life to our company's story without using traditional, general information. Key information: - Though the specific content for the brochure was not provided, we broadly want to focus on the company's history, the services we offer, and client testimonials. You'll need to design and layout the given information in an eye-catching and engaging manner. Ideal Candidate: - A designer with a keen artistic eye and a portfolio showcasing previous similar work is desired. - Excellent communication skills are critical for understanding our requirements and suggesting creative inputs. - Proven experience ...
Hello there, I'm in need of some assistance with an old PDF file. I'm experiencing issues with stains and blurriness that compromise the quality of the file. The task I need to be done involves: - Removing the stains and enhancing the overall clarity of the PDF. - The correction work will involve handling a mix of both text and images. Ideal freelancers for the job will have ample experience in handling and editing PDF files. Proficiency in using advanced PDF editing tools will be highly beneficial for this task. I value attention to detail in ensuring that the document's quality remains high and no content is lost or altered during the correction process. Looking forward to seeing your proposals.
I need a concise but compelling company profile for my restaurant, focusing on its history, presence, background, achievement and vision etc. This profile will be used primarily for print materials, so I don't need photography included. Key deliverables: - A professionally written company profile highlighting the history, presence, background, achievement and vision etc. of the restaurant. - The content should be concise, engaging, and suitable for print materials. - No need for photography to be included. Ideal Skills & Experience: - Proven experience in creating F&B company profiles, particularly for restaurants or within the food industry. - Proficient in writing concise, engaging, and professional content. - Previous experience with print material is a p...
We need a non-fiction writer skilled in producing engaging and informative content about Malayalam cinema. This project requires a deep understanding of Malayalam cinema and the ability to communicate its nuances clearly in English. Ideal Skills & Experience: - Strong knowledge of Malayalam cinema history and culture - Excellent non-fiction writing skills - Experience crafting informative content - Proficiency in English and Malayalam, both written and verbal Your role will be to write pieces that provide insight into various aspects of Malayalam cinema, highlighting the significance and influence of the films. Understanding your audience is key, so it's important you can communicate complex ideas in a relatable manner. Only writers with relevant skills and experience s...
I'm in need of expert landing page designer for my two businesses. The landing pages are aimed at providing visitors with comprehensive information regarding the services I offer. Key Requirements: - **Content D...for the landing pages is currently unavailable. Therefore, I need a designer who can also handle content creation. - **Design Style**: The landing pages should be designed in a professional and sleek style. Ideal Skills and Experience: - Proven experience in designing and developing compelling and professional landing pages. - Strong content creation skills. - A portfolio that demonstrates a history of successful landing page designs. Please bid only if you can fulfill these criteria. A comprehensive understanding of user experience and SEO best practices will b...
I am looking for an accomplished Facebook ad expert with a strong track record in construction and renovation sectors. The goal is to ...accomplished Facebook ad expert with a strong track record in construction and renovation sectors. The goal is to generate both residential and commercial leads to foster business opportunities. Key Requirements: - Solid experience with lead generation in the renovation and construction industry. - Proficiency in creating engaging Facebook ads targeting both residential and commercial sectors. - Proven history of driving substantial lead generation through social media campaigns. - Expertise in optimizing ads for maximum visibility and conversion. Aptitude for understanding industry-specific conversion triggers is a plus. Let's construct su...
Task at hand is to extract vocals from a highly distorted audio file OF APPROXIMATELY 8 MINUTES. I DO HAVE OTHER FILES I WOULD LIKE DONE AS WELL, IF EXTRACTION IS SUCCESSFUL. As a client, my ultimate target is related to: - Enhancing intelligibility within the dialogue to bring utmost clarity. - Identifying specific words or phrases that may prove crucial. - The file is from a criminal setup with the audio of a father setting up his son; thus every word could change the narrative. The audio clip has been intentionally distorted over crucial conversation. Do whatever it takes to make the conversation extremely clear irrespective of the overall audio quality. Those offering skills and experience in forensic audio analysis, audio software engineering will ideally match the ...
I find myself in need of a highly skilled individual capable of assisting with numerous projects across a variety of areas. Given the breadth of tasks, a versatile set of skills is vital. Specifics haven't been decided yet, but your experience may help mould these into reality. Key skills and experiences: - Website development - Mobile app development - Graphic design Tasks may include, but are not limited to: - Designing user interfaces - Developing backend functionality - Implementing payment gateways While I don't have a concrete vision for design, flexibility and a keen eye for aesthetics are beneficial. Whether it's a minimalistic, bold and colorful, or clean and professional look, the ability to adapt to different styles is key. Your input, initiative and cr...
Seeking an expert to boost our follower count across various social media platforms. Our primary focus is to attract followers from IT companies. Key Responsibilities: - Drive our follower count up sign...effective strategies for boosting brand awareness. - Excellent knowledge of various social media platforms and their algorithms. - Strong communication skills, capable of engaging with followers. - Familiarity with the IT industry would be advantageous. Ideal Candidate: The ideal candidate will be a social media expert with a clear understanding of the IT industry. They should have a successful history of growing followers and increasing brand visibility, as well as a strong ability to engage with followers. A candidate with a pre-existing network in the IT sector will be highly...
...| |-- Redirect to Home Page | |-- New User Sign Up | |-- Sign Up with Google | |-- Sign Up with Facebook | |-- Sign Up with Email |-- My Account Page | |-- Design Improvements |-- User Profile | |-- Customer Personal Info | |-- View and Edit Profile Information | |-- Address List - Add new /Edit and delete | |-- Phone Number Change Option | |-- Order History | |-- View Past Orders | |-- Reorder or Return Items| | |-- Privacy and Security | |-- Change Password |-- Customer Support | |-- FAQ Section | |-- Contact Options (Email, Phone, Live Chat) | |-- Notifications | |-- Email and SMS Notifications | |-- New Login verification | |-- Order Status | |-- Delivery Status |-- Check Out Page | |-- New Cus...
...AV technician tasks (jobs). The main focus here is a user-friendly and highly functional app and site that can streamline our internal processes and improve data management. This work entails: 1. Creation of a PowerApp to facilitate on-site job documentation workflow. That includes: job list, documentation, photo, text, equipment, barcode, time tracking, costs, notes, client's sign-off, task history, attachments, etc. 2. SharePoint data repository 3. SharePoint site to create projects, assign and manage tasks, monitor progress, manage permissions (many clients, many projects, many locations, many technitians scenario) 4. Automation for maintenance scheduling (i.e. create automatically a job as per project's interval) 5. Internal reporting, external reporting (with li...
...knack for penning engaging, informal biography-style content. What's Required: - Composition of a casual, yet captivating account of a detailed personal history. This biography should be comprehensive, drawing on key life moments to create a rich tapestry of the subject's life. Ideal Skills & Experience: - Previous experience writing memoirs or biographies - Ability to write informally while maintaining the depth and credibility inherent to the genre - Mastery in vividly depicting scenes to make the story more alive and engaging Join us in conducting an intriguing journey through the past, mapping out a detailed personal history in an easy-going informal style. It's not just an historical account, it's a story unfurling with each page. Craft...
I require the cleaning of image history from certain photos. Here's what's needed: • Cleaning image history from various websites including Google Imagery, Yandex, and TinEye. • In the process, the goal is to not only remove unwanted objects from the image but to also enhance its quality and restore any damaged areas. • Expertise in image manipulation, using image editing software, and online reverse image search tools are key for this project. • Previous experience in this particular field would be an asset, hinting a familiarity with the process and promising more efficient results. Remember, attention to detail is key for efficient restoration. Let's clean up the past and provide these images a fresh start!
...functionality): Login/Register Projects page Investor dashboards Access to documents and contracts Equità Bio Casa Imobiliária: Property listings (template creation and eventual API connection to partner real estate brokearage platform) Property details Contact form Equità Construction Products and Services: Product catalog (API connnected to dropshipping platform) Service forms About Us: Company history Team Blog: Articles on the real estate and construction market Contact: Contact form Contact information Location Social Media Links: Instagram Facebook I would appreciate it if you could send us a proposal including: Your approach to the project. Estimated timeline and milestones. Detailed cost breakdown. Examples of similar projects you have complet...
Give me what you can for 2 hours of transcription to text of oral interview “Gums and Gossip” Interview
...will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate with the MySQL database once the project is complete. Ideal candidates for this project should have: - need to change php file and combine database. - Proficient experience in PHP and MySQL. - Demonstra...
I need a freelancer who can craft well-researched articles blending history with travel, focusing specifically on creating biographies of historical figures related to the island. The final piece will need to be illustrated and formatted according to Amazon's guidelines, with the content posted on this platform. Key requirements: - Writing: Deliver engaging, well-structured articles with a clear focus on informative biographies of historical figures. - Illustrating: Create relevant and eye-catching illustrations that compliment the articles. - Amazon Expertise: Able to post content following Amazon's requirements on formatting and guidelines. Ideal candidate: - Background in history and travel writing. - Experience in creating biographies. - Proficient with illus...
I need an experienced WordPress developer to investigate and resolve an issue with my website's frontend file upload. Key Tasks: - Identify and rectify the problem causing files not to appear after successful upload. Additional Details: - The files are supposed to be visible on the frontend of the website, but currently, they are not showing up after being uploaded. - The uploaded files are intended to be visible only to logged-in users. Ideal Skills: - Proficiency in WordPress development and debugging. - Experience with frontend file upload functionalities. - Understanding of user permissions and visibility settings in WordPress. I am looking for a professional who can efficiently troubleshoot and resolve this frontend upload issue to ensure the system works flawl...
...installation, automatic backup once a day, DDOS attack prevention, system performance optimization, hacking prevention, encryption between data transmissions, real-time monitoring, data recovery, backdoor checking, backdoor checking and deletion of compromised files, attack root identification and blocking, suspicious process occupation identification and recovery, server hacking analysis, server access history tracking, password recovery and complexity setting, virus and malicious software checking,,data leakage prevention.....etc My current monthly budget is about $50, Please send me a proposal/chat with as much as you can about what you can do to secure your Linux server and I will check them all and get back to you. **You will be required to write a weekly report (anything...
I have a simple STL file that I need to be transformed into a 3D model for visualization purposes. This project requires proficiency in SketchUp specifically and making elevation on pdf. Key requirements: - Transforming an existing STL file into a 3D model - The 3D model should be optimized for making 3d images I am looking for an experienced professional who can deliver high-quality and visually appealing 3D models with 2d elavations on autocad or pdf . An understanding of SketchUp is essential for this task. I will attach the product design in STL format upon agreement with a freelancer
...videos, analyzing and improving the retention rate, and promoting the content across various platforms. - Enhancing engagement: Engagement is crucial for the growth of the channel. Your responsibility would be to encourage and maintain a high level of engagement with the viewers to keep them coming back for more. Ideal Candidate: - Proven track record: I'm looking for someone with a successful history of growing YouTube channels, specifically in increasing subscribers, views, and engagement. - YouTube SEO knowledge: A good understanding of YouTube's algorithms and best practices is key. - Creativity: Thinking outside the box and coming up with innovative strategies for growth is highly valued. - Communication skills: The ability to communicate effectively, both to coll...
...products in quotation. Admin can edit the prices manually and can share and download the requested quotation to anyone. 6. Admin can create multiple sub admins and can assign different rights to them as he wants. 7. After approval of the quotation of the customer, he can place the order and unique order id must be generated against each order. 8. Admin can see the order history and filter the data as required. In order history customer can see the order id, date, amount, invoice pdf, Order dispatch details etc. 9. Admin can upload, modify and delete the bank details, QR code and Google pay and Phone pay details any time and the details can be seen by customer so the he can do payments any way he wants. 10. Final invoice can be generated through the portal or mobile app and...
I'm in need of a talented audio professional to help me clean up a series of speech-based audio files. These files suffer from significant background noise, specifically static or electronic noise. This noise needs to be removed, without compromising the speech content. Key responsibilities: - Identify and isolate the static or electronic noise. - Employ appropriate tools and techniques to clean the audio. - Deliver high-quality audio files free of noise. Ideal candidate: - can use AI - Proficient in audio editing software such as Audacity, Adobe Audition, etc. - Previous experience in cleaning audio files, especially speech. - Strong attention to detail. - Able to work efficiently and meet deadlines.
I'm in search of an expert Image Consultant to assist with my personal brand and clothing style. Your responsibilities will include: - Color...image goals. The ideal candidate should have experience in image consultation and style advising. When sending your proposal, please provide a detailed plan or approach for the project. I prefer to communicate via Phone/Skype calls, so being comfortable and proficient with these tools is a must. Looking forward to working collaboratively to elevate my image and wardrobe. Please send send some example before and after pictures and what the aim was and the process involved to get from current personal brand to the 'new you' image. If collaboration is a success, I would be open to working together with my clients a...
I'm in search of an experienced professional with a strong background in portal creation. The specific platform or technology used for this project is not as important as a demonstrated history of success in creating digital portals. Ideal Experience and Skills: - Experience in portal creation, having successfully delivered similar projects in the past - Strong understanding of user interface and user experience principles for optimal end-user engagement. Please note: Successful applicants will illustrate their relevant experience, showcasing past work samples if possible. This is the best way to demonstrate that you have the skills and experience we're looking for.
I have an excel file, need add product categorie on a column - budget 100€
...Interface appearance use graphic buttons (this may be the simplest graphic with a color change), the result of the operation can be presented in the form of binary, octal hexadecimal (additional buttons), enter the history button: opening a new window with information about the actions taken since the application was started, showing the actions in the following lines of the list. Project 2. Create a Music MP3 player mobile application in Flutter or in Android Studio that recommends its users the local area popular songs based on their GPS location. Submit the source code and the apk file as Task2.zip. Project 3. Create a Mobile Application for a Cafe Restaurant to receive orders from its Customers. The Application should offer a list of menu items [For Example: Coffe...
...least 100 sample products for demonstration. recommendation system: Generate recommendations based on simple rules and user behavior. For example, you can recommend products that are popular among other users, products in the same category as the ones the user has viewed, or products with similar price ranges. Store and update user view history in the database. Display recommended products on the user dashboard based on the user's preferences and view history. Search with Basic Recommendations: Enhance the search functionality to provide basic recommendations. Modify the search algorithm to consider user preferences and recommended products while retrieving search results. Implement autocomplete or search suggestions based on user behavior and popular search terms. ...
I'm launching an art website and I need an experienced writer to craft engaging and informative articles on various art topics. The main focus will be on promoting the appreciation of art across the general public. Key Requirements: - Ability to create well-researched, high-quality articles on art - Understanding of different art forms and movements...the appreciation of art across the general public. Key Requirements: - Ability to create well-researched, high-quality articles on art - Understanding of different art forms and movements - Experience in writing for online platforms - A flair for engaging and captivating writing The ideal candidate will have a strong writing portfolio with a focus on art-related content. A background in art history or a related field would b...
As an entrepreneur, I am seeking a proficient web developer to construct an innovative e-commerce website boasting a unique QR code feature and credit card processing capabilities. Experience in handli...website boasting a unique QR code feature and credit card processing capabilities. Experience in handling similar projects would be ideal. You need to: - Develop a user-friendly e-commerce website - Integrate a credit card processing system - Design an exclusive QR code feature to download the application If you are a creative problem solver with outstanding skills in web development and have a history of incorporating payment systems into platforms, your application would be strongly considered. Show me your track record of similar work, so I can foresee how successful our proje...
Looking for an animator for a YouTube History Channel. Looking to create videos with a graphic novel/anime feel. Channel is already doing well, and want to hire the right animator to make the videos better. - Experience with Anime/Comics style animation. - Content Knowledge or Adaptability to American History/Old West a plus. -Willing to let the artists natural talent shine through. The style we use for the videos will be based on what you do best. -If you are up for the task this is a great way to get your art in front of millions of viewers! Examples of my current videos, as well as videos that show what I hope to achieve available on request.
...technologies. The core feature of the app is travel package booking. Technology will be NodeJs/Flutter/React Native/Firebase ONLY Key Features: - Travel Package Booking aimed at solo travelers and families. - Search feature to search for destination - Provide detailed information about the package (including directions) - Wallet system for cash management (only to manage refunds) - accounting history - Vendor payment - Booking/cancellation/notifications/feedback The admin panel should include: - User management - Data uploading for treks - Payment management - app configurations I have more details to share with the chosen developer for further fine-tuning. Ideal Candidate: The ideal freelance candidate should have previous experience in developing similar applications ...
Your original Bid Quote price is considered final. - No discussions about increasing the price later. No cAlgo/ cTrader Bot experience? DO NOT BID! Anyone who quotes above budget will be disqualified immediately. Bid only if you are available to start work today. Must Read the attachment before bidding. You must submit your relevant work history as soon as you submit your bid not to disqualify. I'm looking for someone with demonstrable cAlgo experience ( Must share previous work samples and also show me live evidence on a video call to be considered eligible) to code my indicator-based simple bot within 5 days. Feel free to suggest if any of my requirements are difficult for your skill level and I can consider them. Those who don't reply to msgs for more than...
Need hindi dubbing artist . Age : 24 to 28 Duration : 6 minutes For the character (with Green colour T shirt) from skype call in the attached file. Good to have a home dubbing set up or at least a lapel collar mic 2. knows tamil in chennai.
The objective is to develop an application to manage two devices via WiFi (may be increased in the future) I have two devices: Sauna and red light therapy panel. They all have a touch control panel and can be connected to y...have two devices: Sauna and red light therapy panel. They all have a touch control panel and can be connected to your cell phone via Bluetooth and Wi-Fi. Many of the providers also offer you the mobile application already developed (as can be seen in the attached images). The idea is to make a similar application from which the two devices can be managed (set time, lighting, power, etc.). And the history of uses/settings is saved. It could also be evaluated to take the code of the two suppliers' applications and combine them into one, strongly separating ...
...operation for over 30 years. The main source of marketing for this business has been through a Facebook page that was unfortunately attached to the previous owner's personal account. As the new owner, I have access to this page and am able to post, yet, I am faced with a dilemma. I want to separate the business page from the previous owner's personal account on Facebook without losing its marketing history. Requirements in resolving this issue are: * Experience in Facebook's Business Manager and page setup. * Knowledge on how to change a personal Facebook account into a business one, if necessary. * Understanding on how to maintain the historical marketing data associated with the page. Note: I am interested in continuing using Facebook for marketing rather t...
I need a command-line program that can convert .mpz files to .xlsx files. The program should be written in Python. If anyone can do it, please send me the message. Key Requirements: - Input: The program should take a .mpz file (protected password) as input. - Output: The extracted files should be converted to .xlsx format. - Handling: The program should be able to handle files up to 200mb in size. Skills/Experience Required: - Proficient in Python programming - Experience with file handling and conversion Note: A graphical user interface is not required, the program should be command-line only.
I need a freelancer to replace the audio on one video, each approx 1.5 minutes in length. The replacement audio being provided will be in Mp4 format. Specific requirements are: Specific changes requested. - Familiarity with video editing software is essential - Should have experience working with Mp4 video and audio files - Demonstrable history of audio replacement or enhancement work in videos - Ideal candidates will be able to complete the task swiftly and flawlessly Note: The original purpose of the audio replacement (e.g., enhanced audio quality, new narration, removal of background noise) has not been specified. Therefore, the goal is merely to substitute the existing audio with the provided replacement.
i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it
