GX-Entwicklung

Das Problem hier ist, dass der Code im Google Modul davon ausgeht, dass es hier eine PRODUCTS_ID gibt. Die gibt es aber nicht, obwohl Artikeldaten vorhanden sind.
Das liegt daran, dass die Variable $this->content_array['module_content']; kein Array ist, sondern ein String mit dem kompletten HTML Code und somit niemals eine ID von Artikel extrahiert werden kann.
Es werden also niemals Impressions getracked, obwohl Artikel angezeigt werden. Im schlimmsten Fall wird eine SQL Fehlermeldung ausgegeben.

Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY `pobcs`.`personal_offer`, `ppc`.`products_id`, `p`.`products_model`, ' at line 9 - Invalid query: 
SELECT `pd`.`products_name` as `name`, `p`.`products_price` as `productPrice`, `m`.`manufacturers_name` as `brand`, `pobcs`.`personal_offer` as `personalOffer`, `s`.`specials_new_products_price` as `specialPrice`, `p`.`products_discount_allowed` as `allowedDiscount`, `p`.`products_model` as `id`, MIN(ppc.combi_price) as combinationPrice FROM `products` as `p`
JOIN `products_description` as `pd` ON `p`.`products_id` = `pd`.`products_id`
LEFT OUTER JOIN `manufacturers` as `m` ON `p`.`manufacturers_id` = `m`.`manufacturers_id`
LEFT OUTER JOIN `specials` as `s` ON `p`.`products_id` = `s`.`products_id`
LEFT OUTER JOIN `personal_offers_by_customers_status_0` as `pobcs` ON `p`.`products_id` = `pobcs`.`products_id` AND `pobcs`.`quantity` = 1.0000
LEFT OUTER JOIN `products_properties_combis` as `ppc` ON `p`.`products_id` = `ppc`.`products_id`
WHERE `pd`.`language_id` = 2 AND p.products_id IN()
GROUP BY `pobcs`.`personal_offer`, `ppc`.`products_id`, `p`.`products_model`, `p`.`products_discount_allowed`, `pd`.`products_name`, `m`.`manufacturers_name`, `p`.`products_price`, `pobcs`.`personal_offer`, `s`.`specials_new_products_price`, `p`.`products_id`
ORDER BY FIND_IN_SET(`p`.`products_id`, "") ASC```