Victoria Reznichenko writes:
>
> SELECT COUNT(*) FROM question, listing, user ub, user us WHERE
> question.listing_id = listing.id AND question.buyer_id = ub.id AND
> listing.seller_id = us.id AND (ub.id = 2346 OR us.id = 2346)
> ORDER BY question.last_modified DESC;
>
> +--+
> | COUNT(
I haven't seen any traffic on this thread, so I figured I'd repost it
with a slightly more catchy subject. :)
Has anyone looked into this?
On Tue, Oct 08, 2002 at 09:12:13PM -0500, Shane Allen wrote:
> >Description:
>
> See "How-To-Repeat"
>
> >How-To-Repeat:
>
> I uploaded a copy of the tabl
>Description:
See "How-To-Repeat"
>How-To-Repeat:
I uploaded a copy of the tables to support.mysql.com/pub/mysql/secret.
Each of the tables below contains many rows (from 50-100k per table).
We were unable to duplicate with a smaller result set,
CREATE TABLE listing (
id int(10) unsigned NOT
