| 0.0004 |
UPDATE visit_counter SET visitCount=visitCount+1 WHERE 1=1
|
| 0.0005 |
SELECT * FROM content_manage cm WHERE cm.categoryID IN (13,17,25,26) && cm.status = 1
|
| 0.0004 |
SELECT news_id,
cat_id,
sub_cat_id,
news_title,
news_abstract,
news_detail,
news_url,
news_publisher,
thumb_image,
news_image1,
concat(DATE_FORMAT(ni.event_start_date, '%d %b, %Y'), ' - ', DATE_FORMAT(ni.event_end_date, '%d %b, %Y')) AS duration,
event_location,
DATE_FORMAT(publish_date, '%d %b, %Y') AS publish_date
FROM newsevents_info ni
WHERE 1=1 && status =1 && (CURDATE() between publish_date and close_date) ORDER BY ni.publish_date DESC LIMIT 0, 5
|
| 0.0009 |
SELECT concat(DATE_FORMAT(cd.startDate, '%d %b, %Y'), ' - ', DATE_FORMAT(cd.endDate, '%d %b, %Y')) AS duration,
ci.courseName,
cd.courseSubID,
cc.circularTitle,
cc.externalCircular,
DATE_FORMAT(cd.startDate, '%d %b, %Y') AS startDate,
DATE_FORMAT(cc.close_date, '%d %b, %Y') AS close_date,
DATE_FORMAT(cc.publish_date, '%d %b, %Y') AS publish_date,
DATEDIFF(CURDATE(), cc.close_date) AS closeday,
DATEDIFF(CURDATE(), cc.publish_date) AS startday,
tl.locationName,
cd.dateSpecification
FROM course_duration cd
LEFT JOIN course_info ci ON ci.courseID = cd.courseID
LEFT JOIN course_circular cc ON cc.courseSubID = cd.courseSubID
LEFT JOIN training_location tl ON tl.locationID = cc.locationID
WHERE 1=1 && cc.status =1
&& DATEDIFF(CURDATE(), cc.publish_date)> -31
&& DATEDIFF(CURDATE(), cc.close_date) <= 0
ORDER BY cd.startDate ASC
|
| 0.0003 |
SELECT ft.* FROM tbl_flagship_training ft WHERE 1=1 && ft.activeStatus =1 ORDER BY ft.createDate DESC
|
| 0.0002 |
SELECT cp.* FROM tbl_colaborative_partner cp WHERE 1=1 && cp.activeStatus =1 ORDER BY cp.orderLevel ASC
|
| 0.0004 |
SELECT concat(DATE_FORMAT(cd.startDate, '%d %b, %Y'), ' - ', DATE_FORMAT(cd.endDate, '%d %b, %Y')) AS duration,
ci.courseName,
cd.courseSubID,
cc.circularTitle,
tl.locationName
FROM course_duration cd
LEFT JOIN course_info ci ON ci.courseID = cd.courseID
LEFT JOIN course_circular cc ON cc.courseSubID = cd.courseSubID
LEFT JOIN training_location tl ON tl.locationID = cc.locationID
WHERE 1=1 && DATEDIFF(CURDATE(), cd.startDate)>=0 && DATEDIFF(CURDATE(), cd.endDate)<=0
ORDER BY cd.startDate ASC
|
| 0.0003 |
SELECT cc.circularID FROM `career_circular_info` cc WHERE 1=1 && cc.activeStatus = 1 && (CURDATE() between cc.publishDate and cc.closeDate) LIMIT 0, 1
|
| 0.0010 |
SELECT ca.*, TIMESTAMPDIFF(SECOND, CURDATE(), ca.startDate) leftTime,
DATE_FORMAT(ca.earlyBirdRegDate, '%d %M, %Y') AS earlyBirdRegDate,
DATE_FORMAT(ca.regularRegDate, '%d %M, %Y') AS regularRegDate,
concat(DATE_FORMAT(ca.startDate, '%d %b, %Y'),' -to- ',DATE_FORMAT(ca.endDate, '%d %b, %Y')) as duration,
DATE_FORMAT(ca.lateRegDate, '%d %M, %Y') AS lateRegDate
FROM conf_detail_info ca
WHERE 1=1
AND ca.activeStatus= 1 AND ca.endDate > now() ORDER BY ca.conferenceID DESC
|
| 0.0006 |
SELECT pi.*, DATE_FORMAT(pi.promoStart, '%d %M, %Y') AS promoStart
FROM add_promo_info pi WHERE 1=1 && pi.activeStatus = 1 && (CURDATE() between promoStart and promoEnd) ORDER BY pi.promoStart DESC LIMIT 0, 1
|
| 0.0006 |
SELECT tf.*, DATE_FORMAT(createDate, '%d %b, %Y') AS createDate
FROM tbl_trainee_feedback tf WHERE 1=1 && feedbackType IN (0,1,2,6,7,8,9,10) && tf.activeStatus =1
ORDER BY tf.viewOrder ASC, tf.createDate DESC LIMIT 0, 200
|
| 0.0001 |
SELECT * FROM visit_counter WHERE 1=1
|
_in_South.jpg)
