Guest Posted January 24, 2005 Posted January 24, 2005 I posted this message a few days ago & noone has yet answered..... Can someone please give me some guidance? http://www.oscommerce.com/forums/index.php?sho...16entry531716 Thanks!
Guest Posted January 25, 2005 Posted January 25, 2005 i looked at that and cant even find your 'original' question which ties in with that, thus i can see why no one is answering as they dont know what you are/had asked. did you ask the question in a pm and got an answer there? post the appropriate question in the appropriate support thread.
Guest Posted January 25, 2005 Posted January 25, 2005 Well, my original question was posted as follows in the "Live Data Feed base class+Froogle - only 1 query!" forum; however, it has gone unanswered.... I am getting an error which I will post here.... 1104 - The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok SELECT * FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories_description cd ON p2c.categories_id = cd.categories_id WHERE p.products_status = 1 GROUP BY p.products_id [TEP STOP] Now, I am not sure what I would have done wrong, but it almost looks like I have to many products for this particular contribution to work... Am I reading that right?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.