|
|
|
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&fpage=681&tid=1854970]: |
0ms |
get settings: |
8ms |
get forum list: |
9ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
32ms |
get topic data: |
6ms |
get forum data: |
1ms |
get page messages: |
22ms |
get tp. blocked users: |
1ms |
| others: | 201ms |
| total: | 284ms |

| 0 / 0 |
