Part Time
400
10
Jan 27, 2026
We are transitioning from Keap to GHL and need our templates and contracts migrated with custom fields for contacts and opportunity records.
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` = 1261799 LIMIT 1
SELECT *FROM `employers`WHERE `employer_id` = 598359 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` = 1261799AND `misc`.`id` IS NULL
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-07-12',ej.date_added) duration_days, DATEDIFF('2026-07-12',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-07-12',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1261799'
SELECT *FROM `employer_jobs_skills` `ejs`LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`WHERE `job_id` = 1261799
UPDATE employer_jobs SET hit_counts = '***Nov-11-2024=12***Nov-12-2024=130***Nov-13-2024=10***Nov-14-2024=3***Nov-15-2024=4***Nov-16-2024=1***Nov-17-2024=11***Nov-18-2024=11***Nov-19-2024=3***Nov-20-2024=3***Nov-22-2024=1***Nov-23-2024=1***Dec-03-2024=1***Dec-05-2024=1***Dec-08-2024=2***Dec-09-2024=2***Dec-10-2024=1***Dec-11-2024=1***Dec-13-2024=1***Dec-18-2024=1***Dec-23-2024=1***Dec-28-2024=1***Jan-02-2025=2***Jan-07-2025=1***Jan-09-2025=1***Jan-12-2025=1***Jan-15-2025=1***Jan-17-2025=2***Jan-18-2025=1***Jan-31-2025=1***Feb-02-2025=2***Feb-03-2025=1***Feb-07-2025=2***Feb-08-2025=1***Feb-12-2025=1***Feb-13-2025=2***Feb-14-2025=3***Feb-17-2025=1***Feb-18-2025=2***Feb-19-2025=2***Feb-23-2025=2***Feb-26-2025=2***Feb-27-2025=2***Mar-03-2025=1***Mar-06-2025=2***Mar-18-2025=2***Mar-19-2025=1***Mar-22-2025=1***Mar-23-2025=1***Mar-25-2025=3***Mar-26-2025=2***Mar-27-2025=4***Mar-28-2025=1***Apr-06-2025=3***Apr-07-2025=3***Apr-08-2025=2***Apr-11-2025=2***Apr-16-2025=2***Apr-17-2025=3***Apr-18-2025=6***Apr-19-2025=1***May-06-2025=1***May-13-2025=1***Jun-28-2025=1***Jul-01-2025=2***Jul-03-2025=1***Jul-19-2025=1***Jul-22-2025=1***Jul-23-2025=1***Aug-10-2025=2***Aug-19-2025=1***Aug-26-2025=3***Aug-30-2025=1***Oct-02-2025=1***Oct-14-2025=1***Oct-20-2025=1***Oct-29-2025=1***Nov-03-2025=1***Dec-14-2025=1***Dec-28-2025=1***Jan-01-2026=1***Jan-06-2026=1***Jan-16-2026=1***Jan-19-2026=1***Jan-25-2026=2***Jan-26-2026=1***Jan-27-2026=41***Jan-28-2026=9***Jan-29-2026=3***Jan-30-2026=1***Jan-31-2026=2***Feb-01-2026=1***Feb-03-2026=3***Feb-04-2026=1***Feb-06-2026=2***Feb-07-2026=1***Feb-08-2026=1***Feb-09-2026=2***Feb-10-2026=1***Feb-11-2026=1***Feb-13-2026=1***Feb-16-2026=1***Feb-18-2026=2***Mar-01-2026=2***Mar-02-2026=1***Mar-11-2026=2***Mar-17-2026=1***Mar-18-2026=1***Mar-22-2026=1***Mar-27-2026=2***Apr-05-2026=1***Apr-10-2026=1***Apr-18-2026=3***Apr-21-2026=1***Apr-22-2026=1***Apr-24-2026=2***Apr-25-2026=1***Apr-30-2026=1***May-01-2026=1***May-03-2026=2***May-04-2026=1***May-08-2026=2***May-11-2026=1***May-13-2026=2***May-16-2026=2***May-17-2026=1***May-31-2026=2***Jun-03-2026=1***Jun-04-2026=1***Jun-05-2026=1***Jun-08-2026=1***Jun-10-2026=2***Jun-12-2026=1***Jun-13-2026=2***Jun-14-2026=1***Jun-16-2026=2***Jun-22-2026=2***Jun-23-2026=2***Jun-26-2026=1***Jun-28-2026=1***Jun-29-2026=1***Jun-30-2026=1***Jul-02-2026=3***Jul-04-2026=2***Jul-05-2026=1***Jul-06-2026=1***Jul-12-2026=1' WHERE job_id= '1261799'
UPDATE employer_jobs SET monthly_hits = '***Nov-2024=190***Dec-2024=12***Jan-2025=10***Feb-2025=23***Mar-2025=18***Apr-2025=22***May-2025=2***Jun-2025=1***Jul-2025=6***Aug-2025=7***Oct-2025=4***Nov-2025=1***Dec-2025=2***Jan-2026=63***Feb-2026=17***Mar-2026=10***Apr-2026=11***May-2026=14***Jun-2026=20***Jul-2026=8' WHERE job_id= '1261799'
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1261799' AND status LIKE 'sent%' ORDER BY id DESC
SELECT COUNT(*) AS `numrows`FROM `employer_jobs`WHERE `employer_id` = '598359'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 )