Answer the question
In order to leave comments, you need to log in
Question about using indexes in different versions of MySQL?
There is a complex compound query of the form:
SELECT `c`.*, `r`.*, `ci`.*, `i`.*, `u`.*, `ca`.`Category_Weight` AS Category_Parent_Weight, `ca`.`Category_Alias` AS Category_Parent_Alias
FROM (`ct_items` i)
LEFT JOIN `ct_categories` c ON `i`.`Category_ID` = `c`.`Category_ID`
LEFT JOIN `ct_categories` ca ON `c`.`Category_Group_Id` = `ca`.`Category_ID`
LEFT JOIN `ct_regions` r ON `i`.`Region_ID` = `r`.`Region_ID`
LEFT JOIN `ct_cities` ci ON `i`.`City_ID` = `ci`.`City_ID`
LEFT JOIN `ct_users` u ON `i`.`User_ID` = `u`.`id`
WHERE `Item_status` = 'active'
AND `User_ID` = '1'
AND `Item_ID` <> '5869135'
LIMIT 4
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question