1
2.55 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . status AS status_4 , t0 . country AS country_5 , t0 . state AS state_6 , t0 . city AS city_7 , t0 . street_address AS street_address_8 , t0 . expiration_date AS expiration_date_9 , t0 . highlight AS highlight_10 , t0 . schedule AS schedule_11 , t0 . start_date AS start_date_12 , t0 . year_of_experience AS year_of_experience_13 , t0 . pay_rate AS pay_rate_14 , t0 . work_type AS work_type_15 , t0 . need AS need_16 , t0 . pay_rate_hourly AS pay_rate_hourly_17 , t0 . pay_rate_daily AS pay_rate_daily_18 , t0 . blocked AS blocked_19 , t0 . job_id AS job_id_20 , t0 . verified AS verified_21 , t0 . created_at AS created_at_22 , t0 . updated_at AS updated_at_23 , t0 . user_id AS user_id_24 , t0 . employer_id AS employer_id_25 , t0 . profession_id AS profession_id_26 , t0 . speciality_id AS speciality_id_27 FROM b_job t0 WHERE t0 . status = ? ORDER BY t0 . created_at DESC
Parameters :
[
"published "
]
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . status AS status_4 , t0 . country AS country_5 , t0 . state AS state_6 , t0 . city AS city_7 , t0 . street_address AS street_address_8 , t0 . expiration_date AS expiration_date_9 , t0 . highlight AS highlight_10 , t0 . schedule AS schedule_11 , t0 . start_date AS start_date_12 , t0 . year_of_experience AS year_of_experience_13 , t0 . pay_rate AS pay_rate_14 , t0 . work_type AS work_type_15 , t0 . need AS need_16 , t0 . pay_rate_hourly AS pay_rate_hourly_17 , t0 . pay_rate_daily AS pay_rate_daily_18 , t0 . blocked AS blocked_19 , t0 . job_id AS job_id_20 , t0 . verified AS verified_21 , t0 . created_at AS created_at_22 , t0 . updated_at AS updated_at_23 , t0 . user_id AS user_id_24 , t0 . employer_id AS employer_id_25 , t0 . profession_id AS profession_id_26 , t0 . speciality_id AS speciality_id_27 FROM b_job t0 WHERE t0 . status = 'published' ORDER BY t0 . created_at DESC ;
Copy