u welcome, you can PM me any time.
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
October 26, 2012 11:21pm
Subscribe [2]#16 / Oct 29, 2012 11:14am
u welcome, you can PM me any time.
#17 / Oct 29, 2012 11:25am
i was able to figure out how to further filter by category… including my statement here for anybody else who might need it:
{exp:query limit="15" paginate="bottom" sql="SELECT title, url_title, field_id_51 photo_thumb_1, field_id_21 address, field_id_57 city_state, field_id_58 zip, field_id_23 submarket, field_id_24 total_size
FROM exp_channel_titles, exp_channel_data, exp_category_posts
WHERE exp_channel_titles.entry_id=exp_channel_data.entry_id
AND exp_channel_titles.entry_id=exp_category_posts.entry_id
AND exp_channel_data.channel_id='5'
AND cat_id = '19'
AND status IN ('open')
UNION ALL
SELECT title, url_title, field_id_188 photo_thumb_1, field_id_170 address, field_id_171 city_state, field_id_172 zip, field_id_176 submarket, field_id_177 total_size
FROM exp_channel_titles, exp_channel_data, exp_category_posts
WHERE exp_channel_titles.entry_id=exp_channel_data.entry_id
AND exp_channel_titles.entry_id=exp_category_posts.entry_id
AND exp_channel_data.channel_id='14'
AND cat_id = '19'
AND status IN ('open')
ORDER BY total_size DESC"}Thanks again Ahmad for your help!!!