|
|
|
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:09 |
|
||
|
Big Query
|
|||
|---|---|---|---|
|
#18+
Versiya : 5.0.0-alpha-max-debug ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 19.07.2004, 10:46 |
|
||
|
|

start [/forum/topic.php?fid=47&msg=32610228&tid=1854970]: |
0ms |
get settings: |
11ms |
get forum list: |
14ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
418ms |
get topic data: |
14ms |
get forum data: |
3ms |
get page messages: |
61ms |
get tp. blocked users: |
2ms |
| others: | 251ms |
| total: | 780ms |

| 0 / 0 |
