Error
  • Can't create/write to file '/tmp/#sql_7e8a_2.MYI' (Errcode: 30) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM vazor_content AS a LEFT JOIN vazor_categories AS c ON c.id = a.catid LEFT JOIN vazor_users AS ua ON ua.id = a.created_by LEFT JOIN vazor_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM vazor_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN vazor_categories as parent ON parent.id = c.parent_id LEFT JOIN vazor_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM vazor_categories AS cat JOIN vazor_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN vazor_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-11-26 23:10:04') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-11-26 23:10:04') AND a.language in ('en-GB','*') AND (contact.language in ('en-GB','*') OR contact.language IS NULL) GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, a.ordering, a.created DESC LIMIT 0, 18 Can't create/write to file '/tmp/#sql_7e8a_2.MYI' (Errcode: 30) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM vazor_content AS a LEFT JOIN vazor_categories AS c ON c.id = a.catid LEFT JOIN vazor_users AS ua ON ua.id = a.created_by LEFT JOIN vazor_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM vazor_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN vazor_categories as parent ON parent.id = c.parent_id LEFT JOIN vazor_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM vazor_categories AS cat JOIN vazor_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN vazor_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-11-26 23:10:04') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-11-26 23:10:04') AND a.language in ('en-GB','*') AND (contact.language in ('en-GB','*') OR contact.language IS NULL) GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, a.ordering, a.created DESC
  • Duplicate entry '971259' for key 1 SQL=INSERT INTO vazor_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('54.197.211.197')) , NULL )

NATURE

STATISTICS

971258
TodayToday1377
This_MonthThis_Month49470
All_DaysAll_Days971258

REVIEW

 The Review to textbook Rahimov R.H. "Operative-search activity"

from name of the Deputy Majlisi Oli Republic of the Tajikistan Imomova A.Kh.,

candidate of the legal sciences, state adviser to justices 2nd degree.

 

Training manual

This manual is designed to provide a uniform legal practice experience, and serves as a training tool for the control of procurement of drugs, which is considered one of the most effective search operations.  

Preamble

It Is Approved

Strategy of the reform to militias on 2013 - 2020

The Strategy of the reform to militias on 2013-2020 (hereinafter Strategy), founding on rate of the Constitutions of the Republic of Tajikistan, defines to purposes, priorities and measures on reform and development to militias, and reflects the actions a Government Republic of Tajikistan on urgent period.

The second edition of the textbook "Operative-search activity"

 Published a second book "Operative-search activity» by author Rahimzoda Ramazon Hamro. This book covers the basic aspects of this type of legal activity; it used forward practices in the field of the law of prominent scientist and as a reference book designed to teach in higher and secondary special educational institutions relevant organs.

SPEECHES BY THE PRESIDENT

The speech of the President of the Republic of Tajikistan

Emomali Rahmon on solemn meeting in honour of

Day to militias”.

 

HELPLINE

Telephone of the confidence

Telephone of the confidence

Minister of the internal of Affairs.

(8372) 221-21-21 

The Telephone of the confidence of the subdivisions

MIA RT DMIA in Dushanbe town.

(8372) 221-15-00

DMIA in Sogd region

(83422) 6-22-22

DMIA in Khatlon region

(83222) 2-13-13

DMIA in Badakhshan region

(83522) 2-21-21

 Zonal subdivision DMIA Khatlon region, Kulyab area

(83322) 3-39-79

DMIA groups region Rasht

(83131) 2-21-21

The Announcement!


The Ministry internal of Affairs of the Republic of Tajikistan

invites the specialist with knowledge of the Chinese language for working:

The Requirements to candidate:

- a higher education;

- a knowledge of the Chinese language on professional level;

- a knowledge Tajik and Russian languages is greeted;

- an age - before 35 years;

- military

The Interested persons can send their own CV to e-mail:

This email address is being protected from spambots. You need JavaScript enabled to view it.

The Telephone for contact:

223-23-31.

THE ANNOUNCEMENT!!!

Ministry Internal of Affairs of the Republic of Tajikistan declares contest

on replace vacant job titles specialist with knowledge of English for working

in Press-service MIA, connected with site MIA, and in Department international cooperation:

 The Requirements to candidate:

- a higher education;

- a knowledge of English on professional level (the practical experience of the work on translation text not less 3 years);

- a knowledge Tajik and Russian languages is greeted;

- an age - before 35 years;

- military.

 The Interested persons can send their own CV to e-mail:

This email address is being protected from spambots. You need JavaScript enabled to view it. . The Telephone for contact: 223-23-31.