| 0.0003 |
INSERT INTO `mz_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('a739660af0a5c915cbb6a2a9f8899fd6', '38.107.179.217', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1337527519)
|
| 0.0001 |
SELECT `city_id`, `city_name`, `city_url`
FROM (`mz_cities`)
WHERE `city_active` = 1
|
| 0.0004 |
SELECT `discount_id`, `discount_name_summary`
FROM (`mz_discounts`)
WHERE DATEDIFF(discount_end, now()) >= 0
AND DATEDIFF(discount_start, now()) <= 0
AND `discount_top` = 1
AND `discount_active` = 1
ORDER BY `discount_position` asc
|
| 0.0003 |
SELECT `discount_id`, `discount_name_summary`
FROM (`mz_discounts`)
WHERE DATEDIFF(discount_end, now()) >= 0
AND DATEDIFF(discount_start, now()) <= 0
AND `discount_active` = 1
ORDER BY `discount_position` asc
|
| 0.0002 |
SELECT `discount_id`, `discount_name_summary`
FROM (`mz_discounts`)
WHERE DATEDIFF(discount_end, now()) >= 0
AND DATEDIFF(discount_start, now()) <= 0
AND `discount_top` = 1
AND `discount_active` = 1
ORDER BY `discount_position` asc
|
| 0.0002 |
SELECT `discount_id`, `discount_name_summary`
FROM (`mz_discounts`)
WHERE DATEDIFF(discount_end, now()) >= 0
AND DATEDIFF(discount_start, now()) <= 0
AND `discount_active` = 1
ORDER BY `discount_position` asc
|
| 0.0004 |
SELECT `discount_id`, `discount_name`, `discount_name_summary`, `discount_start`, `discount_end`, `discount_defaultprice`, `discount_price`, `discount_saving`, `discount_image`
FROM (`mz_discounts`)
WHERE `discount_id` != '6'
AND DATEDIFF(discount_end, now()) >= 0
AND DATEDIFF(discount_start, now()) <= 0
AND `discount_active` = 1
AND `discount_id` != '6'
GROUP BY `discount_id`
ORDER BY `discount_position` asc
LIMIT 100
|
| 0.0004 |
SELECT `c`.`company_name`, `c`.`company_address`, `c`.`company_email`, `c`.`company_phone`, `c`.`company_web`, `c`.`company_info`, `c`.`company_map`, `d`.`discount_id`, `d`.`discount_company`, `d`.`discount_name`, `d`.`discount_name_summary`, `d`.`discount_ownprice`, `d`.`discount_minprice`, `d`.`discount_maxprice`, `d`.`discount_saving`, `d`.`discount_price`, `d`.`discount_defaultprice`, `d`.`discount_image`, `d`.`discount_info`, `d`.`discount_shortinfo`, `d`.`discount_terms`, `d`.`discount_end`, `d`.`discount_min`, `d`.`discount_max`, `d`.`discount_comment`, `discount_latitude`, `discount_longitude`
FROM (`mz_discounts` d)
JOIN `mz_companies` c ON `c`.`company_id` = `d`.`discount_company`
WHERE DATEDIFF(d.discount_end, now()) >= 0
AND DATEDIFF(d.discount_start, now()) <= 0
AND `d`.`discount_top` = 1
AND `d`.`discount_active` = 1
ORDER BY `d`.`discount_start` desc
LIMIT 1
|
| 0.0004 |
SELECT `c`.`company_name`, `c`.`company_address`, `c`.`company_email`, `c`.`company_phone`, `c`.`company_web`, `c`.`company_info`, `c`.`company_map`, `d`.`discount_id`, `d`.`discount_company`, `d`.`discount_name`, `d`.`discount_name_summary`, `d`.`discount_ownprice`, `d`.`discount_minprice`, `d`.`discount_maxprice`, `d`.`discount_saving`, `d`.`discount_price`, `d`.`discount_defaultprice`, `d`.`discount_image`, `d`.`discount_info`, `d`.`discount_shortinfo`, `d`.`discount_terms`, `d`.`discount_end`, `d`.`discount_min`, `d`.`discount_max`, `d`.`discount_comment`, `discount_latitude`, `discount_longitude`
FROM (`mz_discounts` d)
JOIN `mz_companies` c ON `c`.`company_id` = `d`.`discount_company`
WHERE DATEDIFF(d.discount_end, now()) >= 0
AND DATEDIFF(d.discount_start, now()) <= 0
AND `d`.`discount_active` = 1
ORDER BY `d`.`discount_start` desc
LIMIT 1
|
| 0.0001 |
SELECT SUM(`order_count`) AS order_count
FROM (`mz_orders`)
WHERE `order_discount` = '4'
|
Social