/home/preisdbo/www.preistipp.de/preistipp-v2/sql/pt_partners/s.partners.details.sql

# CW | partners.details

	SELECT 
		`p`.*,
		(
			SELECT `name`
			FROM usrdb_texmedcn_cw.s_partners_sales
			WHERE `id_partner` = `p`.`id`
			AND   (`timestamp_s` <= NOW() OR `timestamp_s` = '1970-01-01 00:00:00')
			AND   (`timestamp_e` >= NOW() OR `timestamp_e` = '1970-01-01 00:00:00')
			LIMIT 1
		) AS `partner_sale`,
		(
			SELECT COUNT(1)
			FROM usrdb_texmedcn_cw.s_partners_flyers
			WHERE `id_partner` = `p`.`id`
			AND   (`timestamp_s` <= NOW() OR `timestamp_s` = '1970-01-01 00:00:00')
			AND   (`timestamp_e` >= NOW() OR `timestamp_e` = '1970-01-01 00:00:00')
			LIMIT 1
		) AS `partner_flyer`,
		(
			SELECT `open_time`
			FROM usrdb_texmedcn_fe.psm_fe_partners
			WHERE `id` = `p`.`id`
			LIMIT 1
		) AS `open_time`,
		(
			SELECT `register_type`
			FROM usrdb_texmedcn_fe.psm_fe_partners
			WHERE `id` = `p`.`id`
			LIMIT 1
		) AS `register_type`
		
	FROM usrdb_texmedcn_cw.s_partners AS `p`
	WHERE id = "" 
	OR 0 = 
	
	
	
	
	
	
	

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 36