Innocent (looking) query pinning mysqld

2003-05-31 Thread Chris Cameron
The gist; the below query doesn't finish, can't figure out why. -- Query -- SELECT images.iid, images.locnetid, images.path, images.CD, lightbox_location_image_LINK.iid FROM images CROSS JOIN image_cat_location_link LEFT OUTER JOIN

Re: Innocent (looking) query pinning mysqld

2003-05-31 Thread gerald_clark
You have no ON condition for image_cat_location_link. Chris Cameron wrote: The gist; the below query doesn't finish, can't figure out why. -- Query -- SELECT images.iid, images.locnetid, images.path, images.CD, lightbox_location_image_LINK.iid FROM