SELECT id, fecha_caducidad, estado FROM optimized_propiedades WHERE (fecha_caducidad='0' OR fecha_caducidad>'1220891136') AND  ( tipo_operacion LIKE '%holiday_rentals%' )
 AND 
 ( show LIKE '%under_offer%'  OR 
show LIKE '%bargain_cheap_property%'  OR 
show LIKE '%reduced%'  OR 
show LIKE '%late_availability%' ) AND 
( estado = 'activo' )
  ORDER BY  fecha_creacion   DESC  <br>An error occourred. Please tell the admin about this problem. Thanks and sorry for the inconvenience.