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.0010
Controller Execution Time ( Jobseekers / Job )  0.0165
Total Execution Time  0.0182
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,517,160 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.0082 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1027397
 LIMIT 1 
0.0004   SELECT *
FROM `employers`
WHERE `employer_id` = 241398
 LIMIT 1 
0.0010   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.0008   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1027397 
0.0012   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=2' WHERE job_id'1027397'  
0.0010   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=2' WHERE job_id'1027397'  
0.0009   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.0007   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '241398'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0004   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)