Gig
20
5
Jun 17, 2026
I want to organize my business ops using Notion. Create Notion AI-powered operating systems for growing teams. So that Everyone works in one place, and everyone on the same page.
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` = 1670243 LIMIT 1
SELECT *FROM `employers`WHERE `employer_id` = 916373 LIMIT 1
SELECT COUNT(DISTINCT t.id) as cntFROM `t_thread` `t`INNER JOIN `t_message` `m` ON `t`.`id` = `m`.`thread_id`INNER JOIN `t_message_employer` `e` ON `m`.`id` = `e`.`message_id`LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id`WHERE `t`.`job_id` = 1670243AND `misc`.`id` IS NULL
SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-06-29',ej.date_added) duration_days, DATEDIFF('2026-06-29',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-06-29',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1670243'
SELECT *FROM `employer_jobs_skills` `ejs`LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id`WHERE `job_id` = 1670243
UPDATE employer_jobs SET hit_counts = '***Jun-17-2026=468***Jun-18-2026=18***Jun-19-2026=2***Jun-21-2026=1***Jun-22-2026=19***Jun-23-2026=3***Jun-24-2026=3***Jun-25-2026=1***Jun-26-2026=2***Jun-27-2026=1***Jun-29-2026=1' WHERE job_id= '1670243'
UPDATE employer_jobs SET monthly_hits = '***Jun-2026=519' WHERE job_id= '1670243'
SELECT date_sent FROM `jobseeker_sent_emails` WHERE jobseeker_id = NULL AND job_id = 1670243 AND status LIKE 'sent%' ORDER BY id DESC LIMIT 1
SELECT COUNT(*) AS `numrows`FROM `employer_jobs`WHERE `employer_id` = '916373'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 ( [enabled] => 1 [url] => https://v2.stage.app.onlinejobs.ph [api_url] => https://v2.stage.api.onlinejobs.ph [cookie_domain] => .onlinejobs.ph [paths] => Array ( [myaccount] => 1 ) )
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 )