use s51434__mixnmatch_p tools-db;

SELECT CONCAT('Q', `P245`.`q`), `P245`.`ext_name`, `P245`.`ext_desc`, `P245`.`ext_id`, `P245`.`ext_url`, `P650`.`ext_desc`, `P650`.`ext_id`, `P650`.`ext_url` FROM `entry` AS `P245`

JOIN `entry` AS `P650` ON `P245`.`ext_name`=`P650`.`ext_name` 

AND `P650`.`catalog`=13 

AND (`P650`.`user` IS NULL OR `P650`.`user`=0)

AND `P650`.`type`='person'

WHERE

`P245`.`catalog`=27 

AND NOT `P245`.`q` IS NULL 

AND NOT `P245`.`q`=0

AND NOT `P245`.`user` IS NULL 

AND NOT `P245`.`user`=0

AND `P245`.`type`='person'

LIMIT 100000;