- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我有一个逻辑问题需要解决。我们有下表:
200
- 文章表(所有文章)202
- 国家/地区限制表(所有限制基于国家/地区和文章)如果某篇文章在国家/地区限制表中没有结果,则该文章可以显示。
如果某篇文章在国家/地区限制表中有结果,但我们感兴趣的国家/地区不存在,则可以显示该文章。
如果该文章在国家限制表中有结果,并且存在我们感兴趣的国家,并且独占值为0,则该文章可以显示。
如果该文章在国家/地区限制表中有结果,并且其他国家/地区有排他性1,则该产品可以显示。
这是我的方法,但不是一个好的方法......
SELECT `203`.ArtNr,
IF(
EXISTS((SELECT * FROM `202` WHERE `202`.ArtNr = `203`.ArtNr)),
'',
'yes'
) as 'Display' FROM `203`
WHERE `203`.RefNr_Search = 'GDB400'
AND `203`.ArtNr IN ('0 986 467 720','0 986 494 522','0 986 TB2 005','F 03A 150 016')
LKZ 值可以是:“RO”、“EU”、“OE”
这是这4篇文章的精选。上述查询应仅返回两个结果(ArtNr=0 986 494 522,ArtNr=0 986 467 720)。我无法提出此查询...我们将不胜感激。
CREATE TABLE `203` (
`ArtNr` VARCHAR(22) NULL DEFAULT NULL,
`ArtNr_Search` VARCHAR(22) NULL DEFAULT NULL,
`DLNr` INT(4) UNSIGNED NULL DEFAULT NULL,
`SA` SMALLINT(3) UNSIGNED NULL DEFAULT NULL,
`KHerNr` INT(6) UNSIGNED NULL DEFAULT NULL,
`LKZ` VARCHAR(3) NULL DEFAULT NULL,
`RefNr` VARCHAR(22) NULL DEFAULT NULL,
`RefNr_Search` VARCHAR(22) NULL DEFAULT NULL,
`Exclude` INT(1) UNSIGNED NULL DEFAULT NULL,
`Sort` INT(5) UNSIGNED NULL DEFAULT NULL,
INDEX `ArtNr` (`ArtNr`),
INDEX `ArtNr_Search` (`ArtNr_Search`),
INDEX `RefNr` (`RefNr`),
INDEX `RefNr_Search` (`RefNr_Search`),
INDEX `KHerNr` (`KHerNr`),
INDEX `DLNr` (`DLNr`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=FIXED
;
INSERT INTO `203` (`ArtNr`, `ArtNr_Search`, `DLNr`, `SA`, `KHerNr`, `LKZ`, `RefNr`, `RefNr_Search`, `Exclude`, `Sort`) VALUES ('0 986 467 720 ', '0986467720', 30, 203, 520, ' ', 'GDB400 ', 'GDB400', 0, 5);
INSERT INTO `203` (`ArtNr`, `ArtNr_Search`, `DLNr`, `SA`, `KHerNr`, `LKZ`, `RefNr`, `RefNr_Search`, `Exclude`, `Sort`) VALUES ('0 986 494 522 ', '0986494522', 30, 203, 520, ' ', 'GDB400 ', 'GDB400', 0, 5);
INSERT INTO `203` (`ArtNr`, `ArtNr_Search`, `DLNr`, `SA`, `KHerNr`, `LKZ`, `RefNr`, `RefNr_Search`, `Exclude`, `Sort`) VALUES ('0 986 TB2 005 ', '0986TB2005', 30, 203, 798, ' ', 'GDB400 ', 'GDB400', 0, 1);
INSERT INTO `203` (`ArtNr`, `ArtNr_Search`, `DLNr`, `SA`, `KHerNr`, `LKZ`, `RefNr`, `RefNr_Search`, `Exclude`, `Sort`) VALUES ('F 03A 150 016 ', 'F03A150016', 30, 203, 520, ' ', 'GDB400 ', 'GDB400', 0, 5);
CREATE TABLE `202` (
`ArtNr` VARCHAR(22) NULL DEFAULT NULL,
`DLNr` INT(4) NULL DEFAULT NULL,
`SA` INT(3) NULL DEFAULT NULL,
`LKZ` VARCHAR(3) NULL DEFAULT NULL,
`Exclude` INT(1) NULL DEFAULT NULL,
INDEX `ArtNr_LKZ` (`ArtNr`, `LKZ`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=FIXED
;
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 467 720', 30, 202, 'BR', 1);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 467 720', 30, 202, 'CDN', 1);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 467 720', 30, 202, 'USA', 1);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'ADN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'AN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'ANG', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'BF', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'BRN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'CD', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'CI', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'CM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'DJ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'DY', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'DZ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'EAK', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'EAT', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'EAU', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'ER', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'ET', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'ETH', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'GA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'GH', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'GN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'GQ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'GW', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'IL', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'IR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'IRQ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'JOR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'KM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'KWT', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'LAR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'LB', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'LS', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'MA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'MEA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'MS', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'MW', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'MZ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'OM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'Q', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RB', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RCA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RCB', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RE', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RIM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RL', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RMM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RU', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'RWA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'SA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'SN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'SP', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'ST', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'SY', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'SYR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'SZ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'TD', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'TG', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'TN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'TR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'UAE', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'WAG', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'WAL', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'WAN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'Z', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('0 986 TB2 005', 30, 202, 'ZW', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ADN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'AN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ANG', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'AS', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'BF', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'BRN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'C', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'CD', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'CI', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'CM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'CR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'DJ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'DOM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'DY', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'EAK', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'EAT', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'EAU', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ER', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ES', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ET', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ETH', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'GA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'GCA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'GH', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'GN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'GQ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'GW', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'HN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'IR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'IRQ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'JOR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'KM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'KWT', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'LAR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'LB', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'LS', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'MEX', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'MW', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'MZ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'NIC', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'OM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'PA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'Q', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RB', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RCA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RCB', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RIM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RL', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RMM', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RU', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'RWA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'SA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'SN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'SP', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ST', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'SY', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'SYR', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'SZ', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'TD', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'TG', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'UAE', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'WAG', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'WAL', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'WAN', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'Z', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ZA', 0);
INSERT INTO `202` (`ArtNr`, `DLNr`, `SA`, `LKZ`, `Exclude`) VALUES ('F 03A 150 016', 30, 202, 'ZW', 0);
最佳答案
得到了我 friend 的帮助,谢谢。
SELECT distinct (`203`.ArtNr) FROM `203`
LEFT JOIN `202` ON `202`.ArtNr = `203`.ArtNr
WHERE `203`.RefNr_Search = 'gdb400'
AND `203`.ArtNr IN ('0 986 467 720','0 986 494 522','0 986 TB2 005','F 03A 150 016')
AND (`202`.ArtNr IS NULL OR (`202`.Exclude = 0 AND `202`.LKZ IN('RO','EU','OE')) OR (`202`.Exclude = 1 AND `202`.LKZ NOT IN('RO','EU','OE')))
关于Mysql 根据国家/地区排除和包含,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/33386504/
已结束。此问题正在寻求书籍、工具、软件库等的推荐。它不满足Stack Overflow guidelines 。目前不接受答案。 我们不允许提出寻求书籍、工具、软件库等推荐的问题。您可以编辑问题,以便
在我的 MVC 应用程序中,我想显示用户访问网站的国家/地区、地区和城市。我怎样才能获取它们? 最佳答案 有几种方法。一种是要求用户与远程服务器共享他的位置。 https://developer.mo
有人知道Firebase电话身份验证是否适用于印度电话号码吗? 我成功实现并使用了美国号码(+1xxxxxxxxxx),但是尝试使用印度电话号码时未收到文本。不确定是否无法正常工作,或者我丢失了某些东
我想知道网站的原始国家/地区。我注意到Alexa网站通常可以检测网站的原始国家/地区。例如,Alexa可以检测到stackoverflow.com网站的原始国家/地区是美国,依此类推。 Alexa如何
我有一些文本,其中可能包含也可能不包含国家/地区名称。例如: ' Nigeria: Hotspot Network LTD Rural Telephony Feasibility Study' 这就是
已关闭。这个问题是 off-topic 。目前不接受答案。 想要改进这个问题吗? Update the question所以它是on-topic用于堆栈溢出。 已关闭10 年前。 Improve th
我有一组值,它们是我的 ajax 调用中的国家/地区代码 Handler.getCountryIdparam1, {callback:function(data){ // data will
我在我的应用程序中使用谷歌地点。一切正常,但我只想从输入中删除或忽略国家/地区。 例如,如果输入“arc”我有 Arcachon, France Arcueil, France Archamps, F
在 firebase 中创建项目时,我错误地选择了错误的国家/地区。 正如您在这里看到的: 这个问题可以解决吗? (我知道项目 ID 无法更改,而且我喜欢我选择的 ID...) 最佳答案 如the d
我有一个名为“Login”的Hive表。它包含以下列: UserID | UserName | UserIP | UserCountry | Date 在特定的一天(当天的所有登录信息),我想找出用户
我正在使用谷歌地图和地理编码API来检索用户输入邮政编码/邮政编码后的纬度/经度,但我想将邮政编码/邮政编码限制为该用户所在的国家/地区,这样我就不会得到结果多个结果。 是否有一种方法可以使用 jqu
是否可以获得维基百科上所有有关系的国家、地区和城市的列表?我找不到任何适合此任务的 API。解析我需要的所有信息的最简单方法是什么?PS:我知道,我可以从其他数据源获取此信息。但我对维基百科感兴趣..
我正在用两种语言制作一个网站。是否可以检查用户位于哪个国家,以便我可以自动为用户切换语言?我的菜单中还有一个带有 _GET 的切换选项。我一开始有这段代码: if (isset($_GET['taal
这是我的 Firebase 数据库结构: 看起来就是这样。有国家和用户。如果用户访问过某个国家/地区,则该国家/地区将存储在该用户的“VisitedCountries”子项中。例如用户 Angelin
这个问题在这里已经有了答案: Convert latitude and longitude coordinates to country name in R (2 个回答) 关闭9年前. 我有一个带有
我目前正在开发我的第一个iOS应用(phonegap / cordova)。我想知道是否需要采取某些步骤,以使其不仅可用于德国应用程序商店(这是我的语言),还可以提供给国际应用程序? 最佳答案 不,你
很难说出这里问的是什么。这个问题是含糊的、模糊的、不完整的、过于宽泛的或修辞性的,无法以目前的形式得到合理的回答。如需帮助澄清此问题以便重新打开它,visit the help center 。 已关
背景 我目前正在开发一个向用户提问的 Android 应用程序。目前我正在创建用于提问的模块。现在我正在开发一个地形模块,它将能够向用户询问有关某个国家/地区的各种问题,并向他们显示。 问题 对于本模
我正在使用 Cloudera 的 TwitterSource for Flume。我想按国家/地区获取具有某些关键字的推文。当我想获取来自荷兰的推文时,我不知道该与什么进行比较。我有以下结果,但没有任
大多数 Web 应用程序都有一个位置字段,用户可以在其中输入自己选择的位置。 如何根据输入的位置将用户分类到不同的国家/地区。 例如,我使用了 users.xml 的 Stack Overflow 转
我是一名优秀的程序员,十分优秀!