SELECT
					`g`.`id`,
					`g`.`parent_id`,
					`g`.`original_id`,
					`g`.`dir`,
					`g`.`way`,
					`g`.`title`,
					`g`.`title_long`,
					`g`.`type`
				FROM `market_articles` `a`
				INNER JOIN `market_items` `i` ON `i`.`id` = `a`.`id`
				INNER JOIN `market_groups` `g` ON `g`.`id` = `a`.`group_id`
				WHERE `i`.`hidden` = 0 AND `i`.`deleted` = 0 AND ((`l`.`type` = "jetski" AND `l`.`mark_id` = 0) OR (`l`.`mark_id` = "0" AND `l`.`type` = "jetski"))
				GROUP BY `a`.`group_id`
				ORDER BY `g`.`order` ASC, `g`.`title` ASC
			
Unknown column 'l.type' in 'where clause'

			SELECT
				`i`.`id`,
				IF(`i`.`image_id` != 0, 1, 0) AS `image`,
				IF(`i`.`geo_region_id` = 4925, 1, 0) + IF(`i`.`geo_region_id` = 15789406, 1, 0) + IF(`i`.`geo_country_id` = 3159, 1, 0) AS `rel`
			FROM `market_items` `i`
			LEFT JOIN `market_links` `l` ON `l`.`market_id` = `i`.`id`
			LEFT JOIN `market_vehicle` `v` ON `v`.`id` = `i`.`id`
			WHERE `i`.`hidden` = 0 AND `i`.`deleted` = 0 AND (
				(
					(
						`i`.`type` = "vehicle"
					)
					AND
					(
						
					)
				)
				OR
				(
					(
						`i`.`type` = "article"
					)
					AND
					(
						(`l`.`type` = "jetski" AND `l`.`mark_id` = 0)
					)
				)
			)
			GROUP BY `i`.`id`
			ORDER BY `image` DESC, `rel` DESC, `i`.`id` DESC
			LIMIT 0, 28
		
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ) OR ( ( `i`.`type` = "article" ) A...' at line 16
Аквабайки нв МотоБратан
МотоБратан / Мотоциклы / Аквабайки

Аквабайки

Пока по теме никто и ничего не обсуждал
владельцев
Добавить свой мотоцикл