| 0.0009 |
SELECT `property`.*, `member`.`m_fname`, `member`.`m_lname`, `member`.`m_email`
FROM `property`
JOIN `member` ON `property`.`p_userid`=`member`.`m_userid`
WHERE `property`.`p_url` = 'emeraldinnmaplewood.com'
|
| 0.0002 |
SELECT *
FROM `search`
WHERE `s_name_combined` = 'Maplewood MN'
|
| 0.0003 |
UPDATE `property` SET `p_tot` = '7.13'
WHERE `p_id` = '2483'
|
| 0.0003 |
SELECT *
FROM `property_amenities`
WHERE `pa_pid` = '2483'
ORDER BY `pa_sort` ASC
|
| 0.0003 |
SELECT *
FROM `property_attractions`
WHERE `pt_pid` = '2483'
ORDER BY `pt_sort` DESC, `pt_minutes` ASC
|
| 0.0002 |
SELECT `flag_1`, `flag_2`, `weekly_email_quota`, `inactivity_reminder`, `apology_letter`, `signature`
FROM `review_settings`
WHERE `property_id` = '2483'
|
| 0.0002 |
SELECT *
FROM `property_custom_pages`
WHERE `p_id` = '2483'
AND `show_menu` = 1
|
| 0.0002 |
SELECT *
FROM `property_custom_pages`
WHERE `p_id` = '2483'
AND `show_sidebar` = 1
|
