Hi all,
I'm experiencing a strange problem ( IMHO).
query:
SELECT SQL_CALC_FOUND_ROWS `a`.`id` AS `aanvraag_id`, `a`.`tijdstip`,
`a`.`uid`, `a`.`partij`, `a`.`cc`, `a`.`bouwjaar`, `a`.`maand`,
`a`.`provincie_id`, `a`.`woonplaats`, `a`.`klant_bericht` AS `bericht`,
`a`.`merk` AS `merknaam`, LOWER(`a`.`model`) AS `model`, `a`.`ccm`,
LOWER(`a`.`type`) AS `type`, `a`.`carrossid`, `a`.`deurid` AS `deuren`,
`a`.`brandstof`, `a`.`bakid`, `a`.`chassisnr`, `a`.`kenteken` FROM
`aanvraag` AS `a` WHERE `a`.`srt` = 'pw' AND `a`.`merk_id` IN
('1','2','3','4','5','6','7','8','9','10','11','12 ','13','14','15','16','17','18','19','20','21','22 ','23','24','25','26','27','28','29','30','31','34 ','36','37','39','41','42','43','44','45','46','47 ','48','51','53','54','55','57','59','60','61','62 ','63','65','67','69','71','72','73','74','75','76 ','78','79','81','82','84','85','86','87','88','89 ','90','91','92','93','94','95','96','97','98','99 ','101','102','103','106','107','108','109','111', '112','114','115','116','119','120','121','122','1 23','124','125','126','127','128','129','131','134 ','135','136','138','139','140','141','142','146')
AND `a`.`partij` IN ('oz','gp') AND `a`.`id` NOT IN ( SELECT
`aanvraag_id` FROM `abonnee_aanvraag_wis` WHERE `abonnee_id` ='9990')
ORDER BY `a`.`id` DESC LIMIT 0,50
Generates al clickable list with values. When i execute this query ...
Bookmarks