ON = joom_assets.idjoom_assets.parent_idjoom_assets.lftjoom_assets.rgtjoom_assets.leveljoom_assets.namejoom_assets.titlejoom_assets.rules
id [ name ] [ col position ] [ order by ] [ filter ]
parent_id [ name ] [ col position ] [ order by ] [ filter ]
lft [ name ] [ col position ] [ order by ] [ filter ]
rgt [ name ] [ col position ] [ order by ] [ filter ]
level [ name ] [ col position ] [ order by ] [ filter ]
name [ name ] [ col position ] [ order by ] [ filter ]
title [ name ] [ col position ] [ order by ] [ filter ]
rules [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_associations.idjoom_associations.contextjoom_associations.key
context [ name ] [ col position ] [ order by ] [ filter ]
key [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_banner_clients.idjoom_banner_clients.namejoom_banner_clients.contactjoom_banner_clients.emailjoom_banner_clients.extrainfojoom_banner_clients.statejoom_banner_clients.checked_outjoom_banner_clients.checked_out_timejoom_banner_clients.metakeyjoom_banner_clients.own_prefixjoom_banner_clients.metakey_prefixjoom_banner_clients.purchase_typejoom_banner_clients.track_clicksjoom_banner_clients.track_impressions
contact [ name ] [ col position ] [ order by ] [ filter ]
email [ name ] [ col position ] [ order by ] [ filter ]
extrainfo [ name ] [ col position ] [ order by ] [ filter ]
state [ name ] [ col position ] [ order by ] [ filter ]
checked_out [ name ] [ col position ] [ order by ] [ filter ]
checked_out_time [ name ] [ col position ] [ order by ] [ filter ]
metakey [ name ] [ col position ] [ order by ] [ filter ]
own_prefix [ name ] [ col position ] [ order by ] [ filter ]
metakey_prefix [ name ] [ col position ] [ order by ] [ filter ]
purchase_type [ name ] [ col position ] [ order by ] [ filter ]
track_clicks [ name ] [ col position ] [ order by ] [ filter ]
track_impressions [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_banner_tracks.track_datejoom_banner_tracks.track_typejoom_banner_tracks.banner_idjoom_banner_tracks.count
track_date [ name ] [ col position ] [ order by ] [ filter ]
track_type [ name ] [ col position ] [ order by ] [ filter ]
banner_id [ name ] [ col position ] [ order by ] [ filter ]
count [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_banners.idjoom_banners.cidjoom_banners.typejoom_banners.namejoom_banners.aliasjoom_banners.imptotaljoom_banners.impmadejoom_banners.clicksjoom_banners.clickurljoom_banners.statejoom_banners.catidjoom_banners.descriptionjoom_banners.custombannercodejoom_banners.stickyjoom_banners.orderingjoom_banners.metakeyjoom_banners.paramsjoom_banners.own_prefixjoom_banners.metakey_prefixjoom_banners.purchase_typejoom_banners.track_clicksjoom_banners.track_impressionsjoom_banners.checked_outjoom_banners.checked_out_timejoom_banners.publish_upjoom_banners.publish_downjoom_banners.resetjoom_banners.createdjoom_banners.language
cid [ name ] [ col position ] [ order by ] [ filter ]
type [ name ] [ col position ] [ order by ] [ filter ]
alias [ name ] [ col position ] [ order by ] [ filter ]
imptotal [ name ] [ col position ] [ order by ] [ filter ]
impmade [ name ] [ col position ] [ order by ] [ filter ]
clicks [ name ] [ col position ] [ order by ] [ filter ]
clickurl [ name ] [ col position ] [ order by ] [ filter ]
catid [ name ] [ col position ] [ order by ] [ filter ]
description [ name ] [ col position ] [ order by ] [ filter ]
custombannercode [ name ] [ col position ] [ order by ] [ filter ]
sticky [ name ] [ col position ] [ order by ] [ filter ]
ordering [ name ] [ col position ] [ order by ] [ filter ]
params [ name ] [ col position ] [ order by ] [ filter ]
publish_up [ name ] [ col position ] [ order by ] [ filter ]
publish_down [ name ] [ col position ] [ order by ] [ filter ]
reset [ name ] [ col position ] [ order by ] [ filter ]
created [ name ] [ col position ] [ order by ] [ filter ]
language [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_categories.idjoom_categories.asset_idjoom_categories.parent_idjoom_categories.lftjoom_categories.rgtjoom_categories.leveljoom_categories.pathjoom_categories.extensionjoom_categories.titlejoom_categories.aliasjoom_categories.notejoom_categories.descriptionjoom_categories.publishedjoom_categories.checked_outjoom_categories.checked_out_timejoom_categories.accessjoom_categories.paramsjoom_categories.metadescjoom_categories.metakeyjoom_categories.metadatajoom_categories.created_user_idjoom_categories.created_timejoom_categories.modified_user_idjoom_categories.modified_timejoom_categories.hitsjoom_categories.language
asset_id [ name ] [ col position ] [ order by ] [ filter ]
path [ name ] [ col position ] [ order by ] [ filter ]
extension [ name ] [ col position ] [ order by ] [ filter ]
note [ name ] [ col position ] [ order by ] [ filter ]
published [ name ] [ col position ] [ order by ] [ filter ]
access [ name ] [ col position ] [ order by ] [ filter ]
metadesc [ name ] [ col position ] [ order by ] [ filter ]
metadata [ name ] [ col position ] [ order by ] [ filter ]
created_user_id [ name ] [ col position ] [ order by ] [ filter ]
created_time [ name ] [ col position ] [ order by ] [ filter ]
modified_user_id [ name ] [ col position ] [ order by ] [ filter ]
modified_time [ name ] [ col position ] [ order by ] [ filter ]
hits [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_contact_details.idjoom_contact_details.namejoom_contact_details.aliasjoom_contact_details.con_positionjoom_contact_details.addressjoom_contact_details.suburbjoom_contact_details.statejoom_contact_details.countryjoom_contact_details.postcodejoom_contact_details.telephonejoom_contact_details.faxjoom_contact_details.miscjoom_contact_details.imagejoom_contact_details.imageposjoom_contact_details.email_tojoom_contact_details.default_conjoom_contact_details.publishedjoom_contact_details.checked_outjoom_contact_details.checked_out_timejoom_contact_details.orderingjoom_contact_details.paramsjoom_contact_details.user_idjoom_contact_details.catidjoom_contact_details.accessjoom_contact_details.mobilejoom_contact_details.webpagejoom_contact_details.sortname1joom_contact_details.sortname2joom_contact_details.sortname3joom_contact_details.languagejoom_contact_details.createdjoom_contact_details.created_byjoom_contact_details.created_by_aliasjoom_contact_details.modifiedjoom_contact_details.modified_byjoom_contact_details.metakeyjoom_contact_details.metadescjoom_contact_details.metadatajoom_contact_details.featuredjoom_contact_details.xreferencejoom_contact_details.publish_upjoom_contact_details.publish_down
con_position [ name ] [ col position ] [ order by ] [ filter ]
address [ name ] [ col position ] [ order by ] [ filter ]
suburb [ name ] [ col position ] [ order by ] [ filter ]
country [ name ] [ col position ] [ order by ] [ filter ]
postcode [ name ] [ col position ] [ order by ] [ filter ]
telephone [ name ] [ col position ] [ order by ] [ filter ]
fax [ name ] [ col position ] [ order by ] [ filter ]
misc [ name ] [ col position ] [ order by ] [ filter ]
image [ name ] [ col position ] [ order by ] [ filter ]
imagepos [ name ] [ col position ] [ order by ] [ filter ]
email_to [ name ] [ col position ] [ order by ] [ filter ]
default_con [ name ] [ col position ] [ order by ] [ filter ]
user_id [ name ] [ col position ] [ order by ] [ filter ]
mobile [ name ] [ col position ] [ order by ] [ filter ]
webpage [ name ] [ col position ] [ order by ] [ filter ]
sortname1 [ name ] [ col position ] [ order by ] [ filter ]
sortname2 [ name ] [ col position ] [ order by ] [ filter ]
sortname3 [ name ] [ col position ] [ order by ] [ filter ]
created_by [ name ] [ col position ] [ order by ] [ filter ]
created_by_alias [ name ] [ col position ] [ order by ] [ filter ]
modified [ name ] [ col position ] [ order by ] [ filter ]
modified_by [ name ] [ col position ] [ order by ] [ filter ]
featured [ name ] [ col position ] [ order by ] [ filter ]
xreference [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_content.idjoom_content.asset_idjoom_content.titlejoom_content.aliasjoom_content.title_aliasjoom_content.introtextjoom_content.fulltextjoom_content.statejoom_content.sectionidjoom_content.maskjoom_content.catidjoom_content.createdjoom_content.created_byjoom_content.created_by_aliasjoom_content.modifiedjoom_content.modified_byjoom_content.checked_outjoom_content.checked_out_timejoom_content.publish_upjoom_content.publish_downjoom_content.imagesjoom_content.urlsjoom_content.attribsjoom_content.versionjoom_content.parentidjoom_content.orderingjoom_content.metakeyjoom_content.metadescjoom_content.accessjoom_content.hitsjoom_content.metadatajoom_content.featuredjoom_content.languagejoom_content.xreference
title_alias [ name ] [ col position ] [ order by ] [ filter ]
introtext [ name ] [ col position ] [ order by ] [ filter ]
fulltext [ name ] [ col position ] [ order by ] [ filter ]
sectionid [ name ] [ col position ] [ order by ] [ filter ]
mask [ name ] [ col position ] [ order by ] [ filter ]
images [ name ] [ col position ] [ order by ] [ filter ]
urls [ name ] [ col position ] [ order by ] [ filter ]
attribs [ name ] [ col position ] [ order by ] [ filter ]
version [ name ] [ col position ] [ order by ] [ filter ]
parentid [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_content_frontpage.content_idjoom_content_frontpage.ordering
content_id [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_content_rating.content_idjoom_content_rating.rating_sumjoom_content_rating.rating_countjoom_content_rating.lastip
rating_sum [ name ] [ col position ] [ order by ] [ filter ]
rating_count [ name ] [ col position ] [ order by ] [ filter ]
lastip [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_core_log_searches.search_termjoom_core_log_searches.hits
search_term [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_extensions.extension_idjoom_extensions.namejoom_extensions.typejoom_extensions.elementjoom_extensions.folderjoom_extensions.client_idjoom_extensions.enabledjoom_extensions.accessjoom_extensions.protectedjoom_extensions.manifest_cachejoom_extensions.paramsjoom_extensions.custom_datajoom_extensions.system_datajoom_extensions.checked_outjoom_extensions.checked_out_timejoom_extensions.orderingjoom_extensions.state
extension_id [ name ] [ col position ] [ order by ] [ filter ]
element [ name ] [ col position ] [ order by ] [ filter ]
folder [ name ] [ col position ] [ order by ] [ filter ]
client_id [ name ] [ col position ] [ order by ] [ filter ]
enabled [ name ] [ col position ] [ order by ] [ filter ]
protected [ name ] [ col position ] [ order by ] [ filter ]
manifest_cache [ name ] [ col position ] [ order by ] [ filter ]
custom_data [ name ] [ col position ] [ order by ] [ filter ]
system_data [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_finder_filters.filter_idjoom_finder_filters.titlejoom_finder_filters.aliasjoom_finder_filters.statejoom_finder_filters.createdjoom_finder_filters.created_byjoom_finder_filters.created_by_aliasjoom_finder_filters.modifiedjoom_finder_filters.modified_byjoom_finder_filters.checked_outjoom_finder_filters.checked_out_timejoom_finder_filters.map_countjoom_finder_filters.datajoom_finder_filters.params
filter_id [ name ] [ col position ] [ order by ] [ filter ]
map_count [ name ] [ col position ] [ order by ] [ filter ]
data [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_finder_links.link_idjoom_finder_links.urljoom_finder_links.routejoom_finder_links.titlejoom_finder_links.descriptionjoom_finder_links.indexdatejoom_finder_links.md5sumjoom_finder_links.publishedjoom_finder_links.statejoom_finder_links.accessjoom_finder_links.languagejoom_finder_links.publish_start_datejoom_finder_links.publish_end_datejoom_finder_links.start_datejoom_finder_links.end_datejoom_finder_links.list_pricejoom_finder_links.sale_pricejoom_finder_links.type_idjoom_finder_links.object
link_id [ name ] [ col position ] [ order by ] [ filter ]
url [ name ] [ col position ] [ order by ] [ filter ]
route [ name ] [ col position ] [ order by ] [ filter ]
indexdate [ name ] [ col position ] [ order by ] [ filter ]
md5sum [ name ] [ col position ] [ order by ] [ filter ]
publish_start_date [ name ] [ col position ] [ order by ] [ filter ]
publish_end_date [ name ] [ col position ] [ order by ] [ filter ]
start_date [ name ] [ col position ] [ order by ] [ filter ]
end_date [ name ] [ col position ] [ order by ] [ filter ]
list_price [ name ] [ col position ] [ order by ] [ filter ]
sale_price [ name ] [ col position ] [ order by ] [ filter ]
type_id [ name ] [ col position ] [ order by ] [ filter ]
object [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_finder_links_terms0.link_idjoom_finder_links_terms0.term_idjoom_finder_links_terms0.weight
term_id [ name ] [ col position ] [ order by ] [ filter ]
weight [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_finder_links_terms1.link_idjoom_finder_links_terms1.term_idjoom_finder_links_terms1.weight
ON = joom_finder_links_terms2.link_idjoom_finder_links_terms2.term_idjoom_finder_links_terms2.weight
ON = joom_finder_links_terms3.link_idjoom_finder_links_terms3.term_idjoom_finder_links_terms3.weight
ON = joom_finder_links_terms4.link_idjoom_finder_links_terms4.term_idjoom_finder_links_terms4.weight
ON = joom_finder_links_terms5.link_idjoom_finder_links_terms5.term_idjoom_finder_links_terms5.weight
ON = joom_finder_links_terms6.link_idjoom_finder_links_terms6.term_idjoom_finder_links_terms6.weight
ON = joom_finder_links_terms7.link_idjoom_finder_links_terms7.term_idjoom_finder_links_terms7.weight
ON = joom_finder_links_terms8.link_idjoom_finder_links_terms8.term_idjoom_finder_links_terms8.weight
ON = joom_finder_links_terms9.link_idjoom_finder_links_terms9.term_idjoom_finder_links_terms9.weight
ON = joom_finder_links_termsa.link_idjoom_finder_links_termsa.term_idjoom_finder_links_termsa.weight
ON = joom_finder_links_termsb.link_idjoom_finder_links_termsb.term_idjoom_finder_links_termsb.weight
ON = joom_finder_links_termsc.link_idjoom_finder_links_termsc.term_idjoom_finder_links_termsc.weight
ON = joom_finder_links_termsd.link_idjoom_finder_links_termsd.term_idjoom_finder_links_termsd.weight
ON = joom_finder_links_termse.link_idjoom_finder_links_termse.term_idjoom_finder_links_termse.weight
ON = joom_finder_links_termsf.link_idjoom_finder_links_termsf.term_idjoom_finder_links_termsf.weight
ON = joom_finder_taxonomy.idjoom_finder_taxonomy.parent_idjoom_finder_taxonomy.titlejoom_finder_taxonomy.statejoom_finder_taxonomy.accessjoom_finder_taxonomy.ordering
ON = joom_finder_taxonomy_map.link_idjoom_finder_taxonomy_map.node_id
node_id [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_finder_terms.term_idjoom_finder_terms.termjoom_finder_terms.stemjoom_finder_terms.commonjoom_finder_terms.phrasejoom_finder_terms.weightjoom_finder_terms.soundexjoom_finder_terms.links
term [ name ] [ col position ] [ order by ] [ filter ]
stem [ name ] [ col position ] [ order by ] [ filter ]
common [ name ] [ col position ] [ order by ] [ filter ]
phrase [ name ] [ col position ] [ order by ] [ filter ]
soundex [ name ] [ col position ] [ order by ] [ filter ]
links [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_finder_terms_common.termjoom_finder_terms_common.language
ON = joom_finder_tokens.termjoom_finder_tokens.stemjoom_finder_tokens.commonjoom_finder_tokens.phrasejoom_finder_tokens.weightjoom_finder_tokens.context
ON = joom_finder_tokens_aggregate.term_idjoom_finder_tokens_aggregate.map_suffixjoom_finder_tokens_aggregate.termjoom_finder_tokens_aggregate.stemjoom_finder_tokens_aggregate.commonjoom_finder_tokens_aggregate.phrasejoom_finder_tokens_aggregate.term_weightjoom_finder_tokens_aggregate.contextjoom_finder_tokens_aggregate.context_weightjoom_finder_tokens_aggregate.total_weight
map_suffix [ name ] [ col position ] [ order by ] [ filter ]
term_weight [ name ] [ col position ] [ order by ] [ filter ]
context_weight [ name ] [ col position ] [ order by ] [ filter ]
total_weight [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_finder_types.idjoom_finder_types.titlejoom_finder_types.mime
mime [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_languages.lang_idjoom_languages.lang_codejoom_languages.titlejoom_languages.title_nativejoom_languages.sefjoom_languages.imagejoom_languages.descriptionjoom_languages.metakeyjoom_languages.metadescjoom_languages.sitenamejoom_languages.publishedjoom_languages.accessjoom_languages.ordering
lang_id [ name ] [ col position ] [ order by ] [ filter ]
lang_code [ name ] [ col position ] [ order by ] [ filter ]
title_native [ name ] [ col position ] [ order by ] [ filter ]
sef [ name ] [ col position ] [ order by ] [ filter ]
sitename [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_menu.idjoom_menu.menutypejoom_menu.titlejoom_menu.aliasjoom_menu.notejoom_menu.pathjoom_menu.linkjoom_menu.typejoom_menu.publishedjoom_menu.parent_idjoom_menu.leveljoom_menu.component_idjoom_menu.orderingjoom_menu.checked_outjoom_menu.checked_out_timejoom_menu.browserNavjoom_menu.accessjoom_menu.imgjoom_menu.template_style_idjoom_menu.paramsjoom_menu.lftjoom_menu.rgtjoom_menu.homejoom_menu.languagejoom_menu.client_id
menutype [ name ] [ col position ] [ order by ] [ filter ]
link [ name ] [ col position ] [ order by ] [ filter ]
component_id [ name ] [ col position ] [ order by ] [ filter ]
browserNav [ name ] [ col position ] [ order by ] [ filter ]
img [ name ] [ col position ] [ order by ] [ filter ]
template_style_id [ name ] [ col position ] [ order by ] [ filter ]
home [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_menu_types.idjoom_menu_types.menutypejoom_menu_types.titlejoom_menu_types.description
ON = joom_messages.message_idjoom_messages.user_id_fromjoom_messages.user_id_tojoom_messages.folder_idjoom_messages.date_timejoom_messages.statejoom_messages.priorityjoom_messages.subjectjoom_messages.message
message_id [ name ] [ col position ] [ order by ] [ filter ]
user_id_from [ name ] [ col position ] [ order by ] [ filter ]
user_id_to [ name ] [ col position ] [ order by ] [ filter ]
folder_id [ name ] [ col position ] [ order by ] [ filter ]
date_time [ name ] [ col position ] [ order by ] [ filter ]
priority [ name ] [ col position ] [ order by ] [ filter ]
subject [ name ] [ col position ] [ order by ] [ filter ]
message [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_messages_cfg.user_idjoom_messages_cfg.cfg_namejoom_messages_cfg.cfg_value
cfg_name [ name ] [ col position ] [ order by ] [ filter ]
cfg_value [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_modules.idjoom_modules.titlejoom_modules.notejoom_modules.contentjoom_modules.orderingjoom_modules.positionjoom_modules.checked_outjoom_modules.checked_out_timejoom_modules.publish_upjoom_modules.publish_downjoom_modules.publishedjoom_modules.modulejoom_modules.accessjoom_modules.showtitlejoom_modules.paramsjoom_modules.client_idjoom_modules.language
content [ name ] [ col position ] [ order by ] [ filter ]
position [ name ] [ col position ] [ order by ] [ filter ]
module [ name ] [ col position ] [ order by ] [ filter ]
showtitle [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_modules_menu.moduleidjoom_modules_menu.menuid
moduleid [ name ] [ col position ] [ order by ] [ filter ]
menuid [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_newsfeeds.catidjoom_newsfeeds.idjoom_newsfeeds.namejoom_newsfeeds.aliasjoom_newsfeeds.linkjoom_newsfeeds.filenamejoom_newsfeeds.publishedjoom_newsfeeds.numarticlesjoom_newsfeeds.cache_timejoom_newsfeeds.checked_outjoom_newsfeeds.checked_out_timejoom_newsfeeds.orderingjoom_newsfeeds.rtljoom_newsfeeds.accessjoom_newsfeeds.languagejoom_newsfeeds.paramsjoom_newsfeeds.createdjoom_newsfeeds.created_byjoom_newsfeeds.created_by_aliasjoom_newsfeeds.modifiedjoom_newsfeeds.modified_byjoom_newsfeeds.metakeyjoom_newsfeeds.metadescjoom_newsfeeds.metadatajoom_newsfeeds.xreferencejoom_newsfeeds.publish_upjoom_newsfeeds.publish_down
filename [ name ] [ col position ] [ order by ] [ filter ]
numarticles [ name ] [ col position ] [ order by ] [ filter ]
cache_time [ name ] [ col position ] [ order by ] [ filter ]
rtl [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_overrider.idjoom_overrider.constantjoom_overrider.stringjoom_overrider.file
constant [ name ] [ col position ] [ order by ] [ filter ]
string [ name ] [ col position ] [ order by ] [ filter ]
file [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_redirect_links.idjoom_redirect_links.old_urljoom_redirect_links.new_urljoom_redirect_links.refererjoom_redirect_links.commentjoom_redirect_links.hitsjoom_redirect_links.publishedjoom_redirect_links.created_datejoom_redirect_links.modified_date
old_url [ name ] [ col position ] [ order by ] [ filter ]
new_url [ name ] [ col position ] [ order by ] [ filter ]
referer [ name ] [ col position ] [ order by ] [ filter ]
comment [ name ] [ col position ] [ order by ] [ filter ]
created_date [ name ] [ col position ] [ order by ] [ filter ]
modified_date [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_schemas.extension_idjoom_schemas.version_id
version_id [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_session.session_idjoom_session.client_idjoom_session.guestjoom_session.timejoom_session.datajoom_session.useridjoom_session.usernamejoom_session.usertype
session_id [ name ] [ col position ] [ order by ] [ filter ]
guest [ name ] [ col position ] [ order by ] [ filter ]
time [ name ] [ col position ] [ order by ] [ filter ]
userid [ name ] [ col position ] [ order by ] [ filter ]
username [ name ] [ col position ] [ order by ] [ filter ]
usertype [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_template_styles.idjoom_template_styles.templatejoom_template_styles.client_idjoom_template_styles.homejoom_template_styles.titlejoom_template_styles.params
template [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_update_categories.categoryidjoom_update_categories.namejoom_update_categories.descriptionjoom_update_categories.parentjoom_update_categories.updatesite
categoryid [ name ] [ col position ] [ order by ] [ filter ]
parent [ name ] [ col position ] [ order by ] [ filter ]
updatesite [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_update_sites.update_site_idjoom_update_sites.namejoom_update_sites.typejoom_update_sites.locationjoom_update_sites.enabledjoom_update_sites.last_check_timestamp
update_site_id [ name ] [ col position ] [ order by ] [ filter ]
location [ name ] [ col position ] [ order by ] [ filter ]
last_check_timestamp [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_update_sites_extensions.update_site_idjoom_update_sites_extensions.extension_id
ON = joom_updates.update_idjoom_updates.update_site_idjoom_updates.extension_idjoom_updates.categoryidjoom_updates.namejoom_updates.descriptionjoom_updates.elementjoom_updates.typejoom_updates.folderjoom_updates.client_idjoom_updates.versionjoom_updates.datajoom_updates.detailsurljoom_updates.infourl
update_id [ name ] [ col position ] [ order by ] [ filter ]
detailsurl [ name ] [ col position ] [ order by ] [ filter ]
infourl [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_user_notes.idjoom_user_notes.user_idjoom_user_notes.catidjoom_user_notes.subjectjoom_user_notes.bodyjoom_user_notes.statejoom_user_notes.checked_outjoom_user_notes.checked_out_timejoom_user_notes.created_user_idjoom_user_notes.created_timejoom_user_notes.modified_user_idjoom_user_notes.modified_timejoom_user_notes.review_timejoom_user_notes.publish_upjoom_user_notes.publish_down
body [ name ] [ col position ] [ order by ] [ filter ]
review_time [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_user_profiles.user_idjoom_user_profiles.profile_keyjoom_user_profiles.profile_valuejoom_user_profiles.ordering
profile_key [ name ] [ col position ] [ order by ] [ filter ]
profile_value [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_user_usergroup_map.user_idjoom_user_usergroup_map.group_id
group_id [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_usergroups.idjoom_usergroups.parent_idjoom_usergroups.lftjoom_usergroups.rgtjoom_usergroups.title
ON = joom_users.idjoom_users.namejoom_users.usernamejoom_users.emailjoom_users.passwordjoom_users.usertypejoom_users.blockjoom_users.sendEmailjoom_users.registerDatejoom_users.lastvisitDatejoom_users.activationjoom_users.paramsjoom_users.lastResetTimejoom_users.resetCount
password [ name ] [ col position ] [ order by ] [ filter ]
block [ name ] [ col position ] [ order by ] [ filter ]
sendEmail [ name ] [ col position ] [ order by ] [ filter ]
registerDate [ name ] [ col position ] [ order by ] [ filter ]
lastvisitDate [ name ] [ col position ] [ order by ] [ filter ]
activation [ name ] [ col position ] [ order by ] [ filter ]
lastResetTime [ name ] [ col position ] [ order by ] [ filter ]
resetCount [ name ] [ col position ] [ order by ] [ filter ]
ON = joom_viewlevels.idjoom_viewlevels.titlejoom_viewlevels.orderingjoom_viewlevels.rules
ON = joom_weblinks.idjoom_weblinks.catidjoom_weblinks.sidjoom_weblinks.titlejoom_weblinks.aliasjoom_weblinks.urljoom_weblinks.descriptionjoom_weblinks.datejoom_weblinks.hitsjoom_weblinks.statejoom_weblinks.checked_outjoom_weblinks.checked_out_timejoom_weblinks.orderingjoom_weblinks.archivedjoom_weblinks.approvedjoom_weblinks.accessjoom_weblinks.paramsjoom_weblinks.languagejoom_weblinks.createdjoom_weblinks.created_byjoom_weblinks.created_by_aliasjoom_weblinks.modifiedjoom_weblinks.modified_byjoom_weblinks.metakeyjoom_weblinks.metadescjoom_weblinks.metadatajoom_weblinks.featuredjoom_weblinks.xreferencejoom_weblinks.publish_upjoom_weblinks.publish_down
sid [ name ] [ col position ] [ order by ] [ filter ]
date [ name ] [ col position ] [ order by ] [ filter ]
archived [ name ] [ col position ] [ order by ] [ filter ]
approved [ name ] [ col position ] [ order by ] [ filter ]