SELECT * FROM ib_propiedad WHERE  mostrar='1' AND  real_id in (select propiedad_id from ib_propiedad_publicaren where sitio_id=1) AND    
                        alquiladavendida IN (0,1)  AND                                        
                       operacion in (1,5,7)  AND
                      precio_orden BETWEEN 0 AND 100000000  AND tipo in (0) ORDER BY  precio_orden  LIMIT 0 , 40