Hallo dan0ne,
ich habe es mal formatiert und sehe jetzt schon erste Fehler im Query:
SELECT DISTINCT
p
.products_id
, p
.products_ean
, p
.products_manufacturers_model
, p
.products_price
, p
.products_model
, p
.products_quantity
, p
.products_shippingtime
, p
.products_fsk18
, p
.products_image
, p
.products_weight
, p
.products_tax_class_id
, p
.products_vpe
, p
.products_vpe_status
, p
.products_vpe_value
, pd
.products_name
, pd
.products_short_description
, pd
.products_description
FROM products
AS p
LEFT
JOIN products_description
AS pd ON
(p
.products_id
= pd
.products_id
)LEFT OUTER
JOIN products_attributes
AS pa ON
(p
.products_id
= pa
.products_id
)LEFT OUTER
JOIN products_options_values
AS pov ON
(pa
.options_values_id
= pov
.products_options_values_id
)LEFT OUTER
JOIN specials
AS s ON
(p
.products_id
= s
.products_id
) AND s
.STATUS
= '1' WHERE p
.products_status
= '1' AND pd
.language_id
= '2' AND
( ( pd
.products_keywords LIKE
('%hp%') OR p
.products_ean LIKE
('%hp%') OR p
.products_manufacturers_model
('%hp%') OR pd
.products_description LIKE
('%hp%') OR pd
.products_short_description LIKE
('%hp%') OR pd
.products_name LIKE
('%hp%') OR p
.products_model LIKE
('%hp%') OR
(pov
.products_options_values_name LIKE
('%hp%') AND pov
.language_id
= '2') ) OR
( pd
.products_keywords LIKE
('%98a%') OR p
.products_ean LIKE
('%98a%') OR p
.products_manufacturers_model
('%98a%') OR pd
.products_description LIKE
('%98a%') OR pd
.products_short_description LIKE
('%98a%') OR pd
.products_name LIKE
('%98a%') OR p
.products_model LIKE
('%98a%') OR
(pov
.products_options_values_name LIKE
('%98a%') AND pov
.language_id
= '2') ) ) GROUP BY p
.products_id
ORDER BY p
.products_id
also diesen hier:
OR p.products_manufacturers_model ('%hp%')
dort fehlt ein "LIKE".
Und das dieser Status an falscher Stelle vor dem "WHERE" steht also:
AND s.STATUS = '1'
WHERE p.products_status = '1'
müsste so lauten:
WHERE p.products_status = '1'
AND s.STATUS = '1'
EDIT:Also in der "advanced_serach_result.php" in Z. 186 das:
$from_str .= "LEFT OUTER JOIN ".TABLE_SPECIALS." AS s ON (p.products_id = s.products_id) AND s.status = '1'";
ändern in das:
$from_str .= "LEFT OUTER JOIN ".TABLE_SPECIALS." AS s ON (p.products_id = s.products_id) ";
In Z.200 das:
$where_str = " WHERE p.products_status = '1' "." AND pd.language_id = '".(int) $_SESSION['languages_id']."'".$subcat_where.$fsk_lock.$manu_check.$group_check.$tax_where.$pfrom_check.$pto_check;
ändern in das:
$where_str = " WHERE p.products_status = '1' AND s.status = '1'"." AND pd.language_id = '".(int) $_SESSION['languages_id']."'".$subcat_where.$fsk_lock.$manu_check.$group_check.$tax_where.$pfrom_check.$pto_check;
Das mit dem "OR products_manufacturers_model" solltest Du mal in deiner Datei suchen und ein LIKE dahinter setzen.
Kann es im Original nicht finden, scheint also auch erweitert zu sein.
Viele Grüße
Franky