шрус внутренний
===========
Array
(
[0] => Array
(
[file] => /home/safety2/public_html/includes/classes/split_page_results.php
[line] => 54
[function] => tep_db_query
[args] => Array
(
[0] => select count(p.products_id) as total from
(products_description pd,
products p,
products_to_categories p2c,
products_prices pp)
LEFT JOIN manufacturers m on m.manufacturers_id = p.manufacturers_id
where
p.products_status = '1'
AND p.main_in_other <> '989'
AND p.products_id = p2c.products_id
AND p.products_id = pp.products_id
AND p.products_id = pd.products_id
AND p.hide_for_cgid <> 0 and ( p.products_model2 like 'KIA' ) and ( p.other_products like 'CEE'D' )
AND pd.language_id = '1'
AND p2c.categories_id IN (66)
)
)
[1] => Array
(
[file] => /home/safety2/public_html/includes/modules/product_listing.php
[line] => 322
[function] => splitPageResults
[class] => splitPageResults
[type] => ->
[object] => splitPageResults Object
(
[sql_query] => select p.products_image, products_image_med, pd.products_name, pd.products_description_short, p.products_model, p.products_model2,
p.products_image, p.products_status, p.products_status2, pd.products_name,
pd.products_description_short, pd.products_description,
p.products_id, p.manufacturers_id,
m.manufacturers_name,
p.products_price, p.currency_code,
p.products_in_box, p.price_per_box,
p.other_products, p.main_in_other,
p.old_products_price,
p.products_image_status, p.products_tax_class_id,
(SELECT count(p2.products_id) FROM products p2 WHERE p2.other_products LIKE p.other_products) AS other_count,
IF (0, (SELECT s.customers_group_price FROM products_groups s WHERE s.products_id = p.products_id), p.products_price) AS final_price
from
(products_description pd,
products p,
products_to_categories p2c,
products_prices pp)
LEFT JOIN manufacturers m on m.manufacturers_id = p.manufacturers_id
where
p.products_status = '1'
AND p.main_in_other <> '989'
AND p.products_id = p2c.products_id
AND p.products_id = pp.products_id
AND p.products_id = pd.products_id
AND p.hide_for_cgid <> 0 and ( p.products_model2 like 'KIA' ) and ( p.other_products like 'CEE'D' )
AND pd.language_id = '1'
AND p2c.categories_id IN (66) order by p.products_date_added desc, p.products_sort_order, p.products_model
[number_of_rows] =>
[current_page_number] => 1
[number_of_pages] =>
[number_of_rows_per_page] => 9
[page_name] => page
)
[args] => Array
(
[0] => select p.products_image, products_image_med, pd.products_name, pd.products_description_short, p.products_model, p.products_model2,
p.products_image, p.products_status, p.products_status2, pd.products_name,
pd.products_description_short, pd.products_description,
p.products_id, p.manufacturers_id,
m.manufacturers_name,
p.products_price, p.currency_code,
p.products_in_box, p.price_per_box,
p.other_products, p.main_in_other,
p.old_products_price,
p.products_image_status, p.products_tax_class_id,
(SELECT count(p2.products_id) FROM products p2 WHERE p2.other_products LIKE p.other_products) AS other_count,
IF (0, (SELECT s.customers_group_price FROM products_groups s WHERE s.products_id = p.products_id), p.products_price) AS final_price
from
(products_description pd,
products p,
products_to_categories p2c,
products_prices pp)
LEFT JOIN manufacturers m on m.manufacturers_id = p.manufacturers_id
where
p.products_status = '1'
AND p.main_in_other <> '989'
AND p.products_id = p2c.products_id
AND p.products_id = pp.products_id
AND p.products_id = pd.products_id
AND p.hide_for_cgid <> 0 and ( p.products_model2 like 'KIA' ) and ( p.other_products like 'CEE'D' )
AND pd.language_id = '1'
AND p2c.categories_id IN (66) order by p.products_date_added desc, p.products_sort_order, p.products_model
[1] => 9
[2] => p.products_id
)
)
[2] => Array
(
[file] => /home/safety2/public_html/index.php
[line] => 181
[args] => Array
(
[0] => /home/safety2/public_html/includes/modules/product_listing.php
)
[function] => include
)
)
===========
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'D' ) AND pd.language_id = '1' AND p2c.c...' at line 13
select count(p.products_id) as total from (products_description pd, products p, products_to_categories p2c, products_prices pp) LEFT JOIN manufacturers m on m.manufacturers_id = p.manufacturers_id where p.products_status = '1' AND p.main_in_other <> '989' AND p.products_id = p2c.products_id AND p.products_id = pp.products_id AND p.products_id = pd.products_id AND p.hide_for_cgid <> 0 and ( p.products_model2 like 'KIA' ) and ( p.other_products like 'CEE'D' ) AND pd.language_id = '1' AND p2c.categories_id IN (66)
[TEP STOP]
