SELECT *
FROM (`product`)
WHERE `online_date` <=  'now()'
AND `offline_date` >=  'now()'
AND `code` =  'boey1'
AND `language` =  'tc'
AND `status` =  100
LIMIT 1