POS START802POS END871HEREArray
(
    [category_id] => Array
        (
            [0] => 427
        )

    [search_term] => Array
        (
            [0] => bottle</p>

<p>To support their sucking skills, introduce a <a href
        )

)
HERESELECT P.product_id from oc_product P
                JOIN oc_product_to_store_type T on (P.product_id = T.product_id and T.store_type_id = '1') JOIN oc_product_to_category PC on (PC.product_id = P.product_id ) 
                        JOIN oc_category_path PA on (PA.category_id = PC.category_id and PA.path_id in (427)) JOIN oc_product_description D on (P.product_id = D.product_id and D.language_id = 1 and ( D.name like "%bottle</p>\r\n\r\n<p>To support their sucking skills, introduce a <a href%")) JOIN oc_inventory I on (P.product_id = I.product_id and I.quantity > 0 and I.country_id = '96') AND P.parent_id = 0 order by I.delivery_days  LIMIT 6