Assuming catid is required, the following 5 results were found.
from J15 and insert as assets in J30 SET @new_jos_assets_last_inc=( SELECT (SUBSTRING_INDEX(`name`, '.', -1)*1) AS lastcatid FROM `my_new_database`.my_prefix_assets WHERE `name` LIKE '%.category.%' ORDER BY `lastcatid` DESC LIMIT 0,1); SET...
`v25_db`.`v25_categories` WHERE extension='com_content' AND alias='uncategorised'); UPDATE `v34_db`.`v34_categories` SET `catid` = @uncategorisedCategoryID_new WHERE `catid` = @uncategorisedCategoryID_old; UPDATE `v34_db`.`v34_content` SET `catid` =...
change: // We need to get a list of all weblinks in the given category $query = 'SELECT *' . ' FROM #__weblinks' . ' WHERE catid = '. (int) $this->_id. ' AND published = 1' . ' AND archived = 0'; $query.=($filter_order!="ordering")?' ORDER BY '....
AS 'taxonomy', a.description 'description', 0 'parent', (SELECT COUNT(c.id) FROM my_joomla_db.jos_content c WHERE c.catid=a.id) 'count' FROM my_joomla_db.jos_categories a ORDER BY a.id; INSERT INTO my_wordpress_db.wp_term_relationships SELECT b.id...
= JText::_( 'Thank you for your e-mail'); $link = JRoute::_('index.php?option=com_contact&view=contact&id='.$contact->slug.'&catid='.$contact->catslug, false); $this->setRedirect($link, $msg);