DELETE
FROM
`oc_product`
WHERE
id IN (
SELECT
p.product_id
FROM
`oc_product` p
LEFT JOIN oc_product_description p2s ON (
p.product_id = p2s.product_id
)
LEFT JOIN oc_product_to_category p3s ON (
p.product_id = p3s.product_id
)
LEFT JOIN oc_category_description p4s ON (
p3s.category_id = p4s.category_id
)
LEFT JOIN oc_product_to_store p5s ON (
p.product_id = p5s.product_id
)
LEFT JOIN oc_product_to_layout p6s ON (
p.product_id = p6s.product_id
)
WHERE
p.manufacturer_id = '30'
)
то легко может удалить либо отредактировать любой пост
class MyModel extends \yii\base\Model
{
public $myAttributeLabels = [];
public function attributeLabels()
{
$labels = [
'attributeName' => 'Attribute Label';
];
return array_merge($this->myAttributeLabels, $labels);
}
}
class MyBehavior extends \yii\base\Behavior
{
public function attach($owner)
{
$owner->myAttributeLabels = [
'attributeName' => 'Attribute Label'
];
}
}
SET @number := 0;
SELECT
rating.*
FROM
(
SELECT
(@number := @number + 1) AS number,
user_id,
COUNT(*) AS user_commands
FROM
`log`
GROUP BY
user_id
ORDER BY
user_commands DESC
) AS rating
WHERE
rating.user_id = 2
Предполагаю, что нужно создать новое свойство в ProductsSearch и каким то образов вставлять его значение в defaultSort.
[
'name' => 'name от а до я',
'-name' => 'от я до а',
'price' => 'price по возрастанию',
-'price' => 'price по убыванию'
]
SELECT
`enrollment_for_courses`.`course_code`,
YEAR (
`enrollment_for_courses`.`date`
) as course_year,
`courses`.`code`
FROM
`enrollment_for_courses`
LEFT JOIN `courses` ON `courses`.`code` = `enrollment_for_courses`.`course_code`
AND `courses`.`year` = YEAR (`enrollment_for_courses`.`date`)
WHERE `courses`.`code` IS NULL
GROUP BY `enrollment_for_courses`.`course_code`, course_year