Array
(
[select] =>
SELECT CAT.id_content as category_id, CON.iorderxxxxx,
CON.id_content, CON.object_id as id,
CON.titlexxxxxx as title, CON.description,
CON.codexxxxxxx as code,
CON.id_type as type,
CON.dpublishedx,
IF( (MET.url_directo IS NOT NULL) AND (MET.url_directo <>''),
CONCAT('https://www.moranomyh.com.ar/special/',MET.url_directo),
CONCAT('https://www.moranomyh.com.ar/tienda',CAT.root_direct,CON.url_directo)
) as url_directory,
P.price
[count] => SELECT IFNULL(COUNT(CON.id_content),0) AS count
[from] => FROM tbl_con_content CON
INNER JOIN tbl_con_content_category CAT ON CAT.id_category = CON.category_id
LEFT JOIN tbl_con_content_meta AS MET ON MET.id_content = CON.id_content AND MET.estado = 'A'
LEFT JOIN tbl_con_content_article_stock AS STO ON STO.id_content = CON.id_content AND STO.estado = 'A'
LEFT JOIN (
SELECT PRI.id_content, (PRI.fvalue_6 * CUR.fvaluexxxxx) as price, PRI.fvaluexxxxx
FROM tbl_con_content_article_price AS PRI
INNER JOIN tbl_con_currency AS CUR ON CUR.id_currency = PRI.id_currency
WHERE PRI.estado = 'A' AND PRI.id_price_list = 1
) AS P ON P.id_content = CON.id_content LEFT JOIN tbl_con_content_article_property_option AS APO ON APO.id_content = CON.id_content AND
APO.id_property = 1
[where] =>
WHERE CON.estado = 'A' AND CON.ipublishedx = 1 AND CON.dpublishedx <= NOW()
AND CAT.root_direct LIKE '/herramientas-manuales/pinzas-4755/de-presion/%' AND CON.id_type <> 2 AND CON.id_type <> 3
[order] => ORDER BY APO.id_option='18' DESC, APO.id_option='20' DESC, APO.id_option='21' DESC, APO.id_option='22' DESC, APO.id_option='33' DESC, APO.id_option='41' DESC, APO.id_option='48' DESC, category_id ASC, iorderxxxxx ASC
[limit] => LIMIT 0 , 8
)
marca
