Full Time
850
30
Mar 23, 2026
You'll need to launch new ad campaigns daily and monitor their results. You will also need to keep track of which ads you launched in a spreadsheet.
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` = 1608705 LIMIT 1
SELECT *FROM `employers`WHERE `employer_id` = 773832 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` = 1608705AND `misc`.`id` IS NULL
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-04-20',ej.date_added) duration_days, DATEDIFF('2026-04-20',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-20',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1608705'
SELECT *FROM `employer_jobs_skills` `ejs`LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`WHERE `job_id` = 1608705
UPDATE employer_jobs SET hit_counts = '***Mar-23-2026=169***Mar-24-2026=139***Mar-25-2026=32***Mar-26-2026=22***Mar-27-2026=14***Mar-28-2026=3***Mar-29-2026=3***Mar-30-2026=7***Mar-31-2026=4***Apr-01-2026=9***Apr-02-2026=5***Apr-03-2026=3***Apr-04-2026=1***Apr-05-2026=1***Apr-06-2026=5***Apr-07-2026=2***Apr-09-2026=3***Apr-10-2026=3***Apr-11-2026=1***Apr-12-2026=1***Apr-13-2026=5***Apr-14-2026=7***Apr-15-2026=1***Apr-16-2026=5***Apr-17-2026=1***Apr-19-2026=1***Apr-20-2026=1' WHERE job_id= '1608705'
UPDATE employer_jobs SET monthly_hits = '***Mar-2026=393***Apr-2026=55' WHERE job_id= '1608705'
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1608705' AND status LIKE 'sent%' ORDER BY id DESC
SELECT COUNT(*) AS `numrows`FROM `employer_jobs`WHERE `employer_id` = '773832'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 )