Notices - Chhagalnaiya Islamia Kamil (M A) Madrasah

Chhagalnaiya Islamia Kamil (M A) Madrasah

প্রতিষ্ঠা: à§§à§¯à§©à§ à¦–à§à¦°à¦¿à¦ƒ

ফোন: à§¦à§§à§®à§§à§¯-à§¦à§§à§©à§à§§à§¨

(default_sandbox) 3 queries took 2 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `dumoorco_biddaloy_sandbox`.`notices` AS `Notice` LEFT JOIN `dumoorco_biddaloy_sandbox`.`levels` AS `Level` ON (`Notice`.`reference_id` = `Level`.`id`) WHERE `Notice`.`institute_id` = 6	1	1	2
2	SELECT `Notice`.`id`, `Notice`.`institute_id`, `Notice`.`notice_for`, `Notice`.`reference_id`, `Notice`.`subject`, `Notice`.`content`, `Notice`.`is_publish`, `Notice`.`from_date`, `Notice`.`to_date`, `Notice`.`createdby_user_id`, `Notice`.`modifiedby_user_id`, `Notice`.`created`, `Notice`.`modified`, `Level`.`id`, `Level`.`name`, `Level`.`institute_category_id`, `Level`.`order`, `Level`.`is_standard`, `Level`.`createdby_user_id`, `Level`.`modifiedby_user_id`, `Level`.`created`, `Level`.`modified` FROM `dumoorco_biddaloy_sandbox`.`notices` AS `Notice` LEFT JOIN `dumoorco_biddaloy_sandbox`.`levels` AS `Level` ON (`Notice`.`reference_id` = `Level`.`id`) WHERE `Notice`.`institute_id` = 6 ORDER BY `Notice`.`id` DESC LIMIT 10	10	10	0
3	SELECT `Media`.`id`, `Media`.`institute_id`, `Media`.`reference_type`, `Media`.`reference_id`, `Media`.`media_for`, `Media`.`media_mime_type`, `Media`.`is_default`, `Media`.`name`, `Media`.`caption`, `Media`.`note`, `Media`.`url`, `Media`.`thumbnail_url`, `Media`.`image_url`, `Media`.`alt`, `Media`.`anchorlink`, `Media`.`anchorlink_target`, `Media`.`is_publish`, `Media`.`sort_order`, `Media`.`created`, `Media`.`modified` FROM `dumoorco_biddaloy_sandbox`.`media` AS `Media` WHERE `Media`.`media_for` LIKE '%Notice%' AND `Media`.`institute_id` = 6 AND `Media`.`reference_id` IN (151, 141, 139, 131, 130, 125, 124, 106, 104, 102) ORDER BY `Media`.`created` DESC	1	1	0

(default_sandbox) 3 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT COUNT(*) AS `count` FROM `dumoorco_biddaloy_sandbox`.`notices` AS `Notice` LEFT JOIN `dumoorco_biddaloy_sandbox`.`levels` AS `Level` ON (`Notice`.`reference_id` = `Level`.`id`) WHERE `Notice`.`institute_id` = 6

SELECT `Notice`.`id`, `Notice`.`institute_id`, `Notice`.`notice_for`, `Notice`.`reference_id`, `Notice`.`subject`, `Notice`.`content`, `Notice`.`is_publish`, `Notice`.`from_date`, `Notice`.`to_date`, `Notice`.`createdby_user_id`, `Notice`.`modifiedby_user_id`, `Notice`.`created`, `Notice`.`modified`, `Level`.`id`, `Level`.`name`, `Level`.`institute_category_id`, `Level`.`order`, `Level`.`is_standard`, `Level`.`createdby_user_id`, `Level`.`modifiedby_user_id`, `Level`.`created`, `Level`.`modified` FROM `dumoorco_biddaloy_sandbox`.`notices` AS `Notice` LEFT JOIN `dumoorco_biddaloy_sandbox`.`levels` AS `Level` ON (`Notice`.`reference_id` = `Level`.`id`) WHERE `Notice`.`institute_id` = 6 ORDER BY `Notice`.`id` DESC LIMIT 10

SELECT `Media`.`id`, `Media`.`institute_id`, `Media`.`reference_type`, `Media`.`reference_id`, `Media`.`media_for`, `Media`.`media_mime_type`, `Media`.`is_default`, `Media`.`name`, `Media`.`caption`, `Media`.`note`, `Media`.`url`, `Media`.`thumbnail_url`, `Media`.`image_url`, `Media`.`alt`, `Media`.`anchorlink`, `Media`.`anchorlink_target`, `Media`.`is_publish`, `Media`.`sort_order`, `Media`.`created`, `Media`.`modified` FROM `dumoorco_biddaloy_sandbox`.`media` AS `Media` WHERE `Media`.`media_for` LIKE '%Notice%' AND `Media`.`institute_id` = 6 AND `Media`.`reference_id` IN (151, 141, 139, 131, 130, 125, 124, 106, 104, 102) ORDER BY `Media`.`created` DESC

নোটিস বোর্ড

নোটিস বোর্ড