SELECT /*SELECT*/ this.`product_id`, this.`date_added`, this.`title`, this.`url_name`, this.`short_desc`, this.`theme`, this.`seo_keywords`, this.`share_msg`, this.`description`, this.`features`, this.`is_external`, this.`external_content`, this.`show_qty_input`, this.`affiliate_commission_group`, this.`taxable`, this.`scheduled_purchase_product`, this.`scheduled_purchase_delay`, this.`scheduled_purchase_auto_create`, this.`on_purchase_permission_group`, this.`limit_qty`, this.`brand`, this.`sort_order`, this.`visible` /*FROM*/ FROM products AS this /*JOIN*/ INNER JOIN products2folders AS p2f ON (p2f.product_id = this.product_id ) INNER JOIN product_folders AS pf ON (pf.folderID = p2f.folderID ) /*WHERE*/ WHERE ((`this`.`visible`=1) AND(pf.folderID=11) AND(pf.access_group_view IN ('Anonymous Only','Everyone'))) /*AND*/ /*GROUP BY*/ /*ORDER BY*/ ORDER BY p2f.sort_order, this.sort_order, this.product_id ASC
