deeman313

deeman313 / selectAllOffersSelectAs.sql

Created January 25, 2019 11:51

все объявления select AS

	SELECT
	`owner` AS 'id пользователя',
	`type` AS 'тип пользователя',
	COUNT(`owner_id`) AS 'кол-во активных объявлений',
	(SELECT SUM(_limit) FROM
	`_lib_ServicesLinks` l
	WHERE l.`SID` = 57
	AND l.`UID` = `owner`
	AND l.`_endDate` >= CURRENT_DATE) AS 'slimit'
	FROM

deeman313 / body_api_offer.json

Created April 13, 2018 07:48

api offers mock