| Query: | SELECT `mr_listings`.tipo_campo, `mr_listings`.instalaciones_rurales, `mr_listings`.ID, `mr_listings`.Category_ID,`mr_listings`.Account_ID, `mr_listings`.Plan_ID, `mr_listings`.Pay_date, `mr_listings`.Status,`mr_listings`.address, `mr_listings`.additional_information,`mr_listings`.title,`mr_listings`.bathrooms, `mr_listings`.ref_number, `mr_listings`.forma_de_pago, `mr_listings`.m_construidos, `mr_listings`.aniguedad, `mr_listings`.estado, `mr_listings`.dormitorios,
`mr_listings`.cochera, `mr_listings`.m_terreno, `mr_listings`.expensa, `mr_listings`.largo_terreno, `mr_listings`.frente_terreno, `mr_listings`.cant_plantas,
`mr_listings`.tipo_barrio, `mr_listings`.entrada_ancho, `mr_listings`.entrada_alto, `mr_listings`.planos,
`mr_listings`.hectareas, `mr_listings`.descripcion_servicio, `mr_listings`.pcia, `mr_listings`.pcia_level1, `mr_listings`.pcia_level2, `mr_listings`.pcia_level3, `mr_listings`.seguridad_24hs, `mr_listings`.tipo_cobertura, `mr_listings`.porton_auto, `mr_listings`.servicios,
`mr_listings`.sale_rent,`mr_listings`.ambientes, `mr_listings`.dep_piso, `mr_listings`.cant_pisos,
`mr_listings`.expens, `mr_listings`.deposito_alquiler, `mr_listings`.contrato_alquiler, `mr_listings`.mascotas, `mr_listings`.adelanto_alquiler, `mr_listings`.alquiler_nino, `mr_listings`.garantia, `mr_listings`.amoblado, `mr_listings`.credito, `mr_listings`.barrio, `mr_listings`.precio,
`mr_listings`.moneda_precio, `mr_listings`.moneda_expensa, `mr_listings`.precio_expensas, `mr_listings`.cheques, `mr_listings`.otras_condiciones, `mr_listings`.financiacion, `mr_listings`.entrega_financiacion, `mr_listings`.tasa_pesos, `mr_listings`.tasa_dolares, `mr_listings`.bitcoin, `mr_listings`.Etiquetas,
mr_accounts.Own_address, mr_accounts.Type, mr_accounts.company_name, mr_accounts.Photo, `mr_categories`.`Key`, CASE
WHEN `mr_listings`.`Plan_ID` = 11 THEN 1
WHEN `mr_listings`.`Plan_ID` = 60 THEN 2
WHEN `mr_listings`.`Plan_ID` = 62 THEN 2
WHEN `mr_listings`.`Plan_ID` = 64 THEN 2
WHEN `mr_listings`.`Plan_ID` = 67 THEN 2
WHEN `mr_listings`.`Plan_ID`= 69 THEN 3
WHEN `mr_listings`.`Plan_ID` = 68 THEN 4
WHEN `mr_listings`.`Plan_ID` = 5 THEN 4
ELSE 5
END AS Orden FROM `mr_listings` INNER JOIN mr_accounts ON mr_listings.Account_ID = mr_accounts.ID INNER JOIN mr_categories ON `mr_listings`.`Category_ID` = mr_categories.ID WHERE `mr_categories`.`Path` = 'campos' AND `mr_listings`.`Status` IN ('active', 'expired') AND `mr_listings`.`sale_rent` = '1' AND `mr_listings`.`pcia` = 'chaco' AND `mr_accounts`.`Type` = 'dealer' ORDER BY `Orden` ASC , `Pay_date` DESC LIMIT 0, 18; |