Conexión con BBDD existosa!
Información del host: vps02.evotic.es via TCP/IP

Iniciando importacion Ofertas Borsa Treball

SELECT c.nom, c.cognoms, p.poblacio as nom_poblacio, o.* FROM bt_ofertes o left join gen_clients c on c.id=o.client left join gen_poblacions p on p.id=o.poblacio where o.publicar_web='1' AND lloc_treball is not null AND data_publicacio > DATE_SUB(now(), INTERVAL 6 MONTH) ORDER BY o.id DESC
Nº ofertas detectadas: 52
Eliminamos posts existentes...
Posts eliminados: 416 (536900,536899,536898,536897,536894,536893,536890,536889,536886,536885,536882,536881,536878,536877,536874,536873,536870,536869,536866,536865,536862,536861,536858,536857,536854,536853,536850,536849,536846,536845,536842,536840,536838,536837,536834,536833,536830,536828,536826,536824,536822,536820,536818,536816,536814,536812,536810,536808,536806,536804,536802,536800,536798,536796,536794,536792,536790,536789,536786,536785,536782,536781,536778,536777,536774,536773,536770,536769,536766,536765,536762,536761,536758,536757,536754,536753,536750,536748,536746,536744,536742,536740,536738,536736,536734,536731,536729,536727,536725,536723,536721,536719,536717,536715,536713,536711,536709,536707,536705,536703,536701,536699,536697,536695,536896,536895,536892,536891,536888,536887,536884,536883,536880,536879,536876,536875,536872,536871,536868,536867,536864,536863,536860,536859,536856,536855,536852,536851,536848,536847,536844,536843,536841,536839,536836,536835,536832,536831,536829,536827,536825,536823,536821,536819,536817,536815,536813,536811,536809,536807,536805,536803,536801,536799,536797,536795,536793,536791,536788,536787,536784,536783,536780,536779,536776,536775,536772,536771,536768,536767,536764,536763,536760,536759,536756,536755,536752,536751,536749,536747,536745,536743,536741,536739,536737,536735,536733,536732,536730,536728,536726,536724,536722,536720,536718,536716,536714,536712,536710,536708,536706,536704,536702,536700,536698,536696,536694,536693,536692,536691,536690,536689,536688,536687,536686,536685,536684,536683,536682,536681,536680,536679,536678,536677,536676,536675,536674,536673,536672,536671,536670,536669,536668,536667,536666,536665,536664,536663,536662,536661,536660,536659,536658,536657,536656,536655,536654,536653,536652,536651,536650,536649,536648,536647,536646,536645,536644,536643,536642,536641,536640,536639,536638,536637,536636,536635,536634,536633,536632,536631,536630,536629,536628,536627,536626,536625,536624,536623,536622,536621,536620,536619,536618,536617,536616,536615,536614,536613,536612,536611,536610,536609,536608,536607,536606,536605,536604,536603,536602,536601,536600,536599,536598,536597,536596,536595,536594,536593,536592,536591,536590,536589,536588,536587,536586,536585,536584,536583,536582,536581,536580,536579,536578,536577,536576,536575,536574,536573,536572,536571,536570,536569,536568,536567,536566,536565,536564,536563,536562,536561,536560,536559,536558,536557,536556,536555,536554,536553,536552,536551,536550,536549,536548,536547,536546,536545,536544,536543,536542,536541,536540,536539,536538,536537,536536,536535,536534,536533,536532,536531,536530,536529,536528,536527,536526,536525,536524,536523,536522,536521,536520,536519,536518,536517,536516,536515,536514,536513,536512,536511,536510,536509,536508,536507,536506,536505,536504,536503,536502,536501,536500,536499,536498,536497,536496,536495,536494,536493,536492,536491,536490,536489,536488,536487,536486,536485,)

Montamos array de ofertas...

Oferta 207: Tècnic/a de RRHH
Datetime publi: 1721088000
Datetime final: 1721952000 - Return: 2024-07-26
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 206: Mossos/es-Carretoners/es pel sector del transport
Datetime publi: 1721088000
Datetime final: 1721952000 - Return: 2024-07-26
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 205: REPARTIDOR DE PAQUETERÍA
Datetime publi: 1721001600
Datetime final: 1720742400 - Return: 2024-07-12
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 204: Conductor
Datetime publi: 1720742400
Datetime final: 1720742400 - Return: 2024-07-12
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 203: Assessor/a Comercial Administratiu - RACC
Datetime publi: 1720396800
Datetime final: 1721952000 - Return: 2024-07-26
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 202: Auxiliar Administratiu
Datetime publi: 1719187200
Datetime final: 1719360000 - Return: 2024-06-26
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 201: Persona Responsable d'Instal·lacions
Datetime publi: 1718928000
Datetime final: 1721952000 - Return: 2024-07-26
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 200: Frigorista
Datetime publi: 1718928000
Datetime final: 1721952000 - Return: 2024-07-26
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 199: Operari/a de neteja
Datetime publi: 1712880000
Datetime final: 1716508800 - Return: 2024-05-24
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 198: Administratiu de RRHH
Datetime publi: 1718841600
Datetime final: 1720051200 - Return: 2024-07-04
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 197: Operari/a de neteja
Datetime publi: 1714608000
Datetime final: 1719273600 - Return: 2024-06-25
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 196: RECEPCIONISTA TELEFONISTA
Datetime publi: 1713916800
Datetime final: 1716595200 - Return: 2024-05-25
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 195: NETEJADOR/A APARTAMENTS BARCELONA
Datetime publi: 1717718400
Datetime final: 1719705600 - Return: 2024-06-30
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 194: Operari/a de neteja
Datetime publi: 1712620800
Datetime final: 1714867200 - Return: 2024-05-05
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 193: Operari/a de neteja
Datetime publi: 1712620800
Datetime final: 1714867200 - Return: 2024-05-05
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 192: Dependenta de forn i cafeteria
Datetime publi: 1713916800
Datetime final: 1715472000 - Return: 2024-05-12
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 190: Repartidor zona barcelona
Datetime publi: 1715817600
Datetime final: 1718064000 - Return: 2024-06-11
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 189: Auxiliar administratiu/va comptable
Datetime publi: 1718323200
Datetime final: 1720483200 - Return: 2024-07-09
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 188: Encarregat/da de Botiga
Datetime publi: 1717545600
Datetime final: 1721952000 - Return: 2024-07-26
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 187: Tècnic/a Informàtic/a
Datetime publi: 1717113600
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 186: Administratiu/va Laboral - Zona Franca
Datetime publi: 1717113600
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 185: Adminstratiu/va D'obra
Datetime publi: 1716422400
Datetime final: 1720483200 - Return: 2024-07-09
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 184: Gestor de cartera IT
Datetime publi: 1716336000
Datetime final: 1721952000 - Return: 2024-07-26
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 183: Personal de sala i cambrers/es
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 182: Atenció al públic
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 181: Frega plats
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 180: Ajudants de cuina
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 179: Backliners
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 178: Cuiners/es
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 177: Toreros
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 176: Mossos/es de càrrega i descàrrega
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 175: Muntadors/es
Datetime publi: 1715558400
Datetime final: 1718323200 - Return: 2024-06-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 174: Teleoperador/a d'Assegurances
Datetime publi: 1715299200
Datetime final: 1719532800 - Return: 2024-06-28
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 173: Recepcionista
Datetime publi: 1715212800
Datetime final: 1717372800 - Return: 2024-06-03
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 172: Recepcionista per Centre de Psicología
Datetime publi: 1713916800
Datetime final: 1717545600 - Return: 2024-06-05
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 171: Auxiliar Administratiu/va per empresa de logística
Datetime publi: 1713312000
Datetime final: 1714780800 - Return: 2024-05-04
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 170: Auxiliar Administratiu/va per empresa de logística
Datetime publi: 1713312000
Datetime final: 1714780800 - Return: 2024-05-04
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 169: Agent Comercial Immobiliari
Datetime publi: 1712275200
Datetime final: 1717113600 - Return: 2024-05-31
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 168: Administratiu/va per asessoria
Datetime publi: 1711065600
Datetime final: 1712880000 - Return: 2024-04-12
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 167: Auxiliar administrativa / secretària
Datetime publi: 1710460800
Datetime final: 1711152000 - Return: 2024-03-23
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 166: Administratiu/va comptable
Datetime publi: 1709856000
Datetime final: 1711152000 - Return: 2024-03-23
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 165: AUXILIAR TÈCNIC/A DE FORMACIÓ.
Datetime publi: 1709683200
Datetime final: 1711065600 - Return: 2024-03-22
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 164: Auxiliar Administratiu/va pel departament comptable
Datetime publi: 1709251200
Datetime final: 1711152000 - Return: 2024-03-23
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 163: Auxiliar administratiu/va, atenció al client & màrqueting i publicitat
Datetime publi: 1707350400
Datetime final: 1709683200 - Return: 2024-03-06
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 162: Auxiliar Administratiu/va amb Coneixements de PRL
Datetime publi: 1706572800
Datetime final: 1707868800 - Return: 2024-02-14
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 161: Tècnics de so i llums
Datetime publi: 1706572800
Datetime final: 1734652800 - Return: 2024-12-20
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 160: Atenció al públic
Datetime publi: 1706572800
Datetime final: 1734652800 - Return: 2024-12-20
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 159: Operaris de muntatge
Datetime publi: 1706572800
Datetime final: 1734652800 - Return: 2024-12-20
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 158: Conductors per esdeveniments
Datetime publi: 1706572800
Datetime final: 1734652800 - Return: 2024-12-20
Datetime Now: 1721260800
Tipo oferta: Activa

Oferta 157: Responsable del Departament Laboral
Datetime publi: 1706572800
Datetime final: 1707955200 - Return: 2024-02-15
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 156: Comptable i customer service
Datetime publi: 1706140800
Datetime final: 1707955200 - Return: 2024-02-15
Datetime Now: 1721260800
Tipo oferta: INActiva

Oferta 155: Secretària/administrativa
Datetime publi: 1706054400
Datetime final: 1711065600 - Return: 2024-03-22
Datetime Now: 1721260800
Tipo oferta: INActiva

Insertamos posts de ofertas...

-Creadas entradas Array ( [original] => 536902 [translation] => 536903 ) (oferta-207)
-Creadas entradas Array ( [original] => 536906 [translation] => 536908 ) (oferta-206)
-Creadas entradas Array ( [original] => 536910 [translation] => 536912 ) (oferta-205)
-Creadas entradas Array ( [original] => 536914 [translation] => 536916 ) (oferta-204)
-Creadas entradas Array ( [original] => 536918 [translation] => 536920 ) (oferta-203)
-Creadas entradas Array ( [original] => 536922 [translation] => 536924 ) (oferta-202)
-Creadas entradas Array ( [original] => 536926 [translation] => 536928 ) (oferta-201)
-Creadas entradas Array ( [original] => 536930 [translation] => 536932 ) (oferta-200)
-Creadas entradas Array ( [original] => 536934 [translation] => 536936 ) (oferta-199)
-Creadas entradas Array ( [original] => 536938 [translation] => 536940 ) (oferta-198)
-Creadas entradas Array ( [original] => 536942 [translation] => 536944 ) (oferta-197)
-Creadas entradas Array ( [original] => 536946 [translation] => 536948 ) (oferta-196)
-Creadas entradas Array ( [original] => 536950 [translation] => 536952 ) (oferta-195)
-Creadas entradas Array ( [original] => 536954 [translation] => 536956 ) (oferta-194)
-Creadas entradas Array ( [original] => 536958 [translation] => 536960 ) (oferta-193)
-Creadas entradas Array ( [original] => 536962 [translation] => 536964 ) (oferta-192)
-Creadas entradas Array ( [original] => 536967 [translation] => 536968 ) (oferta-190)
-Creadas entradas Array ( [original] => 536971 [translation] => 536972 ) (oferta-189)
-Creadas entradas Array ( [original] => 536975 [translation] => 536976 ) (oferta-188)
-Creadas entradas Array ( [original] => 536979 [translation] => 536980 ) (oferta-187)
-Creadas entradas Array ( [original] => 536983 [translation] => 536984 ) (oferta-186)
-Creadas entradas Array ( [original] => 536987 [translation] => 536988 ) (oferta-185)
-Creadas entradas Array ( [original] => 536991 [translation] => 536992 ) (oferta-184)
-Creadas entradas Array ( [original] => 536995 [translation] => 536996 ) (oferta-183)
-Creadas entradas Array ( [original] => 536999 [translation] => 537000 ) (oferta-182)
-Creadas entradas Array ( [original] => 537003 [translation] => 537004 ) (oferta-181)
-Creadas entradas Array ( [original] => 537007 [translation] => 537008 ) (oferta-180)
-Creadas entradas Array ( [original] => 537011 [translation] => 537012 ) (oferta-179)
-Creadas entradas Array ( [original] => 537015 [translation] => 537016 ) (oferta-178)
-Creadas entradas Array ( [original] => 537019 [translation] => 537020 ) (oferta-177)
-Creadas entradas Array ( [original] => 537023 [translation] => 537024 ) (oferta-176)
-Creadas entradas Array ( [original] => 537027 [translation] => 537028 ) (oferta-175)
-Creadas entradas Array ( [original] => 537031 [translation] => 537032 ) (oferta-174)
-Creadas entradas Array ( [original] => 537035 [translation] => 537036 ) (oferta-173)
-Creadas entradas Array ( [original] => 537039 [translation] => 537040 ) (oferta-172)
-Creadas entradas Array ( [original] => 537043 [translation] => 537044 ) (oferta-171)
-Creadas entradas Array ( [original] => 537047 [translation] => 537048 ) (oferta-170)
-Creadas entradas Array ( [original] => 537051 [translation] => 537052 ) (oferta-169)
-Creadas entradas Array ( [original] => 537055 [translation] => 537056 ) (oferta-168)
-Creadas entradas Array ( [original] => 537059 [translation] => 537060 ) (oferta-167)
-Creadas entradas Array ( [original] => 537063 [translation] => 537064 ) (oferta-166)
-Creadas entradas Array ( [original] => 537067 [translation] => 537068 ) (oferta-165)
-Creadas entradas Array ( [original] => 537071 [translation] => 537072 ) (oferta-164)
-Creadas entradas Array ( [original] => 537075 [translation] => 537076 ) (oferta-163)
-Creadas entradas Array ( [original] => 537079 [translation] => 537080 ) (oferta-162)
-Creadas entradas Array ( [original] => 537083 [translation] => 537084 ) (oferta-161)
-Creadas entradas Array ( [original] => 537087 [translation] => 537088 ) (oferta-160)
-Creadas entradas Array ( [original] => 537091 [translation] => 537092 ) (oferta-159)
-Creadas entradas Array ( [original] => 537095 [translation] => 537096 ) (oferta-158)
-Creadas entradas Array ( [original] => 537099 [translation] => 537100 ) (oferta-157)
-Creadas entradas Array ( [original] => 537103 [translation] => 537104 ) (oferta-156)
-Creadas entradas Array ( [original] => 537107 [translation] => 537108 ) (oferta-155)

Total ofertas creados: 104, total posts: 104 (536902-536903,536906-536908,536910-536912,536914-536916,536918-536920,536922-536924,536926-536928,536930-536932,536934-536936,536938-536940,536942-536944,536946-536948,536950-536952,536954-536956,536958-536960,536962-536964,536967-536968,536971-536972,536975-536976,536979-536980,536983-536984,536987-536988,536991-536992,536995-536996,536999-537000,537003-537004,537007-537008,537011-537012,537015-537016,537019-537020,537023-537024,537027-537028,537031-537032,537035-537036,537039-537040,537043-537044,537047-537048,537051-537052,537055-537056,537059-537060,537063-537064,537067-537068,537071-537072,537075-537076,537079-537080,537083-537084,537087-537088,537091-537092,537095-537096,537099-537100,537103-537104,537107-537108,)

FIN importación

¿Necesitas ayuda?