BurSt

$hook->formit->options['emailTo'] = $hook->getValue('emailto');

SELECT SQL_CALC_FOUND_ROWS modResource.id, modResource.uri, modResource.class_key, modResource.pagetitle, modResource.menutitle, `medium`.`url` as medium, IFNULL(`TVimage`.`value`, '') AS `tv.image`, IFNULL(`TVshow_in_list`.`value`, 'true') AS `tv.show_in_list` 
FROM `modx_site_content` AS `modResource` 
LEFT JOIN `modx_ms2_product_files` `medium` ON `medium`.`product_id` = modResource.id AND `medium`.`path` LIKE '%/medium/%' 
LEFT JOIN `modx_site_tmplvar_contentvalues` `TVimage` ON `TVimage`.`contentid` = `modResource`.`id` AND `TVimage`.`tmplvarid` = 4 
LEFT JOIN `modx_site_tmplvar_contentvalues` `TVshow_in_list` ON `TVshow_in_list`.`contentid` = `modResource`.`id` AND `TVshow_in_list`.`tmplvarid` = 6 
WHERE ( `TVshow_in_list`.`value` = 'true' AND `modResource`.`parent` IN (20) AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 ) 
GROUP BY modResource.id 
ORDER BY modResource.menuindex ASC LIMIT 30