
Новые сообщения [новые:0]
Дайджест
Горячие темы
Избранное [новые:0]
Форумы
Пользователи
Статистика
Статистика нагрузки
Мод. лог
Поиск
|
|
19.07.2004, 10:09
|
|||
|---|---|---|---|
|
|||
Big Query |
|||
|
#18+
I have big query with a problem inside.Probably you can help me to find an fix this problem.it doesn't run.This is my query: select front.*, image_data.Type, image_data.ContentType, image_data.GUID, image_data.Size, image_data.Width, image_data.Height from image_info as front inner join image_data on front.image_id = image_data.image_info_id where front.Image_ID in (select front.image_id from image_info as front inner join image_data on front.image_id = image_data.image_info_id where (front.Title like '%a%' OR front.Description like '%a%' OR front.Place like '%a%' ) AND image_data.type = 2 AND front.IsReverse = 0 union select reverse.image_id from image_info as front left outer join image_info as reverse on front.Reverse_Image_ID = reverse.Image_ID left outer join image_data on reverse.Image_ID = image_data.image_info_id where (front.Title like '%a%' OR front.Description like '%a%' OR front.Place like '%a%' ) AND image_data.type = 2 AND front.IsReverse = 0)) union select reverse.*, image_data.Type, image_data.ContentType, image_data.GUID, image_data.Size, image_data.Width, image_data.Height from image_info as front left outer join image_info as reverse on front.Reverse_Image_ID = reverse.Image_ID left outer join image_data on reverse.Image_ID = image_data.image_info_id where front.Image_ID in (select front.image_id from image_info as front inner join image_data on front.image_id = image_data.image_info_id where (front.Title like '%a%' OR front.Description like '%a%' OR front.Place like '%a%' ) AND image_data.type = 2 AND front.IsReverse = 0 union select reverse.image_id from image_info as front left outer join image_info as reverse on front.Reverse_Image_ID = reverse.Image_ID left outer join image_data on reverse.Image_ID = image_data.image_info_id where (front.Title like '%a%' OR front.Description like '%a%' OR front.Place like '%a%' ) AND image_data.type = 2 AND front.IsReverse = 0)); My regards!!! ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
19.07.2004, 10:27
|
|||
|---|---|---|---|
|
|||
Big Query |
|||
|
#18+
MySQL версия какая? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|
19.07.2004, 10:46
|
|||
|---|---|---|---|
|
|||
Big Query |
|||
|
#18+
Versiya : 5.0.0-alpha-max-debug ... |
|||
|
:
Нравится:
Не нравится:
|
|||
|
|
|

start [/forum/topic.php?fid=47&mobile=1&tid=1854970]: |
0ms |
get settings: |
13ms |
get forum list: |
18ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
181ms |
get topic data: |
12ms |
get forum data: |
2ms |
get page messages: |
53ms |
get tp. blocked users: |
2ms |
| others: | 256ms |
| total: | 545ms |

| 0 / 0 |
