,

  ,
: Bulphoto.com,

,

Bulgaria News | 30.07.2009 16:10

, . 196 "", 1 "" 6 " " , 1 21 , . , - , ". , , , , . , , . , , 1-21 .

...

Ȕ ߓ : 600 : 752 994 , 76 193 : - , Š : 50%

17:51
13:00
13:22
»
Time: 0.410 sec
Memory: 5.26 Mb
Peak memory: 5.57 Mb
Total SQL queries: 118
Total SQL time: 0.380 sec
Slowest SQL query time: 0.151 sec
Slowest SQL query:
SELECT 
								a.ID,		
								a.option_list_image,
								a.option_full_image,
								a.option_publish_date,
								a.publish as date,
								am.enabled,
								am.Title as title,
								am.Resume as resume,
								am.Author as author,
								am.Subtitle as subtitle,
								am.image_text,
								CONCAT("original",".",a.extension) as image,
								CONCAT("medium",".",a.extension) as medium,
								CONCAT("thumb",".",a.extension) as thumb,
								DATE_FORMAT(a.publish,"%d.%m.%Y %H:%i") as publish,
								IF(a.tag IS NULL,CONCAT("post",a.ID),a.tag) as path,
								d.category_id  as category_id,
								c.category_tag
FROM bn_articles a
													INNER JOIN bn_articles_distribution d
													ON d.ArticleID = a.ID
 INNER JOIN bn_articles_meta am
																		ON am.ArticleID = a.ID
INNER JOIN bn_articles_categories c
														ON c.category_id = d.category_id
WHERE a.publish <= NOW() AND am.language_id = 1
AND d.category_id = 7
ORDER BY date DESC 
LIMIT 0,7