SELECT "carros"."id" AS t0_r0, "carros"."grupo_id" AS t0_r1, "carros"."placa" AS t0_r2, "carros"."carro_type" AS t0_r3, "carros"."state" AS t0_r4, "carros"."marca" AS t0_r5, "carros"."cor" AS t0_r6, "carros"."modelo" AS t0_r7, "carros"."chassi" AS t0_r8, "carros"."eixos" AS t0_r9, "carros"."ano" AS t0_r10, "carros"."created_at" AS t0_r11, "carros"."updated_at" AS t0_r12, "carros"."plano_id" AS t0_r13, "carros"."tanque" AS t0_r14, "carros"."kmlitro" AS t0_r15, "carros"."comercial_id" AS t0_r16, "carros"."ativo" AS t0_r17, "carros"."gas_type" AS t0_r18, "posicoes"."id" AS t1_r0, "posicoes"."modulo_id" AS t1_r1, "posicoes"."carro_id" AS t1_r2, "posicoes"."viagem_id" AS t1_r3, "posicoes"."cidade_id" AS t1_r4, "posicoes"."estado_id" AS t1_r5, "posicoes"."hora" AS t1_r6, "posicoes"."speed" AS t1_r7, "posicoes"."geom" AS t1_r8, "posicoes"."panic" AS t1_r9, "posicoes"."sensors" AS t1_r10, "posicoes"."commands" AS t1_r11, "posicoes"."direction" AS t1_r12, "posicoes"."ignition" AS t1_r13, "posicoes"."poi_id" AS t1_r14, "posicoes"."created_at" AS t1_r15, "cidades"."id" AS t2_r0, "cidades"."estado_id" AS t2_r1, "cidades"."pais_id" AS t2_r2, "cidades"."nome" AS t2_r3, "cidades"."geom" AS t2_r4, "rotas"."id" AS t3_r0, "rotas"."grupo_id" AS t3_r1, "rotas"."origem_id" AS t3_r2, "rotas"."destino_id" AS t3_r3, "rotas"."nome" AS t3_r4, "rotas"."filename" AS t3_r5, "rotas"."size" AS t3_r6, "rotas"."content_type" AS t3_r7, "rotas"."ativa" AS t3_r8, "rotas"."waypoints_count" AS t3_r9, "rotas"."created_at" AS t3_r10, "rotas"."updated_at" AS t3_r11, "rotas"."geom" AS t3_r12, "rotas"."metros" AS t3_r13, "grupos_carros"."id" AS t4_r0, "grupos_carros"."nome" AS t4_r1, "grupos_carros"."grupo_type" AS t4_r2, "grupos_carros"."responsavel_id" AS t4_r3, "grupos_carros"."state" AS t4_r4, "grupos_carros"."cidade_id" AS t4_r5, "grupos_carros"."insc_estadual" AS t4_r6, "grupos_carros"."cnpj" AS t4_r7, "grupos_carros"."endereco" AS t4_r8, "grupos_carros"."bairro" AS t4_r9, "grupos_carros"."numero" AS t4_r10, "grupos_carros"."site" AS t4_r11, "grupos_carros"."cep" AS t4_r12, "grupos_carros"."created_at" AS t4_r13, "grupos_carros"."updated_at" AS t4_r14, "grupos_carros"."contratos_count" AS t4_r15, "comerciais"."id" AS t5_r0, "comerciais"."nome" AS t5_r1, "comerciais"."desc" AS t5_r2, "comerciais"."icone_file_name" AS t5_r3, "comerciais"."icone_content_type" AS t5_r4, "comerciais"."icone_file_size" AS t5_r5 FROM "carros" LEFT OUTER JOIN "posicoes" ON posicoes.carro_id = carros.id LEFT OUTER JOIN "cidades" ON "cidades".id = "posicoes".cidade_id LEFT OUTER JOIN "viagens" ON ("carros"."id" = "viagens"."carro_id") LEFT OUTER JOIN "rotas" ON ("rotas"."id" = "viagens"."rota_id") AND hora_chegada is NULL LEFT OUTER JOIN "grupos" grupos_carros ON "grupos_carros".id = "carros".grupo_id LEFT OUTER JOIN "comerciais" ON "comerciais".id = "carros".comercial_id INNER JOIN grupos ON ( carros.grupo_id = grupos.id ) INNER JOIN contratos ON ( grupos.id = contratos.grupo_id ) WHERE (contratos.usuario_id = 1 ) AND (carros."ativo" = 't') ORDER BY carros.id ASC, posicoes.hora ASC