make.com< to handle Marketing Automation tasks and daily support. Long-term remote role. **Apply now to join our team!" />

Fix a make.com

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Any

SALARY

Let me know your hourly rate

HOURS PER WEEK

TBD

DATE UPDATED

Aug 30, 2023

JOB OVERVIEW

I have a ---------- automation that is not performing as intended

Need someone who is experienced to quickly fix it

Must have prior experience

SKILL REQUIREMENT
VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0796
Total Execution Time  0.0808
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,517,400 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Fix-a-makecom-1027397
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0742 seconds)  (Hide)
0.0004   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1027397
 LIMIT 1 
0.0015   SELECT *
FROM `employers`
WHERE `employer_id` = 241398
 LIMIT 1 
0.0033   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1027397
AND `misc`.`idIS NULL 
0.0005   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-04-17',ej.date_added) duration_daysDATEDIFF('2026-04-17',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-04-17',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1027397' 
0.0007   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1027397 
0.0009   UPDATE employer_jobs SET hit_counts '***Aug-30-2023=227***Aug-31-2023=30***Sep-01-2023=5***Sep-03-2023=1***Sep-04-2023=1***Sep-07-2023=1***Sep-08-2023=1***Sep-10-2023=1***Sep-28-2023=4***Sep-29-2023=4***Sep-30-2023=2***Oct-01-2023=2***Oct-02-2023=2***Oct-18-2023=1***Oct-30-2023=1***Oct-31-2023=3***Nov-01-2023=1***Nov-05-2023=1***Nov-11-2023=1***Nov-18-2023=1***Nov-21-2023=1***Nov-23-2023=1***Dec-06-2023=2***Dec-12-2023=2***Dec-20-2023=1***Dec-27-2023=1***Dec-31-2023=1***Jan-01-2024=1***Jan-02-2024=1***Jan-03-2024=2***Jan-06-2024=1***Jan-09-2024=1***Jan-10-2024=1***Jan-12-2024=1***Jan-13-2024=2***Jan-15-2024=2***Jan-18-2024=1***Jan-21-2024=1***Jan-25-2024=1***Feb-06-2024=1***Feb-08-2024=4***Feb-09-2024=7***Feb-10-2024=1***Feb-11-2024=3***Feb-12-2024=5***Feb-13-2024=2***Feb-14-2024=3***Feb-15-2024=3***Feb-16-2024=3***Feb-19-2024=2***Feb-20-2024=3***Feb-21-2024=2***Feb-22-2024=3***Feb-23-2024=3***Feb-24-2024=7***Feb-26-2024=4***Feb-27-2024=3***Feb-28-2024=2***Feb-29-2024=4***Mar-01-2024=3***Mar-02-2024=4***Mar-03-2024=1***Mar-04-2024=3***Mar-05-2024=4***Mar-06-2024=3***Mar-07-2024=3***Mar-08-2024=3***Mar-09-2024=4***Mar-10-2024=1***Mar-11-2024=2***Mar-12-2024=4***Mar-13-2024=2***Mar-14-2024=3***Mar-15-2024=3***Mar-16-2024=4***Mar-17-2024=3***Mar-18-2024=4***Mar-19-2024=4***Mar-20-2024=2***Mar-24-2024=1***Mar-25-2024=1***Mar-29-2024=1***Mar-31-2024=1***Apr-01-2024=1***Apr-02-2024=1***Apr-03-2024=1***Apr-04-2024=1***Apr-05-2024=3***Apr-06-2024=3***Apr-07-2024=2***Apr-08-2024=3***Apr-09-2024=2***Apr-10-2024=2***Apr-11-2024=1***Apr-12-2024=1***Apr-13-2024=3***Apr-14-2024=1***Apr-17-2024=1***Apr-20-2024=2***Apr-21-2024=2***Apr-23-2024=4***Apr-24-2024=4***Apr-25-2024=1***Apr-28-2024=1***Apr-29-2024=1***Apr-30-2024=1***May-02-2024=1***May-03-2024=1***May-04-2024=1***May-05-2024=1***May-06-2024=2***May-07-2024=1***May-08-2024=2***May-09-2024=1***May-10-2024=3***May-11-2024=1***May-12-2024=1***May-13-2024=2***May-14-2024=3***May-15-2024=3***May-16-2024=1***May-17-2024=1***May-18-2024=2***May-19-2024=1***May-20-2024=2***May-21-2024=2***May-22-2024=4***May-23-2024=3***May-24-2024=2***May-25-2024=2***May-26-2024=1***May-27-2024=2***May-28-2024=2***May-29-2024=3***May-30-2024=3***May-31-2024=2***Jun-01-2024=1***Jun-02-2024=4***Jun-03-2024=2***Jun-04-2024=2***Jun-05-2024=2***Jun-06-2024=1***Jun-10-2024=2***Jun-11-2024=1***Jun-12-2024=2***Jun-13-2024=2***Jun-14-2024=3***Jun-16-2024=1***Jun-17-2024=1***Jun-19-2024=1***Jun-23-2024=1***Jun-26-2024=1***Jun-27-2024=1***Jun-29-2024=1***Jun-30-2024=1***Jul-01-2024=2***Jul-02-2024=1***Jul-05-2024=2***Jul-08-2024=1***Jul-09-2024=1***Jul-10-2024=2***Jul-11-2024=1***Jul-12-2024=1***Jul-13-2024=1***Jul-14-2024=1***Jul-15-2024=2***Jul-16-2024=1***Jul-17-2024=2***Jul-18-2024=1***Jul-19-2024=1***Jul-20-2024=1***Jul-21-2024=2***Jul-22-2024=1***Jul-23-2024=3***Jul-24-2024=3***Jul-25-2024=2***Jul-31-2024=1***Aug-06-2024=1***Aug-07-2024=1***Aug-11-2024=1***Aug-13-2024=2***Aug-15-2024=1***Aug-16-2024=1***Aug-17-2024=1***Aug-20-2024=1***Aug-22-2024=2***Aug-23-2024=2***Aug-24-2024=1***Aug-25-2024=1***Aug-27-2024=1***Aug-28-2024=1***Aug-29-2024=1***Aug-30-2024=1***Sep-03-2024=1***Sep-04-2024=1***Sep-05-2024=1***Sep-06-2024=2***Sep-07-2024=4***Sep-08-2024=1***Sep-09-2024=1***Sep-10-2024=1***Sep-11-2024=2***Sep-12-2024=1***Sep-13-2024=1***Sep-14-2024=2***Sep-23-2024=1***Sep-28-2024=1***Oct-08-2024=1***Oct-10-2024=1***Oct-12-2024=1***Oct-21-2024=2***Oct-28-2024=1***Nov-04-2024=1***Nov-08-2024=1***Nov-13-2024=2***Nov-14-2024=1***Nov-20-2024=3***Nov-22-2024=2***Nov-28-2024=1***Dec-03-2024=1***Dec-09-2024=1***Dec-24-2024=2***Dec-26-2024=1***Dec-31-2024=1***Jan-08-2025=1***Jan-18-2025=1***Jan-21-2025=1***Feb-17-2025=1***Mar-02-2025=1***Mar-03-2025=1***Mar-11-2025=1***Mar-20-2025=1***Mar-25-2025=1***Mar-27-2025=4***Apr-05-2025=1***Apr-08-2025=2***May-22-2025=2***Jun-04-2025=2***Jun-05-2025=2***Jun-27-2025=1***Jun-28-2025=1***Jul-10-2025=1***Jul-16-2025=3***Jul-24-2025=2***Aug-01-2025=1***Sep-03-2025=2***Sep-12-2025=1***Sep-21-2025=1***Sep-28-2025=1***Oct-03-2025=1***Oct-04-2025=1***Oct-06-2025=1***Oct-23-2025=1***Oct-24-2025=1***Nov-18-2025=1***Dec-06-2025=1***Dec-11-2025=1***Dec-12-2025=1***Dec-13-2025=1***Dec-17-2025=1***Dec-19-2025=1***Dec-20-2025=1***Dec-29-2025=4***Jan-25-2026=1***Apr-17-2026=1' WHERE job_id'1027397'  
0.0011   UPDATE employer_jobs SET monthly_hits '***Aug-2023=257***Sep-2023=20***Oct-2023=9***Nov-2023=6***Dec-2023=7***Jan-2024=15***Feb-2024=65***Mar-2024=64***Apr-2024=42***May-2024=56***Jun-2024=30***Jul-2024=33***Aug-2024=19***Sep-2024=20***Oct-2024=6***Nov-2024=11***Dec-2024=6***Jan-2025=3***Feb-2025=1***Mar-2025=9***Apr-2025=3***May-2025=2***Jun-2025=6***Jul-2025=6***Aug-2025=1***Sep-2025=5***Oct-2025=5***Nov-2025=1***Dec-2025=11***Jan-2026=1***Apr-2026=1' WHERE job_id'1027397'  
0.0023   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1027397' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1027397 
0.0622   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '241398'
AND `date_added` >= '2022-06-08' 
0.0004   select from teasers 
0.0003   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)