SQL prepared "SELECT SQL_CALC_FOUND_ROWS `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, IFNULL(`TVimg`.`value`, '') AS `tv.img`, IFNULL(`TVcity`.`value`, '') AS `tv.city`, IFNULL(`TVaddress`.`value`, '') AS `tv.address`, IFNULL(`TVs`.`value`, '') AS `tv.s`, IFNULL(`TVobj-type`.`value`, '') AS `tv.obj-type` FROM `modxarenda_site_content` AS `modResource` LEFT JOIN `modxarenda_site_tmplvar_contentvalues` `TVimg` ON `TVimg`.`contentid` = `modResource`.`id` AND `TVimg`.`tmplvarid` = 1 LEFT JOIN `modxarenda_site_tmplvar_contentvalues` `TVcity` ON `TVcity`.`contentid` = `modResource`.`id` AND `TVcity`.`tmplvarid` = 7 LEFT JOIN `modxarenda_site_tmplvar_contentvalues` `TVaddress` ON `TVaddress`.`contentid` = `modResource`.`id` AND `TVaddress`.`tmplvarid` = 8 LEFT JOIN `modxarenda_site_tmplvar_contentvalues` `TVs` ON `TVs`.`contentid` = `modResource`.`id` AND `TVs`.`tmplvarid` = 9 LEFT JOIN `modxarenda_site_tmplvar_contentvalues` `TVobj-type` ON `TVobj-type`.`contentid` = `modResource`.`id` AND `TVobj-type`.`tmplvarid` = 26 WHERE  ( `modResource`.`parent` IN (3,12,16,17) AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 )  ORDER BY CAST(`TVs`.`value` AS DECIMAL(13,3)) DESC LIMIT 9 "