Mysql check table statuspekerjaan

Olá, tenho um sistema simples de gestão feito em PHP com BD em MySQL, gostaria de converter esse BD para trabalhar de forma Multi Tenant (varias empresas no mesmo banco de dados em uma unica instalação), e tambem criar um painel administrativo para ativar e desativar essas empresas.

No AI generated art work please look at reference art projects will be rejected if it looks nothing like the character. High Elf Archer is a slender and tall elf with green hair that is long in the back and short in front, with two braids at the side. She has long ears that confirm her status as a High Elf. She wears a green sleeveless archer corset, shorts, a pair of uneven black gloves, knee high boots, and a hood. On adventures, she wears an additional black sleeve over her left arm, the arm guard for her bow arm. She is described as stunningly beautiful, even among elves. On several occasions, she is shown to take the immediate attention of males. She has a small bust, which she is sensitive over. High elf archer should be provocatively

...through the competitive health supplement industry, I'm in search of a talented and creative freelancer to design my product packaging. Key Requirements: - Expertise in designing product packaging, specifically for health supplements. - Strong understanding of designing product visuals that effectively appeals to my target audience – adults and seniors. - Ability to bring creative ideas to the table, yet embody the wellness and trustworthiness of the product through design. - Keen awareness of industry trends and competition. The freelancer should be able to showcase a strong portfolio of product packaging designs, especially within the health supplements sector, demonstrate excellent communication skills, and deliver projects within deadlines. Please submit your...

...begin with; these will come in pairs. One partition will be high priority (aimed at running uninterruptible workloads) and the second will be low priority (spot), both using the same VM SKU. In the first instance, I would like to use HB120v2 for the two CPU partitions and the A100 GPU for the two GPU partitions. I would also like to have SLURM accounting set up within the cluster i.e. not using the MySQL service on Azure. Lastly I would like the cluster to have Prometheus/Graphana monitoring capability so that individual users can monitor job statistics. Eventually, we would like users to also be able to interact with the cluster via VS Code and Jupyter. Delivery : within 1 week -- please only bid if you have done this before. Please provide your past experience and any relevant...

...AND I NEED A STRUCTURAL ENGINEER TO DO CALCS AND DRAWING FOR THE CITY TO GET IT PERMITTED. Conduct comprehensive load calculations: This will involve determining forces, stresses and strains that the structural design will be expected to withstand. - Provide detailed structural drafts: You will focus on delivering accurate structural drafts of the existing building, detailing the current status and structure. - Identify structural integrity code deficiencies: I require someone proficient in interpreting and applying regulations related to structural integrity, who can systematically identify any potential code deficiencies. The perfect candidate will have a strong background in structural engineering, drafting, and code compliance. They will also need to be able to inter...

I need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Con...errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the documents are text-only, so no experience with image or table conversion is required. This is a project with a potential for ongoing work, so a freelancer with good communication and reliability is highly ...

I urgently need an experienced Jira professional to create a detailed project roadmap within 24 hours. - The roadmap should display the epics and deliverables of the project. - The main objective is to use the roadmap to visualize the project's progress and milestones, track and prioritize tasks and deliverables, and communicate the project status to stakeholders. - The stakeholders include the project manager, development team, and client representatives. The ideal candidate should have: - Proficiency in Jira and Agile Methodology - Strong communication and organizational skills - A proven track record in delivering quality project roadmaps within tight deadlines. Please only bid if you can deliver in the requested timeframe.

I'm looking for a skilled Python developer to help me with a scraping project. I need to extract specific product data from a website's table. Skillset: - Proficiency in Python and Scrapy - Experience in web scraping - Familiarity with handling web popups The website () contains a table with important product information. For each product, I need the following details scrapped: Certificate Type Certificate Number Product Type Organization Name Country Issue Date Expiry Date in addition to Product Details Brand Model Description Barcode The data should be saved in a CSV file. There are no specific rules or requirements to be followed during the scraping process.

As part of an ongoing cold email outreach projet, I am looking to effectively move information (the status of leads) from one management tool to another. Here's what the job involves: - Gather information about leads in differents campaigns from Instantly - Moving the gathered data to Overloop (where "old leads" also have status) - Move every lead statut to Airtable There is around 3K leads. Ideal freelancers will possess a solid understanding of cold outreach, sales funnel and CRM. Campaigns are in French.

...skilled data entry operator located in Pune, India, to rectify a Microsoft Office Word document. This task is essential as it requires meticulous attention to detail. Key Tasks: - Rectify the formatting errors and spelling/grammar mistakes in the document. - Make necessary table and layout adjustments for improved readability. - Remove the 'Year' field from one of the rows in the table. This project demands: - Proficiency in Microsoft Office Word. - Exceptional eye for detail to correct formatting, spelling, grammar, and table-related issues. - Ability to follow instructions meticulously. - Excellent communication skills for any clarification or feedback. Please only apply if you're located in Pune, India, and have the necessary skills to complete ...

We are seeking an experienced Shopify developer to create a custom tracking system for our Shopify store. This system will manage and update the status of our workflow and must be capable of sending notifications via email or text. Additionally, we are looking to integrate this system with Klaviyo for enhanced notification capabilities. Key Features Needed: Status Tracking: Ability to update and track the following statuses: Checked in in Queue Work In-Progress Waiting on Customer Waiting for Parts Complete Ready for Pick-up Notifications: Send automated notifications via email or text. Potential integration with Klaviyo for advanced notification options. Requirements: Proven experience in developing Shopify applications or integrations. Strong understanding of Shopify&#...

I'm currently in need of a talented Java backend developer who has a strong understanding of databases, particularly MySQL and PostgreSQL. Key Responsibilities: - API Development: The primary focus of the project is on developing APIs that are efficient, secure, and capable of handling high traffic. - Code Modification: The project requires some modification of existing code to ensure seamless integration of the APIs. - Reporting: The backend developer should be able to generate insightful reports based on the data stored in the databases. Ideal Skills: - Proficiency in Java: Excellent understanding of Java is a must. - Strong Database Skills: Prior experience with MySQL and PostgreSQL is necessary. - API Development: A proven track record in creating high-performance ...

hello, there, We need some Native Austrian and German to do a recording task, they are short sentences, the recording would take you about 15 minutes, the budget is $9 for the whole task the speakers need to be: -Age from 18-55, Both professional vo...You just need to have a good phone. The recording script is in our recording app so you will need to download our recording app and then use task name we provide to log in and record. -Envrionment: Please record in a quiet room, no echo, no other noise like birds noise, car noise and so on. Don't need to use earphone or bluetooth. -Pronunciaiton: we will provide a few sample audios for you to check the pronunciation we need, you need to listen them first before starting the recording task If you are interested in it, please con...

...Cards Against Humanity game that needs some adjustments and updates. Key Tasks: - Fixing Errors: The current project has some bugs that need to be addressed. The app is crashing on startup and experiencing database retrieval issues. Your task would be to resolve these errors and make the application functional again. - Database Update: You'll need to shift from the current WebSQL database to MySQL and ensure smooth data storage and retrieval. New Features to Add: - User Authentication System: Incorporate a new authentication system to enhance user privacy and security. - Game Timer: Implement a game timer to bring an additional level of challenge and excitement to the gameplay. - Animations & Interactivity: Enhance user experience with engaging animations and interact...

I'm in need of an experienced PHP developer to assist in enhancing my project with specific focus on design modifications and functionality enhancements. Key Tasks: - Design Modifications: The project requires a design overhaul to improve aesthetics and user experience. This includes updating the layout, color scheme, typography, and overall visual elements. Your ability to create appeali...enhancements - Excellent problem-solving skills and attention to detail - Ability to work within project deadlines - Good communication skills to understand and implement my requirements accurately. Your ability to combine creativity with technical expertise will be invaluable in achieving the project's goals. Looking forward to working with a skilled professional who can bring fresh ideas ...

I'm in need of an expert who can create a custom education and training platform that mirrors the functionalities and user experience of platforms like Udemy. Basic programming language php laravel.11 Key Features: - Course Creation Tools: I need the system to have user-friendly tools to enable easy content creation and upda... Terms of use and privacy page Contact us page Prevent downloading or screen recording of paid content There are two types of subscriptions: lifetime subscriptions, and subscriptions that expire on a date specified by the administrator The supervisor determines the trainer's commission through an electronic record for each course The same online site is available to see and check If you have a ready-made website, send the link...

...specific improvements to my existing PHP application and enhance its integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience...

I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can upgrade sales and users modules in our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.

...during registration. Freight Tracking and Reimbursement: Record transportation details (departure, arrival, quantity of commodities) for each shipment. Calculate reimbursement amounts based on sales and freight costs. Automated reconciliation ensures accurate financial records. Automated Reporting System: Generate real-time reports on: Freight expenses Commodity quantities transported Reimbursement status Funding approvals User activity User Roles: Commodity growers: Apply for funding, track shipments, and receive reimbursements. Shipping companies: Register, manage shipments, and provide freight services. Organization officers: Monitor approvals, oversee transactions, and generate reports. 3. Outcome The Commodity Transportation and Funding App will: Simplify funding applicatio...

...user-centered design principles Description: Under this project 1) You have to create home page - header with menu navs (parallax effect) to show the sections and login button on right corner - hero section with background image, heading and description of the product - features sections should create multiple sections for each feature with an image and description. - pricing table with 3 variants. - testimonials - footer with company details. 2) Login page - Login page should be divided vertically into two parts left should have a login form with third-party login images like Google, Facebook etc., Right side should be an image showing images in carousel. Bottom of the form should have links to signup. 3) signup page - similar to log...

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should ...methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static method. The other one should compare the performance of the two forecasting methods using the key performance indicators (KPIs) mentioned in Task 1 Question (c). The suggested table format should be used. -SETUP SOLVER WITH CONSTRAINTS of labels and keys for illustration an...

I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to detail are paramount on this project.

Gestion de leads, campañas automatizadas de whatsapp y email marketing. Generación de plantillas HTML para email y landing pages con IA (chatgpt) Html Builder para edición de plantillas Creación de plantillas de mensajes de whatsapp...HTML para email y landing pages con IA (chatgpt) Html Builder para edición de plantillas Creación de plantillas de mensajes de whatsapp con api de meta whatsapp. Calendarización de envíos. Automatización de mensajes de whatsapp Calendario de correos y whatsapps. Embudo de ventas (creación de landings, listas de contacto) Seguimiento de leads (envío de email personalizado o whatsapp) Cambio de status de los leads Configuración de Agentes Virtuales con whatsapp. Almacen...

I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to potentially revamp the user interface and overall design of t...

...service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalised brochure. It is a tax summary page, with tax saving tips, performance graphs, overall tax positions, etc. - The main thing is having fields we can populate with our financial data that will then pull into the brochure, into graphs or...

...Conceptualize and establish raster layers while leveraging specific benefit-oriented data. - These maps should effectively house layers enriched with comprehensive data that can be manipulated by authorized roles and integrated with workflows to progress objects based on attribute changes. - Crucial to this project is the seamless integration of these hosted layers with workflows to monitor progress status. Furthermore, these layers need to be strategically integrated with field data collection workflows, contributing to an overall streamlined data collection and management process that can ultimately be view from office-based and mobile end users. Ideal skills and experience: - Extensive experience in Arc GIS and database integration. - Prior experience with Data Colle...

I'm looking for a talented graphic designer to create a sleek and modern 3-page brochure targeting homeowners. This brochure will be used to inform p...Ideally, you are someone who: - Has a strong portfolio showcasing modern and sleek design aesthetic - Has experience in designing brochures or marketing materials for the real estate or home building industry - Can come up with creative solutions and engaging visuals to communicate complex concepts in a simple manner This project is perfect for a designer who can bring fresh and modern ideas to the table. Items attached: 1. list of our current scope of works that is sent to clients. We want this to be visually appealing. 2. Current e-book "7 Things you should know before building a customer home". Please refer t...

...messaging services to handle asynchronous communications, ensuring efficient and reliable data exchange across system components. SDK Development - Develop and maintain an SDK that provides third-party developers with the tools needed to integrate their AI bots or other services with our platform, including comprehensive documentation and support. Database Management - Manage and optimize MySQL database interactions within the WordPress environment, ensuring efficient data retrieval and storage. System Integration and Testing - Oversee the integration of all system components, employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides...

I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and Rea...administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. ------------------------------------------------------------------------------------------ Should have experience in linux VPS, setting up sites apps email dns firewall NO CPANEL. All work to be done using command line Sites are in php wordpress Node React Apps are in React Native Flutter Database: Mysql/mongo Amt pos...

...Project Specifics: The emulator must not breach game firewall securities or require unauthorized system modifications such as disabling driver signature enforcement. It should operate successfully in the game, similar to devices like Arduino Leonardo or ESP32. The goal is to simulate pressing the Z1 keys solely through software, without external devices. Activation should be tied to the Caps Lock LED status—active when on, and inactive when off. Solutions utilizing 'keybd_event' and 'SendInput' do not meet the requirements of this project; a deeper, more intrinsic approach is necessary. Conditions: The keyboard emulator must function correctly within the game. The project must be compatible with Windows 10. Candidates should be proficient in at least on...

I'm in need of a talented developer who can help me with implementing server-side rendering for my website. Website not rendering html right now so need to do server-side rendering. You are good if you can do that through anydesk or teamviewer. Yes, i can work with new freelancers, Just send me github profile so i can check what you've done. Start your application with "SSR", all other will be ignored.

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.

3D modeling and two photorealistic renders showing the assembly of the table

I require a professional to format my entire scientific thesis in Microsoft Word. The document needs to be formatted to a high academic level. This will require the following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatting academic or scientific documents. - ...

I am looking for a skilled developer to create an engaging Employee Pre-Verification system. This system will focus on Background check and Referral check. Key Functionalities: - **Background Check**: This system should have the ability to conduct background checks on potential employees. This can involve checking criminal records, credit history, and other relevant information. - **Referral Check**: The system should also incorporate a referral check system. This can help verify the authenticity of the references provided by the employee. User Interface: - The UI of this system should be interactive and engaging. This will ensure that the system is not only functional but also user-friendly. Reporting System: - The system should generate reports in t...

We want to delelop a cibersecurity software/app to Sell to other companies that can check each computer and device, as also as detect treaths to the company network/devices like e-mails, apps, and suspicious content that puts the company security in Treath.

...from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years because that is all the data it had collected since using this module. Hopefully this makes sense but let me know if I can clear it up. I also ...

NOTE: MUST SUBMIT AN ACTUAL HIGH-LEVEL STRATEGY AND PLAN. I'm looking for a skilled marketing strategist who can help my company, Harmoni Innovative Tiny Homes, with our new venture: organizing date nights in our RVs. Check out Harmoni (our RV). She will be redecorated to align with our new marketing plan. Target Audience: - Young couples - Empty nesters - Adventurous singles - New couples Key Requirements: 1. Marketing Strategy: -Name (ex: Harmoni Dates/Love Camper...) -We need a comprehensive, innovative marketing strategy that appeals to our target audience. - This strategy should emphasize: - Brand awareness - Generating website traffic - Driving bookings and reservations. 2. Marketing Channels: - I would

I'm looking for a professional who can assist me in automating the employment verification process, specifically for background checks. The system should require minimal human intervention. Key requirements: - The verification data should be collected through online forms. - The process should be fully automated, requiring as little manual intervention a...of the information collected. - The verification process should be optimized for background checks. Ideal skills for this job include: - Experience in software development or automation, particularly in data collection and processing. - A background in data security and privacy, as this is crucial for the handling of sensitive employment verification information. - Familiarity with background check processes is a plus, but...

...responsive design for both web and mobile views Pages to Design: Home Page: Displays an overview of tasks, notifications, and key metrics for the day. Contents: Summary of check-ins/check-outs, ongoing tasks, alerts, and quick links to other sections. Property Listings Page: Allows property managers to view (individual and all listings), add, and edit property listings. Contents: List of properties with details like name, location, status, and actions (edit/delete). Task Page: Shows all tasks for the day, assigned to different team members. Contents: Task descriptions, assigned team members, scheduled times, and status updates. Assaign Page: Shows all tasks ready to be, assigned to different team members. Contents: Task descriptions, assigned team members, ...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm seeking an AI developer to create an AI Resume Creator. The primary focus of this project is to take a normal CV / Resume and format it into our company format. It's quite a simple process, populated some fields, removing personal details and then coping the rest of the text into our format. We would want to be able for the AI to use the template we create and it check it each time to make sure we havent updated anything. We would drop the resume / CV into one folder then it would be added to another folder formatted. Ideal Skills and Experience: - Strong background in AI and Machine Learning - Experience in NLP and chatbot development - Proficiency in creating customizable sections for user-friendly interfaces - Understanding of how to analyze user's skills f...

I'm seeking a...that offer an in-depth view for each user. - Direct messaging capabilities for seamless communication. Activity Tracking: A core element of this app is the tracking of users’ activities. This entails: - Sleep tracking: To monitor and analyse the user's sleep patterning. - Mental health tracking: A holistic mental health tracker incorporating mood patterns, meditation frequency and daily tasks check-in. Subscription: - A Monthly subscription option is needed, requiring a seamless and secure payment gateway. Ideal candidates should have experience in designing healthcare or wellness apps, with considerable knowledge in integrating tracking functionalities. You should also understand data security measures, as preserving user confidentiality is pa...

I'm looking for a developer to integrate our Common App platform with both Salesforce and Jenzabar. The main goal is to enhance our applicant response capabilities through automated communication. Key Responsibilities: - Integrate Common App with Sales...Requirements: - Previous experience with Salesforce is mandatory - Proven track record of integrating systems - Strong understanding of applicant management systems Your core responsibilities will revolve around implementing and maintaining automated communication features within Salesforce. This includes: - Sending application received confirmations - Updating applicants on their application status - Sending out admission decisions Note: Please include in your application any relevant experience you have with similar syste...

I'm looking for a talented graphic designer to revamp the current cover of my parenting book. The current one isn't quite hitting the mark and I'm looking for someone who can bring fresh, appealing ideas to the table. I like this cover, but maybe you can improve it.

I'm looking for a skilled carpenter or furniture maker to create a custom wardrobe with an integrated dressing table. Key Requirements: - Material: The wardrobe should be crafted entirely from high-quality wood. - Interior Features: The wardrobe must include shelves, hanging rods, and drawers for optimal storage and organization. The wardrobe should be elegant in design and functional in use. Please ensure it is sturdy and durable, suitable for daily use. It should be a balance between aesthetic appeal and practicality, ensuring it can comfortably accommodate my clothing and accessories. Ideal Skills: - Experienced in carpentry or furniture making, particularly in creating wardrobes. - Proficient in working with wood and able to translate the design into a quality finished...

I'm looking for an experienced developer to create a Flag Status Alert app for both iOS and Android. The app will notify users when to fly the flag at full or half-staff based on their state. The information could be obtained from all 50 state and territory governor pages and the White House website or through a manually updated database. Key Features: - Development for both iOS and Android platforms - Implementation of user notification features including push notifications, email alerts, and SMS alerts. Ideal Skills and Experience: - Proven track record in developing and launching user-friendly mobile applications for both iOS and Android - Familiarity with APIs and web scraping to acquire real-time data from government websites or the ability to create a reliable, manually...

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I am in need of a freelance professional who can assist with the creation of a magazine to promote a small rural town in Arizona and our RV resort. We also need you to design 6 billboards and signs for our RV resort. The magazine will be composed of: 1) A 35 page magazine/brochure containing ads for local businesses, small business features, business directory, area information, etc. The ...read the magazine, so understanding of effective call-to-actions and market strategies in this setting is preferred. The ideal candidate for this job would have experience in both magazine production and outdoor advertising, with a keen understanding of how to tailor content to the business audience. Most importantly, I am looking for someone who can bring creativity and fresh ideas to the ...