0
Answer

minimization of mysql query

Ankita Kumari

Ankita Kumari
3y
841
1

SELECT * FROM bussiness_setting WHERE `start`>=(SELECT DATE_FORMAT(CONVERT_TZ(NOW(),
(SELECT `diff` FROM `timezones` WHERE `abbr_full`= (SELECT @@system_time_zone)),
(SELECT `diff` FROM `timezones` WHERE `abbr`='CT')),'%h:%i %p')) AND `end` >=(SELECT DATE_FORMAT(CONVERT_TZ(NOW(),
(SELECT `diff` FROM `timezones` WHERE `abbr_full`= (SELECT @@system_time_zone)),
(SELECT `diff` FROM `timezones` WHERE `abbr`='CT')),'%h:%i %p')) AND iduser=2

please minimize this query??

Next Recommended Forum