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` ASCUnknown 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, 28You 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