SELECT id, fecha_caducidad, estado FROM optimized_propiedades WHERE (fecha_caducidad='0' OR fecha_caducidad>'1228260639') AND  ( tipo_operacion LIKE '%holiday_rentals%' )
 AND 
 ( shos_as LIKE '%under_offer%'  OR 
shos_as LIKE '%bargain_cheap_property%'  OR 
shos_as LIKE '%reduced%'  OR 
shos_as 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.