SELECT
				a.`alias` as catalog_alias,
				b.`alias` as category_alias,
				c.`alias` as product_alias,
				c.`tree_id`,
				c.`name`,
				c.`image`,
				c.`annotation`
			FROM
				`dbdrive_catalog` as a,
				`dbdrive_catalog_category` as b,
				`dbdrive_catalog_product` as c
			WHERE
				c.`tree_id` = 106 AND
				a.`id` = b.`catalog_id` AND
				b.`id` = c.`category_id` AND
				a.`active` = 1 AND
				b.`active` = 1 AND
				c.`active` = 1 AND
				c.`id` IN (, )
			ORDER BY
				c.`ord` 3