Donate Engine

mysqli://localhost:3306/c5_cmsdonate

	SELECT
		`path_image` as `path_image`
	FROM `ms_servers`
	WHERE
		`shop` LIKE "lisf%"
	LIMIT 1

		SELECT
			count(*) as `count`
		FROM
			`ms_lisf_market` as `dm`,
			`ms_lisf_shop` as `ds`
			, `ms_lisf_shop_groups` as `dg`
		WHERE
				SUBSTRING_INDEX(`dm`.`item`, ":", 1) = `ds`.`itemid`
			AND `ds`.`shop` > 0
			
				AND `ds`.`grid` = `dg`.`id`
				AND `dg`.`id` = "14"
			
	

		SELECT
			`id` as `id`,
			`name` as `name`,
			`sort` as `sort`,
			`img` as `img`
		FROM `ms_lisf_shop_groups`
		ORDER BY `sort` ASC
	

			SELECT 
				`dm`.`id` as `id`,
				`dm`.`item` as `item`,
				`dm`.`count` as `count`,
				`dm`.`user` as `user`,
				`dm`.`price` as `price`,
				`ds`.`name` as `name`,
				`ds`.`itemid` as `itemid`
			FROM
				`ms_lisf_market` as `dm`,
				`ms_lisf_shop` as `ds`
				, `ms_lisf_shop_groups` as `dg`
			WHERE
					`ds`.`itemid` = SUBSTRING_INDEX(`dm`.`item`, ":", 1)
				AND `ds`.`shop` > 0
				
					AND `ds`.`grid` = `dg`.`id`
					AND `dg`.`id` = "14"
				
			ORDER BY `id` DESC
			LIMIT 60, 30