CMS Donate Engine

mysqli://mariadb:3306/cde_test

		SELECT
			`s`.`id` as `id`,
			`s`.`sort` as `sort`,
			`s`.`img` as `img`,
			`s`.`name` as `name`,
			`s`.`server` as `server`,
			`s`.`description` as `desc`,
			`s`.`keyword` as `key`,
			`s`.`server` as `server`,
			`t`.`title` as `title`,
			`t`.`path` as `path`,
			`t`.`type` as `type`
		FROM
			`ms_store_groups` as `s`,
			`ms_servers` as `t`
		WHERE
			`t`.`id` = "38" AND
			`t`.`activ` = 1 AND
			`t`.`id` = `s`.`server`
		ORDER BY `sort`, `id` ASC
	

		SELECT
			`g`.`id` AS id,
			`g`.`sort` AS sort,
			`g`.`img` AS img,
			`g`.name AS name,
			`g`.server AS category_server,
			`s`.type AS server_type,
			`s`.path AS server_path,
			`s`.`img` AS sIMG,
			COUNT(`i`.`id`) AS item_count,
			MAX(CASE WHEN `dc`.`id` IS NOT NULL THEN 1 ELSE 0 END) AS has_discount
		FROM
			`ms_store_groups` AS `g`
		JOIN
			`ms_servers` AS `s`
			ON `s`.`id` = `g`.`server`
		JOIN 
			`ms_store` AS `i`
			ON `i`.`grid` = `g`.id
		LEFT JOIN
			`ms_discounts` AS `dc`
			ON `dc`.`item` = `i`.`id`
			AND `dc`.`flag` != 0
			AND `dc`.`day` = "d6"
		WHERE
			`s`.`id` = "38"
			AND `s`.`activ` = 1
			AND `g`.`home` = 0
		GROUP BY
			`g`.`id`,
			`g`.`sort`,
			`g`.`img`,
			`g`.`name`,
			`g`.`server`,
			`s`.type,
			`s`.path,
			`s`.`img`
		ORDER BY
			`g`.`sort`, `g`.`id` ASC;
	

		SELECT
			`g`.`id` as `id`,
			`g`.`sort` as `sort`,
			`g`.`img` as `img`,
			`g`.`name` as `name`,
			`g`.`server` as `server`,
			`s`.`type` as `type`,
			`s`.`path` as `path`,
			`s`.`img` as `sIMG`
		FROM
			`ms_store_groups` as `g`,
			`ms_servers` as `s`
		WHERE
			`s`.`id` = "38" AND
			`s`.`activ` = 1 AND
			`s`.`id` = `g`.`server` AND
			`g`.`home` = 1
		ORDER BY `sort`, `id` ASC
	

				SELECT
					`id` as `id`,
					`sort` as `sort`,
					`img` as `img`,
					`info` as `info`,
					`title` as `title`,
					`money` as `money`,
					`price` as `price`
				FROM
					`ms_store`
				WHERE
					`activ` = 1 AND
					`grid` = "100"
				ORDER BY `sort`, `id` ASC
			

				SELECT
					`id` as `id`,
					`sort` as `sort`,
					`img` as `img`,
					`info` as `info`,
					`title` as `title`,
					`money` as `money`,
					`price` as `price`
				FROM
					`ms_store`
				WHERE
					`activ` = 1 AND
					`grid` = "101"
				ORDER BY `sort`, `id` ASC