Sorry, I spotted it..!!
never mind ;-p
On 20/10/06, Tris <[EMAIL PROTECTED]> wrote:
this is awesome..
I've always wanted to learn JOIN(s)
I'll take a look
cheers!!!
On 20/10/06, r937 <[EMAIL PROTECTED]> wrote:
>
> three things:
>
> 1. your query is incomplete, some join conditions are missing
> 2. your tables are missing indexes on the join columns
> 3. LIMIT makes no sense without ORDER BY
>
> 1 is most serious, as you will get extraneous and incorrect results
> (and i suspect this is why you plunked DISTINCT into the query)
>
> 2 means your query will run for hours instead of seconds
>
> 3 is a logic problem
>
>
> here's your query, written with JOIN syntax (recommended)
>
> notice where the join conditions are missing
>
>
> SELECT distinct
> products.id
> , products.title
> , brands.title as brandTitle
> , products.thumb2
> , products.price
> , products.salePrice
> , products.saleStatus
> FROM products
> inner
> join stock
> on stock.productId = products.id
> and stock.count > 0
> inner
> join prodcatmatch
> on prodcatmatch.????? = ???????.?????
> inner
> join categories as parent
> on parent.id = stock.size
> and parent.gender = '1'
> and parent.type = '2'
> inner
> join categories as child
> on child.????? = ???????.?????
> inner
> join brands
> on brands.id = products.brand
> order
> by ?????? LIMIT 0,24
>
>
> rudy
> http://r937.com/
>
> ____ � The WDVL Discussion List from WDVL.COM � ____
> To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
> use the web interface http://e-newsletters.internet.com/discussionlists.html/
> Send Your Posts To: [email protected]
> To change subscription settings, add a password or view the web interface:
> http://intm-dl.sparklist.com/read/?forum=wdvltalk
>
> ________________ http://www.wdvl.com _______________________
>
> You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> To unsubscribe via postal mail, please contact us at:
> Jupitermedia Corp.
> Attn: Discussion List Management
> 475 Park Avenue South
> New York, NY 10016
>
> Please include the email address which you have been contacted with.
>
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to $subst('List.Name') as:
$subst('Recip.EmailAddr')
To unsubscribe send a blank email to $subst('Email.UnSub')
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: [email protected]
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to $subst('List.Name') as:
$subst('Recip.EmailAddr')
To unsubscribe send a blank email to $subst('Email.UnSub')
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
