<?php
$str = "
SELECT picture.`%1$s` AS entity_id, picture.picture_id
FROM picture
JOIN category_pictures USING (picture_id)
WHERE picture.`%1$s` IN (%2$s)
#FILTER_CATEGORY AND category_pictures.category_id IN (%3$s)
";
var_dump(substr_replace($str, '', 207, 16));
Warning: Undefined variable $s in /in/T7vp0 on line 4
Warning: Undefined variable $s in /in/T7vp0 on line 7
Warning: Undefined variable $s in /in/T7vp0 on line 7
Warning: Undefined variable $s in /in/T7vp0 on line 8
string(252) "
SELECT picture.`%1` AS entity_id, picture.picture_id
FROM picture
JOIN category_pictures USING (picture_id)
WHERE picture.`%1` IN (%2)
#FILTEategory_pictures.category_id IN (%3)
"
Notice: Undefined variable: s in /in/T7vp0 on line 4
Notice: Undefined variable: s in /in/T7vp0 on line 7
Notice: Undefined variable: s in /in/T7vp0 on line 7
Notice: Undefined variable: s in /in/T7vp0 on line 8
string(252) "
SELECT picture.`%1` AS entity_id, picture.picture_id
FROM picture
JOIN category_pictures USING (picture_id)
WHERE picture.`%1` IN (%2)
#FILTEategory_pictures.category_id IN (%3)
"
Output for 7.3.32 - 7.3.33
string(252) "
SELECT picture.`%1` AS entity_id, picture.picture_id
FROM picture
JOIN category_pictures USING (picture_id)
WHERE picture.`%1` IN (%2)
#FILTEategory_pictures.category_id IN (%3)
"
Notice: Undefined variable: s in /in/T7vp0 on line 7
Notice: Undefined variable: s in /in/T7vp0 on line 7
Notice: Undefined variable: s in /in/T7vp0 on line 8
Notice: Undefined variable: s in /in/T7vp0 on line 9
string(252) "
SELECT picture.`%1` AS entity_id, picture.picture_id
FROM picture
JOIN category_pictures USING (picture_id)
WHERE picture.`%1` IN (%2)
#FILTEategory_pictures.category_id IN (%3)
"
Notice: Undefined variable: s in /in/T7vp0 on line 4
Notice: Undefined variable: s in /in/T7vp0 on line 7
Notice: Undefined variable: s in /in/T7vp0 on line 8
Notice: Undefined variable: s in /in/T7vp0 on line 9
string(252) "
SELECT picture.`%1` AS entity_id, picture.picture_id
FROM picture
JOIN category_pictures USING (picture_id)
WHERE picture.`%1` IN (%2)
#FILTEategory_pictures.category_id IN (%3)
"
Notice: Undefined variable: s in /in/T7vp0 on line 4
Notice: Undefined variable: s in /in/T7vp0 on line 7
Notice: Undefined variable: s in /in/T7vp0 on line 8
Notice: Undefined variable: s in /in/T7vp0 on line 9
string(252) "
SELECT picture.`%1` AS entity_id, picture.picture_id
FROM picture
JOIN category_pictures USING (picture_id)
WHERE picture.`%1` IN (%2)
#FILTEategory_pictures.category_id IN (%3)
"