- Vous êtes ici :
- Accueil /
- Chercheurs /
- Banque d'emplois /
- Voir toutes les offres
SELECT `jb`.`id` AS `id`,`jb`.`jobid` AS `jobid`,`jb`.`post_date` AS `post_date`,`jb`.`job_title` AS `job_title`,`jb`.`category` AS `category`,`jb`.`industry` AS `industry`,`jb`.`fromsalary` AS `fromsalary`,`jb`.`tosalary` AS `tosalary`,`jb`.`salary` AS `salary`,`jb`.`city` AS `city`,`jb`.`latitude` AS `latitude`,`jb`.`longitude` AS `longitude`,`jb`.`description` AS `description`,`ind`.`frname` AS `indtype`,`cat`.`frname` AS `cattype`,`jb`.`expiry_date` AS `expired`,`jb`.`fulltime` AS `fulltime`,`jb`.`oncall` AS `oncall`,`jb`.`permanent` AS `permanent`,`jb`.`seasonal` AS `seasonal`,`jb`.`department` AS `department`,(SELECT max(`ja`.`id`) FROM `#__jobboard_apply` AS `ja` WHERE `ja`.`jobid` = `jb`.`jobid` AND `ja`.`userid` = "0") AS applied
FROM `#__jobboard_jobs` AS `jb`
INNER JOIN `#__jobboard_industries` AS `ind` ON (`jb`.`industry` = `ind`.`id`)
INNER JOIN `#__jobboard_categories` AS `cat` ON (`jb`.`category` = `cat`.`id`)
WHERE `jb`.`published` = 1 AND `jb`.`lang` = 'fr' AND (`jb`.`expiry_date` >= now() OR NOT `jb`.`expiry_date`)
ORDER BY `jobid` DESC
SELECT `jb`.`id` AS `id`,`jb`.`jobid` AS `jobid`,`jb`.`post_date` AS `post_date`,`jb`.`job_title` AS `job_title`,`jb`.`category` AS `category`,`jb`.`industry` AS `industry`,`jb`.`fromsalary` AS `fromsalary`,`jb`.`tosalary` AS `tosalary`,`jb`.`salary` AS `salary`,`jb`.`city` AS `city`,`jb`.`latitude` AS `latitude`,`jb`.`longitude` AS `longitude`,`jb`.`description` AS `description`,`ind`.`frname` AS `indtype`,`cat`.`frname` AS `cattype`,`jb`.`expiry_date` AS `expired`,`jb`.`fulltime` AS `fulltime`,`jb`.`oncall` AS `oncall`,`jb`.`permanent` AS `permanent`,`jb`.`seasonal` AS `seasonal`,`jb`.`department` AS `department`,(SELECT max(`ja`.`id`) FROM `#__jobboard_apply` AS `ja` WHERE `ja`.`jobid` = `jb`.`jobid` AND `ja`.`userid` = "0") AS applied
FROM `#__jobboard_jobs` AS `jb`
INNER JOIN `#__jobboard_industries` AS `ind` ON (`jb`.`industry` = `ind`.`id`)
INNER JOIN `#__jobboard_categories` AS `cat` ON (`jb`.`category` = `cat`.`id`)
WHERE `jb`.`published` = 1 AND `jb`.`lang` = 'fr' AND (`jb`.`expiry_date` >= now() OR NOT `jb`.`expiry_date`)
ORDER BY `jobid` DESC
Voir toutes les offres
IMPORTANT: Vous devez créer un compte ou y être branché pour pouvoir postuler aux emplois.
object(Joomla\CMS\Input\Input)#19 (4) {
["options":protected]=>
array(0) {
}
["filter":protected]=>
object(Joomla\Filter\InputFilter)#25 (8) {
["tagsArray"]=>
array(0) {
}
["attrArray"]=>
array(0) {
}
["tagsMethod"]=>
int(0)
["attrMethod"]=>
int(0)
["xssAuto"]=>
int(1)
["tagBlacklist"]=>
array(23) {
[0]=>
string(6) "applet"
[1]=>
string(4) "body"
[2]=>
string(7) "bgsound"
[3]=>
string(4) "base"
[4]=>
string(8) "basefont"
[5]=>
string(6) "canvas"
[6]=>
string(5) "embed"
[7]=>
string(5) "frame"
[8]=>
string(8) "frameset"
[9]=>
string(4) "head"
[10]=>
string(4) "html"
[11]=>
string(2) "id"
[12]=>
string(6) "iframe"
[13]=>
string(6) "ilayer"
[14]=>
string(5) "layer"
[15]=>
string(4) "link"
[16]=>
string(4) "meta"
[17]=>
string(4) "name"
[18]=>
string(6) "object"
[19]=>
string(6) "script"
[20]=>
string(5) "style"
[21]=>
string(5) "title"
[22]=>
string(3) "xml"
}
["attrBlacklist"]=>
array(6) {
[0]=>
string(6) "action"
[1]=>
string(10) "background"
[2]=>
string(8) "codebase"
[3]=>
string(6) "dynsrc"
[4]=>
string(10) "formaction"
[5]=>
string(6) "lowsrc"
}
["blockedChars":"Joomla\Filter\InputFilter":private]=>
array(4) {
[0]=>
string(5) "&tab;"
[1]=>
string(7) "&space;"
[2]=>
string(7) ":"
[3]=>
string(8) "&column;"
}
}
["data":protected]=>
&array(6) {
["cmobile"]=>
bool(false)
["language"]=>
string(5) "fr-FR"
["Itemid"]=>
string(3) "139"
["option"]=>
string(12) "com_jobboard"
["lang"]=>
string(5) "fr-FR"
["view"]=>
string(4) "list"
}
["inputs":protected]=>
array(3) {
["cookie"]=>
object(Joomla\CMS\Input\Cookie)#36 (4) {
["options":protected]=>
array(0) {
}
["filter":protected]=>
object(Joomla\CMS\Filter\InputFilter)#20 (9) {
["tagsArray"]=>
array(0) {
}
["attrArray"]=>
array(0) {
}
["tagsMethod"]=>
int(0)
["attrMethod"]=>
int(0)
["xssAuto"]=>
int(1)
["tagBlacklist"]=>
array(23) {
[0]=>
string(6) "applet"
[1]=>
string(4) "body"
[2]=>
string(7) "bgsound"
[3]=>
string(4) "base"
[4]=>
string(8) "basefont"
[5]=>
string(6) "canvas"
[6]=>
string(5) "embed"
[7]=>
string(5) "frame"
[8]=>
string(8) "frameset"
[9]=>
string(4) "head"
[10]=>
string(4) "html"
[11]=>
string(2) "id"
[12]=>
string(6) "iframe"
[13]=>
string(6) "ilayer"
[14]=>
string(5) "layer"
[15]=>
string(4) "link"
[16]=>
string(4) "meta"
[17]=>
string(4) "name"
[18]=>
string(6) "object"
[19]=>
string(6) "script"
[20]=>
string(5) "style"
[21]=>
string(5) "title"
[22]=>
string(3) "xml"
}
["attrBlacklist"]=>
array(6) {
[0]=>
string(6) "action"
[1]=>
string(10) "background"
[2]=>
string(8) "codebase"
[3]=>
string(6) "dynsrc"
[4]=>
string(10) "formaction"
[5]=>
string(6) "lowsrc"
}
["blockedChars":"Joomla\Filter\InputFilter":private]=>
array(4) {
[0]=>
string(5) "&tab;"
[1]=>
string(7) "&space;"
[2]=>
string(7) ":"
[3]=>
string(8) "&column;"
}
["stripUSC"]=>
int(1)
}
["data":protected]=>
&array(0) {
}
["inputs":protected]=>
array(0) {
}
}
["post"]=>
object(Joomla\CMS\Input\Input)#894 (4) {
["options":protected]=>
array(0) {
}
["filter":protected]=>
object(Joomla\Filter\InputFilter)#895 (8) {
["tagsArray"]=>
array(0) {
}
["attrArray"]=>
array(0) {
}
["tagsMethod"]=>
int(0)
["attrMethod"]=>
int(0)
["xssAuto"]=>
int(1)
["tagBlacklist"]=>
array(23) {
[0]=>
string(6) "applet"
[1]=>
string(4) "body"
[2]=>
string(7) "bgsound"
[3]=>
string(4) "base"
[4]=>
string(8) "basefont"
[5]=>
string(6) "canvas"
[6]=>
string(5) "embed"
[7]=>
string(5) "frame"
[8]=>
string(8) "frameset"
[9]=>
string(4) "head"
[10]=>
string(4) "html"
[11]=>
string(2) "id"
[12]=>
string(6) "iframe"
[13]=>
string(6) "ilayer"
[14]=>
string(5) "layer"
[15]=>
string(4) "link"
[16]=>
string(4) "meta"
[17]=>
string(4) "name"
[18]=>
string(6) "object"
[19]=>
string(6) "script"
[20]=>
string(5) "style"
[21]=>
string(5) "title"
[22]=>
string(3) "xml"
}
["attrBlacklist"]=>
array(6) {
[0]=>
string(6) "action"
[1]=>
string(10) "background"
[2]=>
string(8) "codebase"
[3]=>
string(6) "dynsrc"
[4]=>
string(10) "formaction"
[5]=>
string(6) "lowsrc"
}
["blockedChars":"Joomla\Filter\InputFilter":private]=>
array(4) {
[0]=>
string(5) "&tab;"
[1]=>
string(7) "&space;"
[2]=>
string(7) ":"
[3]=>
string(8) "&column;"
}
}
["data":protected]=>
array(0) {
}
["inputs":protected]=>
array(0) {
}
}
["files"]=>
object(Joomla\CMS\Input\Files)#1072 (5) {
["options":protected]=>
array(0) {
}
["filter":protected]=>
object(Joomla\CMS\Filter\InputFilter)#20 (9) {
["tagsArray"]=>
array(0) {
}
["attrArray"]=>
array(0) {
}
["tagsMethod"]=>
int(0)
["attrMethod"]=>
int(0)
["xssAuto"]=>
int(1)
["tagBlacklist"]=>
array(23) {
[0]=>
string(6) "applet"
[1]=>
string(4) "body"
[2]=>
string(7) "bgsound"
[3]=>
string(4) "base"
[4]=>
string(8) "basefont"
[5]=>
string(6) "canvas"
[6]=>
string(5) "embed"
[7]=>
string(5) "frame"
[8]=>
string(8) "frameset"
[9]=>
string(4) "head"
[10]=>
string(4) "html"
[11]=>
string(2) "id"
[12]=>
string(6) "iframe"
[13]=>
string(6) "ilayer"
[14]=>
string(5) "layer"
[15]=>
string(4) "link"
[16]=>
string(4) "meta"
[17]=>
string(4) "name"
[18]=>
string(6) "object"
[19]=>
string(6) "script"
[20]=>
string(5) "style"
[21]=>
string(5) "title"
[22]=>
string(3) "xml"
}
["attrBlacklist"]=>
array(6) {
[0]=>
string(6) "action"
[1]=>
string(10) "background"
[2]=>
string(8) "codebase"
[3]=>
string(6) "dynsrc"
[4]=>
string(10) "formaction"
[5]=>
string(6) "lowsrc"
}
["blockedChars":"Joomla\Filter\InputFilter":private]=>
array(4) {
[0]=>
string(5) "&tab;"
[1]=>
string(7) "&space;"
[2]=>
string(7) ":"
[3]=>
string(8) "&column;"
}
["stripUSC"]=>
int(1)
}
["data":protected]=>
&array(0) {
}
["inputs":protected]=>
array(0) {
}
["decodedData":protected]=>
array(0) {
}
}
}
}