Gig
30000
30
Feb 9, 2024
Xero test
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` = 1107425 LIMIT 1
SELECT *FROM `employers`WHERE `employer_id` = 330925 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` = 1107425AND `misc`.`id` IS NULL
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-04-15',ej.date_added) duration_days, DATEDIFF('2026-04-15',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-15',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1107425'
SELECT *FROM `employer_jobs_skills` `ejs`LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`WHERE `job_id` = 1107425
UPDATE employer_jobs SET hit_counts = '***Feb-09-2024=293***Feb-10-2024=46***Feb-11-2024=37***Feb-12-2024=26***Feb-13-2024=18***Feb-14-2024=10***Feb-15-2024=14***Feb-16-2024=6***Feb-17-2024=1***Feb-18-2024=2***Feb-19-2024=7***Feb-20-2024=5***Feb-21-2024=3***Feb-23-2024=3***Feb-24-2024=2***Feb-25-2024=3***Feb-26-2024=1***Feb-28-2024=3***Feb-29-2024=1***Mar-01-2024=2***Mar-02-2024=2***Mar-03-2024=6***Mar-04-2024=2***Mar-05-2024=1***Mar-06-2024=2***Mar-07-2024=3***Mar-08-2024=2***Mar-09-2024=2***Mar-14-2024=1***Mar-15-2024=1***Mar-16-2024=2***Mar-17-2024=2***Mar-19-2024=2***Mar-20-2024=4***Mar-21-2024=3***Mar-22-2024=2***Mar-24-2024=1***Mar-25-2024=3***Mar-28-2024=1***Mar-29-2024=1***Mar-30-2024=2***Mar-31-2024=2***Apr-01-2024=1***Apr-02-2024=2***Apr-04-2024=2***Apr-08-2024=2***Apr-09-2024=2***Apr-10-2024=1***Apr-11-2024=1***Apr-13-2024=1***Apr-14-2024=4***Apr-15-2024=1***Apr-16-2024=3***Apr-17-2024=4***Apr-18-2024=3***Apr-21-2024=1***Apr-22-2024=2***Apr-23-2024=5***Apr-24-2024=1***Apr-26-2024=1***Apr-27-2024=2***Apr-28-2024=3***Apr-29-2024=1***Apr-30-2024=1***May-02-2024=4***May-03-2024=5***May-04-2024=5***May-05-2024=1***May-06-2024=2***May-07-2024=3***May-08-2024=2***May-09-2024=2***May-10-2024=4***May-13-2024=2***May-14-2024=2***May-15-2024=3***May-16-2024=2***May-17-2024=2***May-18-2024=1***May-19-2024=1***May-20-2024=2***May-21-2024=1***May-22-2024=3***May-23-2024=2***May-24-2024=5***May-25-2024=3***May-26-2024=3***May-27-2024=1***May-28-2024=4***May-29-2024=2***May-30-2024=6***May-31-2024=4***Jun-01-2024=4***Jun-02-2024=5***Jun-03-2024=5***Jun-04-2024=4***Jun-05-2024=7***Jun-06-2024=6***Jun-07-2024=3***Jun-08-2024=3***Jun-09-2024=6***Jun-10-2024=5***Jun-11-2024=5***Jun-12-2024=7***Jun-13-2024=6***Jun-14-2024=5***Jun-15-2024=3***Jun-16-2024=4***Jun-17-2024=2***Jun-18-2024=2***Jun-19-2024=9***Jun-20-2024=5***Jun-21-2024=5***Jun-22-2024=2***Jun-23-2024=4***Jun-24-2024=1***Jun-25-2024=10***Jun-26-2024=5***Jun-27-2024=3***Jun-28-2024=3***Jun-29-2024=4***Jun-30-2024=4***Jul-01-2024=7***Jul-02-2024=6***Jul-03-2024=4***Jul-04-2024=4***Jul-05-2024=9***Jul-06-2024=1***Jul-07-2024=2***Jul-08-2024=2***Jul-09-2024=6***Jul-10-2024=3***Jul-11-2024=6***Jul-12-2024=3***Jul-14-2024=2***Jul-15-2024=5***Jul-16-2024=3***Jul-17-2024=5***Jul-18-2024=3***Jul-19-2024=7***Jul-20-2024=3***Jul-21-2024=5***Jul-22-2024=2***Jul-23-2024=11***Jul-24-2024=65***Jul-25-2024=7***Jul-26-2024=6***Jul-27-2024=3***Jul-29-2024=7***Jul-30-2024=4***Jul-31-2024=7***Aug-01-2024=3***Aug-02-2024=5***Aug-03-2024=3***Aug-04-2024=1***Aug-05-2024=6***Aug-06-2024=4***Aug-07-2024=11***Aug-08-2024=7***Aug-09-2024=4***Aug-10-2024=2***Aug-12-2024=4***Aug-13-2024=1***Aug-14-2024=5***Aug-15-2024=1***Aug-16-2024=1***Aug-17-2024=2***Aug-18-2024=2***Aug-19-2024=2***Aug-20-2024=2***Aug-21-2024=3***Aug-22-2024=5***Aug-23-2024=1***Aug-24-2024=1***Aug-25-2024=1***Aug-26-2024=1***Aug-27-2024=2***Aug-29-2024=3***Aug-30-2024=7***Sep-01-2024=1***Sep-03-2024=2***Sep-04-2024=1***Sep-05-2024=2***Sep-06-2024=2***Sep-07-2024=1***Sep-09-2024=2***Sep-10-2024=2***Sep-12-2024=1***Sep-13-2024=2***Sep-16-2024=2***Sep-18-2024=1***Sep-19-2024=1***Sep-20-2024=1***Sep-23-2024=2***Sep-24-2024=1***Sep-29-2024=2***Sep-30-2024=1***Oct-01-2024=2***Oct-03-2024=2***Oct-04-2024=2***Oct-05-2024=1***Oct-06-2024=4***Oct-07-2024=2***Oct-08-2024=2***Oct-10-2024=3***Oct-11-2024=2***Oct-12-2024=1***Oct-14-2024=3***Oct-15-2024=3***Oct-16-2024=1***Oct-17-2024=1***Oct-19-2024=1***Oct-20-2024=3***Oct-21-2024=3***Oct-23-2024=1***Oct-24-2024=5***Oct-25-2024=4***Oct-26-2024=2***Oct-28-2024=3***Oct-29-2024=2***Oct-30-2024=2***Oct-31-2024=1***Nov-01-2024=3***Nov-02-2024=1***Nov-03-2024=4***Nov-05-2024=3***Nov-06-2024=1***Nov-07-2024=3***Nov-08-2024=1***Nov-13-2024=4***Nov-15-2024=1***Nov-18-2024=1***Nov-20-2024=9***Nov-21-2024=2***Nov-22-2024=1***Nov-24-2024=1***Nov-25-2024=1***Nov-27-2024=3***Nov-28-2024=2***Nov-29-2024=2***Dec-01-2024=1***Dec-02-2024=4***Dec-03-2024=3***Dec-04-2024=2***Dec-05-2024=1***Dec-07-2024=3***Dec-08-2024=1***Dec-10-2024=2***Dec-11-2024=1***Dec-12-2024=3***Dec-14-2024=1***Dec-15-2024=2***Dec-17-2024=1***Dec-18-2024=2***Dec-19-2024=1***Dec-21-2024=1***Dec-22-2024=3***Dec-23-2024=1***Dec-26-2024=1***Dec-27-2024=2***Dec-28-2024=2***Dec-31-2024=2***Jan-01-2025=2***Jan-02-2025=3***Jan-03-2025=1***Jan-04-2025=1***Jan-05-2025=2***Jan-07-2025=1***Jan-09-2025=2***Jan-11-2025=1***Jan-16-2025=3***Jan-17-2025=2***Jan-18-2025=1***Jan-19-2025=1***Jan-20-2025=1***Jan-21-2025=1***Jan-23-2025=1***Jan-25-2025=4***Jan-27-2025=1***Jan-28-2025=1***Jan-30-2025=1***Feb-01-2025=1***Feb-05-2025=1***Feb-06-2025=1***Feb-11-2025=2***Feb-15-2025=2***Feb-16-2025=1***Feb-17-2025=1***Feb-19-2025=2***Feb-22-2025=1***Feb-23-2025=1***Feb-24-2025=5***Feb-25-2025=2***Mar-03-2025=2***Mar-05-2025=1***Mar-06-2025=4***Mar-14-2025=1***Mar-15-2025=2***Mar-19-2025=2***Mar-23-2025=1***Mar-25-2025=1***Mar-26-2025=1***Mar-27-2025=5***Mar-28-2025=1***Mar-29-2025=2***Mar-30-2025=1***Mar-31-2025=1***Apr-01-2025=3***Apr-02-2025=1***Apr-03-2025=1***Apr-04-2025=2***Apr-05-2025=1***Apr-07-2025=1***Apr-08-2025=4***Apr-10-2025=4***Apr-12-2025=1***Apr-15-2025=1***Apr-17-2025=1***Apr-22-2025=1***Apr-23-2025=3***Apr-26-2025=1***May-01-2025=1***May-02-2025=3***May-07-2025=1***May-13-2025=1***May-20-2025=1***May-24-2025=1***May-25-2025=1***May-26-2025=1***May-27-2025=2***May-28-2025=2***May-31-2025=1***Jun-18-2025=1***Jun-21-2025=2***Jun-22-2025=1***Jun-23-2025=1***Jun-26-2025=1***Jun-28-2025=1***Jul-12-2025=1***Jul-14-2025=1***Jul-16-2025=3***Jul-24-2025=3***Jul-28-2025=1***Jul-30-2025=2***Jul-31-2025=1***Aug-02-2025=1***Aug-04-2025=1***Aug-05-2025=1***Aug-08-2025=1***Aug-09-2025=1***Aug-11-2025=1***Aug-14-2025=1***Aug-15-2025=2***Aug-18-2025=1***Aug-19-2025=1***Aug-22-2025=1***Aug-25-2025=1***Aug-26-2025=1***Aug-27-2025=1***Sep-02-2025=1***Sep-04-2025=1***Sep-05-2025=1***Sep-09-2025=1***Sep-11-2025=2***Sep-16-2025=1***Sep-17-2025=2***Sep-19-2025=1***Sep-20-2025=2***Sep-22-2025=1***Sep-24-2025=1***Sep-25-2025=1***Sep-28-2025=1***Sep-29-2025=2***Oct-01-2025=1***Oct-03-2025=4***Oct-05-2025=3***Oct-15-2025=1***Oct-24-2025=1***Oct-27-2025=1***Oct-28-2025=2***Oct-29-2025=1***Oct-30-2025=1***Oct-31-2025=2***Nov-02-2025=4***Nov-03-2025=1***Nov-07-2025=2***Nov-12-2025=4***Nov-14-2025=3***Nov-17-2025=1***Nov-21-2025=1***Nov-23-2025=1***Nov-26-2025=1***Nov-27-2025=1***Nov-28-2025=1***Nov-30-2025=1***Dec-01-2025=1***Dec-02-2025=1***Dec-04-2025=1***Dec-05-2025=2***Dec-06-2025=1***Dec-10-2025=2***Dec-11-2025=1***Dec-12-2025=1***Dec-14-2025=2***Dec-17-2025=1***Dec-20-2025=1***Dec-24-2025=3***Dec-26-2025=1***Dec-27-2025=1***Dec-28-2025=2***Dec-29-2025=1***Dec-30-2025=2***Dec-31-2025=1***Jan-05-2026=1***Jan-09-2026=1***Jan-11-2026=1***Jan-13-2026=1***Jan-14-2026=1***Jan-15-2026=1***Jan-28-2026=1***Feb-05-2026=1***Feb-14-2026=1***Mar-05-2026=1***Mar-08-2026=1***Mar-12-2026=2***Mar-13-2026=1***Mar-19-2026=1***Mar-26-2026=2***Mar-27-2026=1***Mar-30-2026=1***Apr-05-2026=1***Apr-15-2026=1' WHERE job_id= '1107425'
UPDATE employer_jobs SET monthly_hits = '***Feb-2024=481***Mar-2024=49***Apr-2024=44***May-2024=77***Jun-2024=137***Jul-2024=198***Aug-2024=90***Sep-2024=27***Oct-2024=56***Nov-2024=43***Dec-2024=40***Jan-2025=30***Feb-2025=20***Mar-2025=25***Apr-2025=25***May-2025=15***Jun-2025=7***Jul-2025=12***Aug-2025=15***Sep-2025=18***Oct-2025=17***Nov-2025=21***Dec-2025=25***Jan-2026=7***Feb-2026=2***Mar-2026=10***Apr-2026=2' WHERE job_id= '1107425'
SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1107425' AND status LIKE 'sent%' ORDER BY id DESC
SELECT COUNT(*) AS `numrows`FROM `employer_jobs`WHERE `employer_id` = '330925'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 )