По названию
По ингредиентам
Искать в в рецептах в советах в темах
×
×
string(1148) "SELECT u.avatar, u.name as uname, u.username, r.*, 100 as ex_ingrs , DATE_FORMAT(r.created, '%d.%m.%Y %H:%i') as rd, GROUP_CONCAT(c.id) as cats, GROUP_CONCAT(i.id) as ingrs , c.name as catname FROM yii_recepts as r LEFT JOIN yii_recept_categories as rc ON (rc.recept_id = r.id) LEFT JOIN yii_categories as c ON (c.id = rc.category_id) LEFT JOIN yii_recept_ingridients as ri ON (ri.recept_id = r.id) LEFT JOIN yii_ingridients as i ON (i.id = ri.ingr_id) LEFT JOIN user as u ON (u.id = r.user_id) WHERE r.trash = 0 AND r.published=1 AND r.vyd=0 AND c.alias = 'napolnenie' GROUP BY r.id HAVING ex_ingrs > 0 ORDER BY ex_ingrs desc , r.created DESC "

Наполнение: 506 рецептов