Full Time
30,000
40
Aug 22, 2025
This job is for someone who knows how to build a funnel through a CRM. Your day to day task is to strategize on where and how you will get your leads.
For privacy and security reasons, you need to be logged into an OnlineJobs.ph account in order to view this link.
SELECT * FROM exrates WHERE rate_name = 'USD-PHP'
SELECT *FROM `employer_jobs`WHERE `job_id` = 1271621 LIMIT 1
SELECT *FROM `employers`WHERE `employer_id` = 740568 LIMIT 1
SELECT COUNT(*) AS `numrows`FROM `t_thread` `t`LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id`WHERE `t`.`job_id` = 1271621AND `misc`.`id` IS NULL
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-04-17',ej.date_added) duration_days, DATEDIFF('2026-04-17',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_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 != 1 AND ej.deleted = 0 AND job_id = '1271621'
SELECT *FROM `employer_jobs_skills` `ejs`LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`WHERE `job_id` = 1271621
UPDATE employer_jobs SET hit_counts = '***Nov-29-2024=127***Nov-30-2024=22***Dec-01-2024=14***Dec-02-2024=14***Dec-03-2024=2***Dec-04-2024=36***Dec-05-2024=35***Dec-06-2024=33***Dec-07-2024=3***Dec-08-2024=1***Dec-12-2024=1***Dec-13-2024=1***Dec-16-2024=1***Dec-17-2024=2***Dec-19-2024=2***Dec-22-2024=2***Dec-24-2024=2***Dec-29-2024=1***Dec-31-2024=1***Jan-03-2025=1***Jan-08-2025=1***Jan-13-2025=2***Jan-15-2025=3***Jan-17-2025=4***Jan-18-2025=5***Jan-20-2025=1***Jan-23-2025=1***Jan-24-2025=1***Jan-26-2025=2***Jan-27-2025=2***Jan-29-2025=2***Feb-03-2025=1***Feb-04-2025=2***Feb-06-2025=2***Feb-07-2025=1***Feb-08-2025=2***Feb-09-2025=1***Feb-10-2025=1***Feb-11-2025=1***Feb-12-2025=1***Feb-13-2025=2***Feb-14-2025=4***Feb-15-2025=3***Feb-16-2025=1***Feb-17-2025=1***Feb-18-2025=1***Feb-19-2025=2***Feb-20-2025=1***Feb-21-2025=2***Feb-22-2025=1***Feb-23-2025=13***Feb-24-2025=55***Feb-25-2025=11***Feb-26-2025=4***Feb-27-2025=5***Feb-28-2025=1***Mar-01-2025=7***Mar-02-2025=1***Mar-03-2025=4***Mar-04-2025=4***Mar-05-2025=1***Mar-06-2025=4***Mar-07-2025=1***Mar-13-2025=2***Mar-19-2025=1***Mar-20-2025=1***Mar-25-2025=1***Mar-27-2025=2***Apr-04-2025=2***Apr-05-2025=1***Apr-08-2025=2***Apr-11-2025=1***Apr-17-2025=1***Apr-29-2025=2***May-14-2025=1***Jun-05-2025=1***Jun-14-2025=2***Jun-28-2025=1***Aug-09-2025=2***Aug-14-2025=1***Aug-22-2025=131***Aug-23-2025=12***Aug-24-2025=4***Aug-25-2025=4***Aug-26-2025=2***Aug-27-2025=2***Aug-28-2025=2***Aug-31-2025=1***Sep-01-2025=2***Sep-02-2025=2***Sep-03-2025=1***Sep-05-2025=3***Sep-08-2025=1***Sep-11-2025=2***Sep-16-2025=1***Sep-18-2025=1***Sep-20-2025=2***Sep-21-2025=1***Sep-24-2025=1***Sep-28-2025=2***Oct-03-2025=1***Oct-04-2025=1***Oct-05-2025=1***Oct-08-2025=1***Oct-09-2025=1***Oct-16-2025=2***Oct-18-2025=1***Oct-23-2025=1***Oct-27-2025=1***Oct-28-2025=2***Nov-02-2025=1***Nov-14-2025=2***Nov-22-2025=1***Nov-25-2025=1***Dec-03-2025=1***Dec-05-2025=1***Dec-10-2025=1***Dec-14-2025=1***Dec-17-2025=1***Dec-30-2025=1***Dec-31-2025=1***Jan-05-2026=1***Jan-12-2026=1***Jan-14-2026=1***Jan-28-2026=2***Feb-05-2026=1***Feb-06-2026=1***Feb-07-2026=1***Feb-08-2026=1***Feb-17-2026=1***Feb-22-2026=1***Mar-01-2026=1***Mar-02-2026=1***Mar-16-2026=1***Mar-21-2026=3***Mar-22-2026=1***Mar-26-2026=4***Apr-17-2026=1' WHERE job_id= '1271621'
UPDATE employer_jobs SET monthly_hits = '***Nov-2024=149***Dec-2024=151***Jan-2025=25***Feb-2025=119***Mar-2025=29***Apr-2025=9***May-2025=1***Jun-2025=4***Aug-2025=161***Sep-2025=19***Oct-2025=12***Nov-2025=5***Dec-2025=7***Jan-2026=5***Feb-2026=6***Mar-2026=11***Apr-2026=1' WHERE job_id= '1271621'
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1271621' AND status LIKE 'sent%' ORDER BY id DESC
SELECT COUNT(*) AS `numrows`FROM `employer_jobs`WHERE `employer_id` = '740568'AND `date_added` >= '2022-06-08'
select * from teasers
SELECT * FROM skill_categories WHERE skill_cat_id=''
Array ( )
Array ( [sid] => AC00c0594045c6eef9407e8fff01f3d467 [token] => f0bfc0b73444a077894a43f5f75e6d41 [length] => 6 [from] => +639221200200 [code_expiry_seconds] => 14400 )
Array ( [admin] => Array ( [verification] => ) [announcement_bar] => Array ( [show_slow_issue_message] => ) )
Array ( [to_email] => onlinejobs.ph+3d844ebf71@invite.trustpilot.com )
Array ( [google_tag_manager] => Array ( [id] => GTM-T5CQMS6P ) [chatgpt] => Array ( [secret] => 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 ) [claude] => Array ( [secret] => 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 ) )
Array ( [app] => Array ( [command] => Array ( [map] => Array ( [OnlineJobs\Mailer\Command\SendEmailCommand] => OnlineJobs\Mailer\Handler\SendEmailHandler [OnlineJobs\Mail\Command\SendEmailCommand] => OnlineJobs\Mail\Handler\SendEmailHandler [OnlineJobs\Mail\Command\QueueEmailPendingCommand] => OnlineJobs\Mail\Handler\QueueEmailPendingHandler [OnlineJobs\Mail\Command\QueueJobEmailPendingCommand] => OnlineJobs\Mail\Handler\QueueJobEmailPendingHandler [OnlineJobs\Mail\Command\QueueUnapprovedEmailCommand] => OnlineJobs\Mail\Handler\QueueUnapprovedEmailHandler [OnlineJobs\Mail\Command\ProcessEmailQueueCommand] => OnlineJobs\Mail\Handler\ProcessEmailQueueHandler [OnlineJobs\Mail\Command\PutJobseekerEmailOnHoldCommand] => OnlineJobs\Mail\Handler\PutJobseekerEmailOnHoldHandler [OnlineJobs\Purchase\Command\RealEstateVaCourseCommand] => OnlineJobs\Purchase\Handler\RealEstateVaCourseHandler [OnlineJobs\Test\Command\HelloCommand] => OnlineJobs\Test\Handler\HelloHandler ) [middleware] => Array ( ) ) [providers] => Array ( [0] => OnlineJobs\Bus\BusServiceProvider [1] => OnlineJobs\Database\DbServiceProvider [2] => OnlineJobs\Mailer\MailerServiceProvider [3] => OnlineJobs\Support\SupportServiceProvider [4] => OnlineJobs\Employer\ServiceProvider [5] => OnlineJobs\Jobseeker\ServiceProvider [6] => OnlineJobs\Mail\ServiceProvider [7] => OnlineJobs\Postal\ServiceProvider [8] => OnlineJobs\Queue\ServiceProvider [9] => OnlineJobs\Courier\ServiceProvider [10] => OnlineJobs\Job\ServiceProvider [11] => OnlineJobs\Purchase\ServiceProvider ) ) )
Array ( [facebook] => Array ( [input] => 1 [connect] => 2 [timezone] => 3 [url] => 30 [id] => 31 [photo] => 32 [name] => 33 [email] => 34 [review] => 35 ) [trust] => Array ( [government_id] => 4 [utility_bill] => 5 [selfie_photo] => 6 [profile_picture] => 7 [phone_number] => 8 [facebook] => 9 ) [verify] => Array ( [profile_picture] => 10 [government_id] => 11 [selfie_photo] => 12 [utility_bill] => 13 [address] => 14 [name] => 15 [reviewed] => 16 [government_group] => 28 [address_group] => 29 [mobile] => 38 ) [address] => Array ( [complete] => 17 [room_unit_no] => 20 [house_no] => 21 [street] => 22 [subdivision] => 23 [barangay] => 24 [city] => 25 [province] => 26 [postcode] => 27 ) [reviewed] => Array ( [similar_names] => 1 ) [name] => 18 [phone] => 19 [sms_verification_code] => 36 [resend_verification_code] => 37 [address_read] => 39 [first_name] => 100 [middle_name] => 101 [last_name] => 102 [edit] => Array ( [government_id_group] => 40 [address_group] => 41 [mobile_group] => 42 ) [salary_re_entry] => 103 [id_proof_recalibrate] => 104 [email] => 44 [mobile_verification_type] => 45 )
Array ( [name_field] => my_name [enabled] => 1 )