Not seeing the whole query I cannot say too much but:
> WHERE > p.phone_id BETWEEN :min AND :max
¿ Are you sure you're not getting fencepost overlaps when substituting :min/:max ? ( between does closed intervals, normally half closed ( phone_id >= min and phone_id<max ) are used for this kinds of queries ( I ask because it seems a query doing b-c could lock out other doing a-b for a long time ). Francisco Olarte.