->addSelect(\DB::raw('(SUM(products_reviews.rating) / COUNT(products_reviews.id)) as `rating`'))->addSelect(\DB::raw('
SELECT
(SUM(products_reviews.rating) / COUNT(products_reviews.id)) AS `rating`
FROM products_reviews
WHERE
products_reviews.product_id = products.id
AND products_reviews.is_published = 1
AND products_reviews.rating != 1
'))create server role blind_users;
deny view any database to blind_users;
alter server role blind_users add member login_name;SET @@sql_mode = 'TRADITIONAL';
DELIMITER $$
CREATE DEFINER=`root`@`%` TRIGGER `hlstats_Players_after_insert`
AFTER INSERT ON `hlstats_Players`
FOR EACH ROW
BEGIN
IF NEW.`game` = "tf" OR NEW.`game`= "tf2ser2" THEN
INSERT INTO data_orange SET playerId = NEW.playerId;
END IF;
END$$ALTER TABLE `table_name` ADD UNIQUE (`language`, 'ID');DELIMITER ;
DROP PROCEDURE IF EXISTS createLocalizedPage;
DELIMITER $
CREATE PROCEDURE createLocalizedPage(
IN language_in VARCHAR(20),
IN image_path_in VARCHAR(120),
IN page_content_in LONGTEXT
) SQL SECURITY INVOKER
BEGIN
DECLARE var_page_unique_id INT;
START TRANSACTION ;
IF (exists(SELECT 1 from `table_name` where image_path = image_path_in)) THEN
SET var_page_unique_id = (select max(`ID`) + 1 from `table_name`);
ELSE
SET var_page_unique_id = (select `ID` from `table_name` where image_path = image_path_in);
END IF;
INSERT INTO `table_name` (`language`, `image_path`, `page_content`, `ID`) VALUES
(language_in, image_path_in, page_content_in, var_page_unique_id);
COMMIT ;
END $
DELIMITER ;INSERT INTO `table_name` (`language`, `image_path`, `page_content`, `ID`)
VALUES (
language_in,
image_path_in,
page_content_in,
CASE
WHEN exists(SELECT 1 from `table_name` where image_path = image_path_in) then
(select `ID` from `table_name` where image_path = image_path_in)
ELSE
(select max(`ID`) + 1 from `table_name`)
END
);SELECT
cast(title as VARCHAR(200) CHARACTER SET utf8) COLLATE utf8_general_ci as t
FROM `tb1`
UNION ALL
SELECT cast(message as varchar(200) CHARACTER SET utf8) COLLATE utf8_general_ci as t
FROM `tb2`INSERT INTO target_table (field1, field2)
SELECT field1, field2 FROM temporary_table WHERE not EXISTS(
select 1 from target_table where temporary_table.id = target_table.id
)SELECT SUBSTRING_INDEX(field_name, ' ', 10) FROM table_name WHERE conditionSELECT a.*,
album_photos.file,
album_photos.date,
(select COUNT(id) from photos where album_id = a.id) as photo_count
FROM
`albums` as a
left join photos as album_photos on a.id = album_photos.album_id
and album_photos.`date` = ( select max(`date`) from `photos` where album_id = a.id)
WHERE
a.`user_id` = 1
ORDER BY
a.`date` DESC
LIMIT 10WHERE
(t3.name = 'black' and t5.name = 'S')
and
(t3.name = 'black' and t5.name = 'M')
and
(t5.name = 'L')