aw1VuGbr

1DROP TABLE IF EXISTS `org_apiinteg_assets`;
2DROP TABLE IF EXISTS `assessmentinstances`;
3
4CREATE TABLE `org_apiinteg_assets` (
5  `id` varchar(20) NOT NULL default '0',
6  `instance_id` varchar(20) default NULL,
7  PRIMARY KEY  (`id`)
8) ENGINE= MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1;
9
10CREATE TABLE `assessmentinstances` (
11  `id` varchar(20) NOT NULL default '0',
12  `title` varchar(180) default NULL,
13  PRIMARY KEY  (`id`)
14) ENGINE= MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1;
15
16
17insert into assessmentinstances(id, title) values ('14026lvplotw6','One radio question survey');
18insert into org_apiinteg_assets(id, instance_id) values ('8kp9wgx43jflrgjfe','14026lvplotw6');
19	
20assessmentinstances
21+---------------+---------------------------+
22|        id     |          title            |
23+---------------+---------------------------+
24| 14026lvplotw6 | One radio question survey |
25+---------------+---------------------------+
26
27org_apiinteg_assets
28+-------------------+---------------+
29|        id         |  instance_id  |
30+-------------------+---------------+
31| 8kp9wgx43jflrgjfe | 14026lvplotw6 |
32+-------------------+---------------+
33	
34SELECT ai.id, COUNT(*) AS `count` 
35FROM assessmentinstances ai INNER JOIN org_apiinteg_assets a 
36    ON a.instance_id = ai.id 
37WHERE ai.id = '14026lvplotw6' 
38AND a.id != '8kp9wgx43jflrgjfe';
39	
40null, 0
41	
42'14026lvplotw6','0'