1643839494
a:2:{s:4:"name";a:189:{s:32:"d10591b7e59d5bf993ade162447c2a8c";s:16:"`global_partner`";s:32:"f94a437fb7858e092079378f93ef2c71";s:7:"`users`";s:32:"84aed5ca7734df237971a8964bd0217a";s:11:"`User`.`id`";s:32:"3c5ca42a5b59887e1d335e3ff06444b5";s:15:"`User`.`perfil`";s:32:"5ff4654e0897a864cdd3d18b71696251";s:21:"`User`.`nome_empresa`";s:32:"4ae9c61e83cc738999481f43409c109d";s:22:"`User`.`nome_contacto`";s:32:"97c268dcd8412cd254419ed9b5f0d32e";s:14:"`User`.`email`";s:32:"46bea0d8cb0ffa1c5c7f63ad1e39035b";s:17:"`User`.`password`";s:32:"04d39a45ab63e9817d319616287574e9";s:17:"`User`.`telefone`";s:32:"6e87b3657f8c3a2eda203f4848a8e261";s:18:"`User`.`telemovel`";s:32:"a27a8e82b7d65f4948cd9f1aedab77c4";s:16:"`User`.`pais_id`";s:32:"ac507f5b498f978466507fadbcd270a3";s:15:"`User`.`estado`";s:32:"06537842879ac5982544dec78ede2107";s:20:"`User`.`data_estado`";s:32:"a8c3d247a9dcfde72b56370c8ec25863";s:21:"`User`.`data_criacao`";s:32:"40cf18e942a7ecbe2bea427ba7ae2d28";s:17:"`User`.`data_act`";s:32:"11976275b5dd411fd192641fe4acd77f";s:8:"`paises`";s:32:"e78e4c58f3051a1efcec4df6c0ac923e";s:11:"`Pais`.`id`";s:32:"96acfbc295faf54a4db942c00d82972a";s:13:"`Pais`.`nome`";s:32:"39fcfbd267502fafd513e81e79594643";s:12:"`Pais`.`iso`";s:32:"8744ae18b9b4038dd3b91b1af38230fa";s:21:"`Pais`.`data_criacao`";s:32:"0367d6edb56c769573522aa0819ac7d2";s:17:"`Pais`.`data_act`";s:32:"256981c848e67bfc6400d9cff905b052";s:6:"`Pais`";s:32:"eb9b37fa6fe3e5c49f921ddcd721b306";s:6:"`User`";s:32:"18bc017f5d4a5350f1d23e242a48c336";s:14:"`Servico`.`id`";s:32:"8670bf26bed8fada1b5f1b38dfb5cc14";s:16:"`Servico`.`nome`";s:32:"da933981efc34f152e23f3a8919f5121";s:10:"`servicos`";s:32:"77be93055bdebaf8cbd7b4aaddc9975d";s:9:"`Servico`";s:32:"47eb7bb09414c64f779510914712b6ee";s:7:"`count`";s:32:"b68ba03032c9075b10a5ab1f77e18f0d";s:19:"`parceirosservicos`";s:32:"63ebaa01e256e02d6d3c4381feffc918";s:23:"`Parceirosservico`.`id`";s:32:"802ab1dd2278384a6428a267ecdd64fb";s:28:"`Parceirosservico`.`user_id`";s:32:"51ae1339d7e43360c6f034d927952606";s:31:"`Parceirosservico`.`servico_id`";s:32:"a83d68c41dcc1a80a2ecec3db34c2e63";s:28:"`Parceirosservico`.`visivel`";s:32:"0de32a91f81e8beac56bc3ab58aa7672";s:33:"`Parceirosservico`.`data_criacao`";s:32:"0e1018892c9132cbb94e34be9318912e";s:29:"`Parceirosservico`.`data_act`";s:32:"cddb2b7abb147530c80e69b4e06ea0af";s:18:"`Parceirosservico`";s:32:"d15be0d179188d0d02ca6757a5600404";s:24:"`Servico`.`data_criacao`";s:32:"324b23562efffbcf1470a26e835e1941";s:20:"`Servico`.`data_act`";s:32:"6302728cefbb860ac8cabcb76deba4d1";s:20:"`Parceirosarea`.`id`";s:32:"aa1309035a29bc51e4c4bc0df2c30c48";s:24:"`Parceirosarea`.`cidade`";s:32:"e8576376dc70661e73a8d2103edc0338";s:37:"`Parceirosarea`.`parceirosservico_id`";s:32:"03de26d6b1f559f0e99603438eaaf54d";s:16:"`parceirosareas`";s:32:"e4c8f1a2ea396fcea91e39f5420bc637";s:15:"`Parceirosarea`";s:32:"4e3d03162d7769345a45dd0289b6ec58";s:25:"`Parceirosarea`.`area_id`";s:32:"244b7296121c3080b62759b4714a2de3";s:30:"`Parceirosarea`.`data_criacao`";s:32:"3529164c48621185bb62b76266419044";s:12:"`relocation`";s:32:"f1127d0196622e6d8e37f04e42e100e9";s:17:"`Relocation`.`id`";s:32:"967ac1c2e12b7a7a63eace22bfc973a9";s:34:"`Relocation`.`parceirosservico_id`";s:32:"053688c39cbb125c1317dad02e585f86";s:28:"`Relocation`.`nome_supplier`";s:32:"d6a9204be85692688afe9e4ee069b327";s:28:"`Relocation`.`nome_contacto`";s:32:"3c8a46dbe846a137c756716dd7ecbd14";s:20:"`Relocation`.`email`";s:32:"3df6abcf4e42a3389c856ac5c63f910e";s:23:"`Relocation`.`telefone`";s:32:"3b2fc783f89dac594093b3864f250a6e";s:22:"`Relocation`.`pais_id`";s:32:"23a2cbbeb82217451a277df8f0b27dae";s:21:"`Relocation`.`cidade`";s:32:"7418aa52a1b34bbd806f813e25d7efff";s:28:"`Relocation`.`data_validade`";s:32:"27cb7e63ecdeefdeeb271799e6b1f5e8";s:25:"`Relocation`.`em_criacao`";s:32:"3ab1725d0678ec29f896cbb4f83a6ef9";s:23:"`Relocation`.`editavel`";s:32:"ca5eef21a0acfcdc9a87730d262e53a2";s:27:"`Relocation`.`data_criacao`";s:32:"5d7aca352d0eab9daec8cb4013695517";s:23:"`Relocation`.`data_act`";s:32:"666bbc0188e71310c4d2fc42b752c373";s:12:"`Relocation`";s:32:"d5c2f8665a206a6236df456d9bc41bed";s:13:"`immigration`";s:32:"afd25eced534a8849649dd0ca1c06078";s:18:"`Immigration`.`id`";s:32:"acf38aa216eb09e99173c6237c8834f3";s:35:"`Immigration`.`parceirosservico_id`";s:32:"dd149b7d004d6581c6e434c3769d864c";s:29:"`Immigration`.`nome_supplier`";s:32:"b793457a3021d473d8b5423e84f038a4";s:29:"`Immigration`.`nome_contacto`";s:32:"7b5bdf2f0d54d4c7da56e888433cf368";s:21:"`Immigration`.`email`";s:32:"3e51366d2d38862a0e09555ce1780ff1";s:24:"`Immigration`.`telefone`";s:32:"ebcb8e4aff469e67cd4336b1b29b80cf";s:23:"`Immigration`.`pais_id`";s:32:"b054d90300ce71e2b07c7b5e0b0d4ef7";s:22:"`Immigration`.`cidade`";s:32:"8ae9620591125d88d7925652c956ba63";s:29:"`Immigration`.`data_validade`";s:32:"352cc14cdebf683ec6fd517bb5718822";s:26:"`Immigration`.`em_criacao`";s:32:"56041b39059cee0eee72dcb0edc076b9";s:24:"`Immigration`.`editavel`";s:32:"ae43651a2ac2582398463ed62178f95c";s:28:"`Immigration`.`data_criacao`";s:32:"811bfae6f0840750a318ef4847ce373e";s:24:"`Immigration`.`data_act`";s:32:"bf307c65a2271174fc77765208d4b022";s:13:"`Immigration`";s:32:"b7664b48e1ed06a9dc42caa2c717d4c1";s:13:"`Area`.`nome`";s:32:"18c4a8d87a0e40551d5c017fa4eb4b86";s:14:"`Area`.`class`";s:32:"c0019ec71a0d47c0c7ed15f3354a9c5c";s:11:"`Area`.`id`";s:32:"ed71f804a0247a00ce352dfae9a39fd8";s:6:"`Area`";s:32:"e74888de95ef756d379ce360e25efeab";s:7:"`areas`";s:32:"e4547f92e59272c4f84eeed6f53510df";s:21:"`Area`.`data_criacao`";s:32:"b6bdeafa82ec3b59595482bf27ebeda7";s:17:"`Area`.`data_act`";s:32:"b090d3718df010eed6f73bffe8377c81";s:23:"`Parceirosarea`.`moeda`";s:32:"2fc755ded68e792db39cc74254b05ccb";s:31:"`Parceirosarea`.`data_validade`";s:32:"163c48fc54b6454e6849e809d43acbff";s:28:"`Parceirosarea`.`em_criacao`";s:32:"c0d0e7905b3566415f31825b2c36aff9";s:26:"`Parceirosarea`.`editavel`";s:32:"506b08434c52d9d3b1951c989823e0a6";s:26:"`Parceirosarea`.`data_act`";s:32:"b7c4aa520236471549439ebba2b645ce";s:9:"`tarifas`";s:32:"3f367d01532b99f8e047b0a3c2f08935";s:13:"`Tarifa`.`id`";s:32:"40a29ff95e59334f75bb72e820012619";s:27:"`Tarifa`.`parceirosarea_id`";s:32:"ab8e6512a9c9ebc6c8cd5c7e73114fc5";s:21:"`Tarifa`.`solucao_id`";s:32:"e8e2ae204dc7ac84186aa73472a4fdc8";s:25:"`Tarifa`.`tarifastipo_id`";s:32:"abd9b977e7a05880f86ad5afa3ad8385";s:23:"`Tarifa`.`data_criacao`";s:32:"3c79e4ff223c104001ed64378e8c3766";s:19:"`Tarifa`.`data_act`";s:32:"8cac052a39d8afaf1156f6af494abdfe";s:8:"`Tarifa`";s:32:"546c4241f087fe7cea3049f73a3ce5a5";s:10:"`solucoes`";s:32:"57d19720763edb7a47f60d3bd093031c";s:14:"`Solucao`.`id`";s:32:"ac2cd9903ced6ecac3bf5aeac63438f1";s:19:"`Solucao`.`area_id`";s:32:"1daf9cabff1e394117a42ad49496cf2e";s:16:"`Solucao`.`nome`";s:32:"ed47673773c088ff29c64163d2c28562";s:26:"`Solucao`.`tarifastipo_id`";s:32:"2832f54efa59590d0476f3142ef6d40d";s:24:"`Solucao`.`data_criacao`";s:32:"dac3f772012e37505694f6d8cce8a2bb";s:20:"`Solucao`.`data_act`";s:32:"74482a7f5be84851fa061bbeaa78690f";s:9:"`Solucao`";s:32:"fecdb6f7203a81afc9c9fb10c355f0f2";s:14:"`tarifastipos`";s:32:"40fcb16ca2f4fe5e4e610f6ab0385997";s:18:"`Tarifastipo`.`id`";s:32:"090c4d41ec4edd9d545b1979fdcbfa7a";s:20:"`Tarifastipo`.`nome`";s:32:"4799ca08534ffa09c1c49916ba16edb3";s:28:"`Tarifastipo`.`data_criacao`";s:32:"81d7c238f88f3a2236f8fb630a3e928f";s:24:"`Tarifastipo`.`data_act`";s:32:"84dac8d1f543e0633e80cc1163dd6494";s:13:"`Tarifastipo`";s:32:"c32f7ca60d56c5df12654c3012dbba7e";s:14:"`tarifalinhas`";s:32:"ddcdf35646fcb45b34f717f1ffe2b35e";s:18:"`Tarifalinha`.`id`";s:32:"b8000621746a64fb66a17483402603bb";s:25:"`Tarifalinha`.`tarifa_id`";s:32:"ed8c284c20a954f72f3aa8b9468a32fa";s:34:"`Tarifalinha`.`tarifalinhatipo_id`";s:32:"50c84f71cc909ede21cd00bb703a6489";s:25:"`Tarifalinha`.`descricao`";s:32:"2dcb349ded198ddf34059d92326f6961";s:21:"`Tarifalinha`.`preco`";s:32:"be9d08ca7a5f7ceb302b33b1ca6a4276";s:28:"`Tarifalinha`.`data_criacao`";s:32:"f1129515b9841643301a867f889305ec";s:24:"`Tarifalinha`.`data_act`";s:32:"2590743516e503a8a035ab661f5f2c11";s:13:"`Tarifalinha`";s:32:"a6f5f6e1bc1079b1f5261e3f8dcee390";s:18:"`tarifalinhatipos`";s:32:"ea60f5b68588ce4cd5261f046fcd3fcf";s:22:"`Tarifalinhatipo`.`id`";s:32:"ad1226eb92b908809f00ff2ba623372a";s:27:"`Tarifalinhatipo`.`area_id`";s:32:"07d6c89903256e251201c53051669718";s:24:"`Tarifalinhatipo`.`nome`";s:32:"805e367a82a408408f2b0265dc5a4c06";s:32:"`Tarifalinhatipo`.`data_criacao`";s:32:"d21c58ab933aeca5e2830c5909d14dff";s:28:"`Tarifalinhatipo`.`data_act`";s:32:"ff24eb3ff817ee1260862ea7c481d977";s:17:"`Tarifalinhatipo`";s:32:"d90f7ab9651bd1af7ba4118470043959";s:17:"`Conteudo`.`nome`";s:32:"99679348f8f6f76701e3019c92a60318";s:18:"`Conteudo`.`texto`";s:32:"828e81252b5fdf2ae25651f7b88c0e72";s:11:"`conteudos`";s:32:"63b05fee34e7ca7ad50e1f76b969614a";s:10:"`Conteudo`";s:32:"dd432a89d2c233896f367b9b25da22a6";s:8:"`estado`";s:32:"676a6149947d770c73db15cccee94eaf";s:14:"`nome_empresa`";s:32:"af1bea8a87ad5482efbcd312751539e9";s:15:"`nome_contacto`";s:32:"ae1bde34794270bb273f407db5974619";s:7:"`email`";s:32:"a50bc84f241def9d508a632c17edf28a";s:10:"`telefone`";s:32:"09812609f983d5cbdbed890424eb1542";s:11:"`telemovel`";s:32:"c0714f12bd2b2ae31d446c372bc39a32";s:9:"`pais_id`";s:32:"50b70521794e6cfc15d6ea8cd49d94c5";s:8:"`perfil`";s:32:"b94f3b3654aa69057553967f608a4bcb";s:13:"`data_estado`";s:32:"14d584ef051ff190f80a7211cc949380";s:14:"`data_criacao`";s:32:"0d2b3e244981ac4410e785e665b9b056";s:9:"`visivel`";s:32:"322115c6be8b9535c3319bd4f238f540";s:9:"`user_id`";s:32:"cb26697f4fd0570a4f672ae1b9238f6d";s:12:"`servico_id`";s:32:"90a4dcfb4fe005e9138e624e054c92a7";s:20:"`Conteudosarea`.`id`";s:32:"d17b80ca96a49df75aa21b61cd0f7ecb";s:22:"`Conteudosarea`.`nome`";s:32:"f65a75688f9a8ed9b59649c6b1fb0fe4";s:16:"`conteudosareas`";s:32:"1007d839198a2d5520b3138e5af00132";s:15:"`Conteudosarea`";s:32:"46cf7fa2e7c13647c6d6756fae95ff94";s:15:"`Conteudo`.`id`";s:32:"1fc68cb7e02022261a7d2d3d69ec84ab";s:29:"`Conteudo`.`conteudosarea_id`";s:32:"8716fcf8faeb3a0ad020328c3b93a903";s:22:"`Conteudo`.`descricao`";s:32:"915f7aa0fb5eab81efb736e3be5505c7";s:25:"`Conteudo`.`data_criacao`";s:32:"3547482c3ff83284dd46cd8d9eebbaf3";s:21:"`Conteudo`.`data_act`";s:32:"4bed764cca823804a128f12e0f78df65";s:30:"`Conteudosarea`.`data_criacao`";s:32:"3f60c1123c84bee5bfd54647a1faa33f";s:26:"`Conteudosarea`.`data_act`";s:32:"d2c23d1b4feeec456d72cdc94cc44595";s:4:"`id`";s:32:"e5910703ba2031a124cc00aa87ffa62e";s:10:"`data_act`";s:32:"e952cb545601dc59bce364f420499ae5";s:41:"`global_partner`.`parceirosservicos`.`id`";s:32:"2310a4f52ef2d485e5784d8f93cded3f";s:29:"`global_partner`.`users`.`id`";s:32:"6aa91a7fbb8c9edcf4aa5f9411aec19c";s:10:"`password`";s:32:"8814b49aae9ea6152f817b88acc2e918";s:8:"'Active'";s:32:"28fdbabd9f3e66c486d569e2ae7dd8f6";s:7:"'%178%'";s:32:"71571ade7862db67be35ebd337c3a429";s:14:"`ps`.`user_id`";s:32:"4f0f0f179f22027898af8740854451a5";s:17:"`ps`.`servico_id`";s:32:"5543e3b8bbf0786a08c960185950355e";s:12:"`em_criacao`";s:32:"f34034e79d3b7b009f4c2dd46bfc0b3a";s:10:"`editavel`";s:32:"f10f4b9fc031c921692fbd57fb4296c7";s:21:"`parceirosservico_id`";s:32:"57a059ef044bb6cc606fd2f61414d7db";s:9:"`area_id`";s:32:"0a15d6f5c83ca26105ecb54763af90a6";s:8:"`cidade`";s:32:"b9353c6c40a0aba81264ab6656ef1544";s:7:"`moeda`";s:32:"d2bf1575013b4706ac38c79ea33097bc";s:15:"`data_validade`";s:32:"165f9094824d91aca67a669049274d20";s:18:"`parceirosarea_id`";s:32:"e8d424131841ef6aaefcbc3379d1084a";s:12:"`solucao_id`";s:32:"1f59894a3b9aea678041aa3899c9c62c";s:16:"`tarifastipo_id`";s:32:"89b7fcc5e25952c387681c9d4d81ced4";s:18:"`solucoestamanhos`";s:32:"586b327b893c5d4190b9d110bcfc7cec";s:22:"`Solucoestamanho`.`id`";s:32:"d5c71fda48d30d79ad0fb085646e14b3";s:30:"`Solucoestamanho`.`solucao_id`";s:32:"739e44356d41aeedd6d872b80f03e08d";s:24:"`Solucoestamanho`.`nome`";s:32:"5cf8210076145c1a8c64c998dc0aab1c";s:32:"`Solucoestamanho`.`data_criacao`";s:32:"580b8ba5c15088ef92ff5248fadbb4bf";s:28:"`Solucoestamanho`.`data_act`";s:32:"082b4bf9a17da814afb347d5f3611eb1";s:17:"`Solucoestamanho`";s:32:"1048ade74dc4a6d5367e3d6550d49e1d";s:7:"`preco`";s:32:"b0e46a36554652646013fc583d946178";s:11:"`tarifa_id`";s:32:"bbbc98ef0d32351411db1afa36443dc2";s:11:"`descricao`";s:32:"72f81552c3c9b0cf8830daf91dc68cbc";s:20:"`tarifalinhatipo_id`";s:32:"583cd34daf4a1a1064f753fa47ee8f1f";s:36:"`global_partner`.`tarifalinhas`.`id`";s:32:"99582d07cd50591f41a9130bcb8e54c9";s:38:"`global_partner`.`parceirosareas`.`id`";s:32:"6570e63ab8919e1b6e852dddcdadda5f";s:6:"`nome`";s:32:"553edd9254d3bee9f911fce603875cdd";s:7:"`texto`";s:32:"e79d11cfd25a60b2a623010b4501f218";s:33:"`global_partner`.`conteudos`.`id`";s:32:"9211cc0e091e5a3e7f91404032d01999";s:9:"'Pending'";}s:6:"fields";a:66:{s:32:"ac2ece4ee712d62dbc54fe2605eba703";a:13:{i:0;s:11:"`User`.`id`";i:1;s:15:"`User`.`perfil`";i:2;s:21:"`User`.`nome_empresa`";i:3;s:22:"`User`.`nome_contacto`";i:4;s:14:"`User`.`email`";i:5;s:17:"`User`.`password`";i:6;s:17:"`User`.`telefone`";i:7;s:18:"`User`.`telemovel`";i:8;s:16:"`User`.`pais_id`";i:9;s:15:"`User`.`estado`";i:10;s:20:"`User`.`data_estado`";i:11;s:21:"`User`.`data_criacao`";i:12;s:17:"`User`.`data_act`";}s:32:"cd1a46b29e00ae3f0e03d46e060d4e06";a:1:{i:0;s:11:"`User`.`id`";}s:32:"ce8453524360622babccbd92f1eb7214";a:5:{i:0;s:11:"`Pais`.`id`";i:1;s:13:"`Pais`.`nome`";i:2;s:12:"`Pais`.`iso`";i:3;s:21:"`Pais`.`data_criacao`";i:4;s:17:"`Pais`.`data_act`";}s:32:"5f7efcd49f65f9a22db6fc6aebd94705";a:2:{i:0;s:14:"`Servico`.`id`";i:1;s:16:"`Servico`.`nome`";}s:32:"c4e3d3c2926b61b3a9d7fda53f87dfa0";a:2:{i:0;s:11:"`Pais`.`id`";i:1;s:13:"`Pais`.`nome`";}s:32:"ce79d0d5fb343861e19dbd61e9067c25";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"1d65fd001dae2810291b5cf89220a457";a:6:{i:0;s:23:"`Parceirosservico`.`id`";i:1;s:28:"`Parceirosservico`.`user_id`";i:2;s:31:"`Parceirosservico`.`servico_id`";i:3;s:28:"`Parceirosservico`.`visivel`";i:4;s:33:"`Parceirosservico`.`data_criacao`";i:5;s:29:"`Parceirosservico`.`data_act`";}s:32:"9c6855f2d2e37887b88c2aefff86b69b";a:1:{i:0;s:28:"`Parceirosservico`.`user_id`";}s:32:"9a5577ee66f9a5ecee0050fd3ee4b2a3";a:6:{i:0;s:23:"`Parceirosservico`.`id`";i:1;s:28:"`Parceirosservico`.`user_id`";i:2;s:31:"`Parceirosservico`.`servico_id`";i:3;s:28:"`Parceirosservico`.`visivel`";i:4;s:33:"`Parceirosservico`.`data_criacao`";i:5;s:29:"`Parceirosservico`.`data_act`";}s:32:"b35561d61ca49198092f6f5aa8d20609";a:1:{i:0;s:23:"`Parceirosservico`.`id`";}s:32:"add146616d2ef2e7d58cf77b27e63059";a:4:{i:0;s:14:"`Servico`.`id`";i:1;s:16:"`Servico`.`nome`";i:2;s:24:"`Servico`.`data_criacao`";i:3;s:20:"`Servico`.`data_act`";}s:32:"58f822e0375160e0b4dcdac6324e4ab9";a:3:{i:0;s:20:"`Parceirosarea`.`id`";i:1;s:24:"`Parceirosarea`.`cidade`";i:2;s:37:"`Parceirosarea`.`parceirosservico_id`";}s:32:"bce08021cb09bf73af9435bf14c7b9b8";a:1:{i:0;s:37:"`Parceirosarea`.`parceirosservico_id`";}s:32:"4b57072196de30241cefd934e2fe038f";a:4:{i:0;s:14:"`Servico`.`id`";i:1;s:16:"`Servico`.`nome`";i:2;s:24:"`Servico`.`data_criacao`";i:3;s:20:"`Servico`.`data_act`";}s:32:"fbfda5bcbf008f9a593f0deb778b28f7";a:3:{i:0;s:20:"`Parceirosarea`.`id`";i:1;s:24:"`Parceirosarea`.`cidade`";i:2;s:37:"`Parceirosarea`.`parceirosservico_id`";}s:32:"d18727f031132d7c33cd74d8f85d7f58";a:1:{i:0;s:37:"`Parceirosarea`.`parceirosservico_id`";}s:32:"2826d80e855773b6bc7eed2af2932595";a:13:{i:0;s:17:"`Relocation`.`id`";i:1;s:34:"`Relocation`.`parceirosservico_id`";i:2;s:28:"`Relocation`.`nome_supplier`";i:3;s:28:"`Relocation`.`nome_contacto`";i:4;s:20:"`Relocation`.`email`";i:5;s:23:"`Relocation`.`telefone`";i:6;s:22:"`Relocation`.`pais_id`";i:7;s:21:"`Relocation`.`cidade`";i:8;s:28:"`Relocation`.`data_validade`";i:9;s:25:"`Relocation`.`em_criacao`";i:10;s:23:"`Relocation`.`editavel`";i:11;s:27:"`Relocation`.`data_criacao`";i:12;s:23:"`Relocation`.`data_act`";}s:32:"84f4e65aea03790dd6fb1b0771b27afb";a:13:{i:0;s:17:"`Relocation`.`id`";i:1;s:34:"`Relocation`.`parceirosservico_id`";i:2;s:28:"`Relocation`.`nome_supplier`";i:3;s:28:"`Relocation`.`nome_contacto`";i:4;s:20:"`Relocation`.`email`";i:5;s:23:"`Relocation`.`telefone`";i:6;s:22:"`Relocation`.`pais_id`";i:7;s:21:"`Relocation`.`cidade`";i:8;s:28:"`Relocation`.`data_validade`";i:9;s:25:"`Relocation`.`em_criacao`";i:10;s:23:"`Relocation`.`editavel`";i:11;s:27:"`Relocation`.`data_criacao`";i:12;s:23:"`Relocation`.`data_act`";}s:32:"3fcb09daf37760766c244db73267884c";a:1:{i:0;s:34:"`Relocation`.`parceirosservico_id`";}s:32:"715a93559494b7c15668baefb5fcb8ed";a:13:{i:0;s:18:"`Immigration`.`id`";i:1;s:35:"`Immigration`.`parceirosservico_id`";i:2;s:29:"`Immigration`.`nome_supplier`";i:3;s:29:"`Immigration`.`nome_contacto`";i:4;s:21:"`Immigration`.`email`";i:5;s:24:"`Immigration`.`telefone`";i:6;s:23:"`Immigration`.`pais_id`";i:7;s:22:"`Immigration`.`cidade`";i:8;s:29:"`Immigration`.`data_validade`";i:9;s:26:"`Immigration`.`em_criacao`";i:10;s:24:"`Immigration`.`editavel`";i:11;s:28:"`Immigration`.`data_criacao`";i:12;s:24:"`Immigration`.`data_act`";}s:32:"b5f65baff023e2e701d71da9522511ba";a:13:{i:0;s:18:"`Immigration`.`id`";i:1;s:35:"`Immigration`.`parceirosservico_id`";i:2;s:29:"`Immigration`.`nome_supplier`";i:3;s:29:"`Immigration`.`nome_contacto`";i:4;s:21:"`Immigration`.`email`";i:5;s:24:"`Immigration`.`telefone`";i:6;s:23:"`Immigration`.`pais_id`";i:7;s:22:"`Immigration`.`cidade`";i:8;s:29:"`Immigration`.`data_validade`";i:9;s:26:"`Immigration`.`em_criacao`";i:10;s:24:"`Immigration`.`editavel`";i:11;s:28:"`Immigration`.`data_criacao`";i:12;s:24:"`Immigration`.`data_act`";}s:32:"2281601c09fd6bd03658b71ffec82588";a:1:{i:0;s:35:"`Immigration`.`parceirosservico_id`";}s:32:"65df74b7fd902579ec7b595d923f899b";a:5:{i:0;s:40:"DISTINCT `Parceirosservico`.`servico_id`";i:1;s:13:"`Area`.`nome`";i:2;s:14:"`Area`.`class`";i:3;s:23:"`Parceirosservico`.`id`";i:4;s:11:"`Area`.`id`";}s:32:"2e0accade6d2c4a856b8b91553c7bba9";a:5:{i:0;s:11:"`Area`.`id`";i:1;s:13:"`Area`.`nome`";i:2;s:14:"`Area`.`class`";i:3;s:21:"`Area`.`data_criacao`";i:4;s:17:"`Area`.`data_act`";}s:32:"cb25b5b14b87c4d2637eb981dc454419";a:1:{i:0;s:11:"`Area`.`id`";}s:32:"4402ab5a20fa617662ef9dd7c929f932";a:10:{i:0;s:20:"`Parceirosarea`.`id`";i:1;s:37:"`Parceirosarea`.`parceirosservico_id`";i:2;s:25:"`Parceirosarea`.`area_id`";i:3;s:24:"`Parceirosarea`.`cidade`";i:4;s:23:"`Parceirosarea`.`moeda`";i:5;s:31:"`Parceirosarea`.`data_validade`";i:6;s:28:"`Parceirosarea`.`em_criacao`";i:7;s:26:"`Parceirosarea`.`editavel`";i:8;s:30:"`Parceirosarea`.`data_criacao`";i:9;s:26:"`Parceirosarea`.`data_act`";}s:32:"772da9cf3d84a9e9b3aaf217ad98a8fe";a:1:{i:0;s:25:"`Parceirosarea`.`area_id`";}s:32:"fbbd31c0cad4a3e2e57dd239bfe3b058";a:2:{i:0;s:12:"`Pais`.`iso`";i:1;s:13:"`Pais`.`nome`";}s:32:"0a0aa0da0bb112a6d26f4357ee2e2594";a:10:{i:0;s:20:"`Parceirosarea`.`id`";i:1;s:37:"`Parceirosarea`.`parceirosservico_id`";i:2;s:25:"`Parceirosarea`.`area_id`";i:3;s:24:"`Parceirosarea`.`cidade`";i:4;s:23:"`Parceirosarea`.`moeda`";i:5;s:31:"`Parceirosarea`.`data_validade`";i:6;s:28:"`Parceirosarea`.`em_criacao`";i:7;s:26:"`Parceirosarea`.`editavel`";i:8;s:30:"`Parceirosarea`.`data_criacao`";i:9;s:26:"`Parceirosarea`.`data_act`";}s:32:"c6da4609106de59431f54b60e3e36b17";a:1:{i:0;s:20:"`Parceirosarea`.`id`";}s:32:"51d67ae19f27a99527867f4b60ff0ceb";a:5:{i:0;s:11:"`Area`.`id`";i:1;s:13:"`Area`.`nome`";i:2;s:14:"`Area`.`class`";i:3;s:21:"`Area`.`data_criacao`";i:4;s:17:"`Area`.`data_act`";}s:32:"bb464c63fc13ca6ea4333ffe8298f849";a:6:{i:0;s:13:"`Tarifa`.`id`";i:1;s:27:"`Tarifa`.`parceirosarea_id`";i:2;s:21:"`Tarifa`.`solucao_id`";i:3;s:25:"`Tarifa`.`tarifastipo_id`";i:4;s:23:"`Tarifa`.`data_criacao`";i:5;s:19:"`Tarifa`.`data_act`";}s:32:"1c82da20ec57eda831879bd3f4390c55";a:1:{i:0;s:27:"`Tarifa`.`parceirosarea_id`";}s:32:"3b5577b4caa0570db4f275244c86d238";a:6:{i:0;s:14:"`Solucao`.`id`";i:1;s:19:"`Solucao`.`area_id`";i:2;s:16:"`Solucao`.`nome`";i:3;s:26:"`Solucao`.`tarifastipo_id`";i:4;s:24:"`Solucao`.`data_criacao`";i:5;s:20:"`Solucao`.`data_act`";}s:32:"787c36057a58dc7b92267789b32762d4";a:4:{i:0;s:18:"`Tarifastipo`.`id`";i:1;s:20:"`Tarifastipo`.`nome`";i:2;s:28:"`Tarifastipo`.`data_criacao`";i:3;s:24:"`Tarifastipo`.`data_act`";}s:32:"e5bcd48bd06b87d9af0711c605b61d12";a:4:{i:0;s:1:"*";i:1;s:107:"(SELECT c.texto FROM conteudos c WHERE c.nome = CONCAT('INFO_MOVING_STORAGE_', Parceirosarea.area_id)) info";i:2;s:19:"Parceirosservico.id";i:3;s:7:"Area.id";}s:32:"d532258127eefd59821ad0fd3c456dd2";a:13:{i:0;s:11:"`User`.`id`";i:1;s:15:"`User`.`perfil`";i:2;s:21:"`User`.`nome_empresa`";i:3;s:22:"`User`.`nome_contacto`";i:4;s:14:"`User`.`email`";i:5;s:17:"`User`.`password`";i:6;s:17:"`User`.`telefone`";i:7;s:18:"`User`.`telemovel`";i:8;s:16:"`User`.`pais_id`";i:9;s:15:"`User`.`estado`";i:10;s:20:"`User`.`data_estado`";i:11;s:21:"`User`.`data_criacao`";i:12;s:17:"`User`.`data_act`";}s:32:"86935ce2b36f42561ae75332fcf1a5e9";a:6:{i:0;s:13:"`Tarifa`.`id`";i:1;s:27:"`Tarifa`.`parceirosarea_id`";i:2;s:21:"`Tarifa`.`solucao_id`";i:3;s:25:"`Tarifa`.`tarifastipo_id`";i:4;s:23:"`Tarifa`.`data_criacao`";i:5;s:19:"`Tarifa`.`data_act`";}s:32:"22c7e9e75cf52ce6711f60474a2ccece";a:1:{i:0;s:13:"`Tarifa`.`id`";}s:32:"1d8a460ff728e1584a1dd56a23879a17";a:6:{i:0;s:14:"`Solucao`.`id`";i:1;s:19:"`Solucao`.`area_id`";i:2;s:16:"`Solucao`.`nome`";i:3;s:26:"`Solucao`.`tarifastipo_id`";i:4;s:24:"`Solucao`.`data_criacao`";i:5;s:20:"`Solucao`.`data_act`";}s:32:"5fdc1d75817c677ae7a34987553fe16e";a:4:{i:0;s:18:"`Tarifastipo`.`id`";i:1;s:20:"`Tarifastipo`.`nome`";i:2;s:28:"`Tarifastipo`.`data_criacao`";i:3;s:24:"`Tarifastipo`.`data_act`";}s:32:"519273a1fd757f823cf0ad0992958ab4";a:7:{i:0;s:18:"`Tarifalinha`.`id`";i:1;s:25:"`Tarifalinha`.`tarifa_id`";i:2;s:34:"`Tarifalinha`.`tarifalinhatipo_id`";i:3;s:25:"`Tarifalinha`.`descricao`";i:4;s:21:"`Tarifalinha`.`preco`";i:5;s:28:"`Tarifalinha`.`data_criacao`";i:6;s:24:"`Tarifalinha`.`data_act`";}s:32:"017b5b73b53dd6ae8fe970b2d6546315";a:1:{i:0;s:25:"`Tarifalinha`.`tarifa_id`";}s:32:"a708bcc55131fbe1d32d64dbfa447686";a:5:{i:0;s:22:"`Tarifalinhatipo`.`id`";i:1;s:27:"`Tarifalinhatipo`.`area_id`";i:2;s:24:"`Tarifalinhatipo`.`nome`";i:3;s:32:"`Tarifalinhatipo`.`data_criacao`";i:4;s:28:"`Tarifalinhatipo`.`data_act`";}s:32:"2ba2cb9ae2092ae65a243974d8ff6d6c";a:5:{i:0;s:22:"`Tarifalinhatipo`.`id`";i:1;s:27:"`Tarifalinhatipo`.`area_id`";i:2;s:24:"`Tarifalinhatipo`.`nome`";i:3;s:32:"`Tarifalinhatipo`.`data_criacao`";i:4;s:28:"`Tarifalinhatipo`.`data_act`";}s:32:"9a159aa53512bb161f713a22c004c20b";a:2:{i:0;s:22:"`Tarifalinhatipo`.`id`";i:1;s:24:"`Tarifalinhatipo`.`nome`";}s:32:"597c23623c51fe11e6e0b70b9ac41a5b";a:1:{i:0;s:34:"`Relocation`.`parceirosservico_id`";}s:32:"5cce32f4e439bacf46e7519c036cefc5";a:1:{i:0;s:35:"`Immigration`.`parceirosservico_id`";}s:32:"eb3598638bf95e6462428550b7aaabec";a:2:{i:0;s:17:"`Conteudo`.`nome`";i:1;s:18:"`Conteudo`.`texto`";}s:32:"2c92d9155fef2db7acd171f919d6fe1f";a:4:{i:0;s:14:"`Servico`.`id`";i:1;s:16:"`Servico`.`nome`";i:2;s:24:"`Servico`.`data_criacao`";i:3;s:20:"`Servico`.`data_act`";}s:32:"720fb92c083a68c6ec09a710690bc279";a:1:{i:0;s:14:"`Servico`.`id`";}s:32:"be6ccac1a57fa26e46556132ba0336dd";a:1:{i:0;s:31:"`Parceirosservico`.`servico_id`";}s:32:"4e5512dfd5792eebc02276ec3ecc90f4";a:2:{i:0;s:20:"`Conteudosarea`.`id`";i:1;s:22:"`Conteudosarea`.`nome`";}s:32:"f5ca78e304cdf07f37ce76dd82c0d8ce";a:7:{i:0;s:15:"`Conteudo`.`id`";i:1;s:29:"`Conteudo`.`conteudosarea_id`";i:2;s:17:"`Conteudo`.`nome`";i:3;s:22:"`Conteudo`.`descricao`";i:4;s:18:"`Conteudo`.`texto`";i:5;s:25:"`Conteudo`.`data_criacao`";i:6;s:21:"`Conteudo`.`data_act`";}s:32:"09a236735aeeeeb0576ca17c62c36a52";a:4:{i:0;s:20:"`Conteudosarea`.`id`";i:1;s:22:"`Conteudosarea`.`nome`";i:2;s:30:"`Conteudosarea`.`data_criacao`";i:3;s:26:"`Conteudosarea`.`data_act`";}s:32:"9d4c2887ca8e385f36dac033c35d4b55";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"ecc65b5c492fe0fb9c46c141e7b32ac9";a:3:{i:0;s:1:"*";i:1;s:90:"(SELECT COUNT(*) FROM tarifas t WHERE t.parceirosarea_id = Parceirosarea.id) tarifas_count";i:2;s:7:"area_id";}s:32:"e0889baf10e54d6b801eb4ae499986e9";a:5:{i:0;s:11:"`Area`.`id`";i:1;s:13:"`Area`.`nome`";i:2;s:14:"`Area`.`class`";i:3;s:21:"`Area`.`data_criacao`";i:4;s:17:"`Area`.`data_act`";}s:32:"8c1618eced58d6d612175cf8d9536b90";a:2:{i:0;s:14:"`Servico`.`id`";i:1;s:16:"`Servico`.`nome`";}s:32:"de4848cf1f9a63c4e43773431c7d3d92";a:6:{i:0;s:23:"`Parceirosservico`.`id`";i:1;s:28:"`Parceirosservico`.`user_id`";i:2;s:31:"`Parceirosservico`.`servico_id`";i:3;s:28:"`Parceirosservico`.`visivel`";i:4;s:33:"`Parceirosservico`.`data_criacao`";i:5;s:29:"`Parceirosservico`.`data_act`";}s:32:"d27686f24ef2e85913333d538b71eb76";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"2a6a2c2efc43333af9c5e0fe908a6791";a:3:{i:0;s:14:"`Solucao`.`id`";i:1;s:16:"`Solucao`.`nome`";i:2;s:26:"`Solucao`.`tarifastipo_id`";}s:32:"ae39a1eb9d4155b78dddb1bc47d851e1";a:5:{i:0;s:22:"`Solucoestamanho`.`id`";i:1;s:30:"`Solucoestamanho`.`solucao_id`";i:2;s:24:"`Solucoestamanho`.`nome`";i:3;s:32:"`Solucoestamanho`.`data_criacao`";i:4;s:28:"`Solucoestamanho`.`data_act`";}s:32:"10dbc2b39ae0bf06469d69f574c1b66b";a:7:{i:0;s:18:"`Tarifalinha`.`id`";i:1;s:25:"`Tarifalinha`.`tarifa_id`";i:2;s:34:"`Tarifalinha`.`tarifalinhatipo_id`";i:3;s:25:"`Tarifalinha`.`descricao`";i:4;s:21:"`Tarifalinha`.`preco`";i:5;s:28:"`Tarifalinha`.`data_criacao`";i:6;s:24:"`Tarifalinha`.`data_act`";}s:32:"d3a4c3531c7a170752358b96316f7720";a:1:{i:0;s:19:"COUNT(*) AS `count`";}s:32:"9833d17e250f17894bf12a18e94652a5";a:1:{i:0;s:19:"COUNT(*) AS `count`";}}}
