[Skip to main content](#vessel-content)

#  Profile for mohammadhassan

##

[![mohammadhassan's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33093-mohammadhassan "View mohammadhassan's Profile")

**[ Offline](/forum/user/33093-mohammadhassan)**

- **User Type:** User

- **Register Date:** 17 Jun 2014
- **Last login:** 11 years 10 months ago
- **Time Zone:**  UTC +0:00
- **Local Time:** 07:29

- **Posts:** 2
- **Profile views:** 108

- **Gender:** Unknown
- **Birthdate:** Unknown

- Posts

#  mohammadhassan's recent posts  (2 messages )

All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year     All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year

| <a id="forumtop"> </a> [  ](#forumbottom) | Subject | Replies / Views | Last Post | <a id="forumbottom"> </a> [   ](#forumtop) |
|---|---|---|---|---|
| [](/forum/43-carousel-slider/873857-product-listing-filter-product-by-price#184467) | [product listing - filter product by price](/forum/43-carousel-slider/873857-product-listing-filter-product-by-price#184467 "-- HikaShop version -- : 2.3.3 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.19 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : Error: 0 - SQL=SELECT DISTINCT b.product&#95;id,pprice.price&#95;value FROM l894u&#95;hikashop&#95;product&#95;category AS a LEFT JOIN (SELECT &#42; FROM l894u&#95;hikashop&#95;product AS product1 LEFT JOIN l894u&#95;hikashop&#95;price AS price1 ON product1.product&#95;id=price1.price&#95;product&#95;id LEFT JOIN l894u&#95;hikashop&#95;price AS pprice ON b.product&#95;id=pprice.price&#95;product&#95;id WHERE (price1.price&#95;access = 'all' OR price1.price&#95;access LIKE '%,9,%' OR ISNULL(price1.price&#95;access)) AND product1.product&#95;type='main' GROUP BY product1.product&#95;id ORDER BY price1.price&#95;min&#95;quantity ASC) AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN l894u&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON b.product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id LEFT JOIN l894u&#95;hikashop&#95;price AS pprice ON b.product&#95;id=pprice.price&#95;product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (128,125,126,127,124,123,119,120,121,122,118,117,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,150,151,152,153,154,155,156,157,158,159,161,162,163,164,165,166,169,2) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND ( ( case when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '1' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1)+(b.price&#95;value/1)&#42;0 when b.price&#95;currency&#95;id = '1' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '2' and b.product&#95;tax&#95;id = '11' then b.price&#95;value+b.price&#95;value&#42;0 when b.price&#95;currency&#95;id = '2' and b.product&#95;tax&#95;id NOT IN ('11') then b.price&#95;value when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '4' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/0.8377)+(b.price&#95;value/0.8377)&#42;0 when b.price&#95;currency&#95;id = '4' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/0.8377) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '5' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1.4085)+(b.price&#95;value/1.4085)&#42;0 when b.price&#95;currency&#95;id = '5' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1.4085) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '6' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1.4422)+(b.price&#95;value/1.4422)&#42;0 when b.price&#95;currency&#95;id = '6' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1.4422) end ) &gt;= 1 ) AND ( case when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '1' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1)+(b.price&#95;value/1)&#42;0 when b.price&#95;currency&#95;id = '1' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '2' and b.product&#95;tax&#95;id = '11' then b.price&#95;value+b.price&#95;value&#42;0 when b.price&#95;currency&#95;id = '2' and b.product&#95;tax&#95;id NOT IN ('11') then b.price&#95;value when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '4' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/0.8377)+(b.price&#95;value/0.8377)&#42;0 when b.price&#95;currency&#95;id = '4' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/0.8377) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '5' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1.4085)+(b.price&#95;value/1.4085)&#42;0 when b.price&#95;currency&#95;id = '5' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1.4085) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '6' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1.4422)+(b.price&#95;value/1.4422)&#42;0 when b.price&#95;currency&#95;id = '6' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1.4422) end ) BETWEEN 13934 AND 101000 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC  Product filtering by price is not working and it return an error with for this query  Error: 0 - SQL=SELECT DISTINCT b.product&#95;id,pprice.price&#95;value FROM l894u&#95;hikashop&#95;product&#95;category AS a LEFT JOIN (SELECT &#42; FROM l894u&#95;hikashop&#95;product AS product1 LEFT JOIN l894u&#95;hikashop&#95;price AS price1 ON product1.product&#95;id=price1.price&#95;product&#95;id LEFT JOIN l894u&#95;hikashop&#95;price AS pprice ON b.product&#95;id=pprice.price&#95;product&#95;id WHERE (price1.price&#95;access = 'all' OR price1.price&#95;access LIKE '%,9,%' OR ISNULL(price1.price&#95;access)) AND product1.product&#95;type='main' GROUP BY product1.product&#95;id ORDER BY price1.price&#95;min&#95;quantity ASC) AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN l894u&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON b.product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id LEFT JOIN l894u&#95;hikashop&#95;price AS pprice ON b.product&#95;id=pprice.price&#95;product&#95;id WHERE b.product&#95;published=1 AND b.product&#95;type = 'main' AND a.category&#95;id IN (128,125,126,127,124,123,119,120,121,122,118,117,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,150,151,152,153,154,155,156,157,158,159,161,162,163,164,165,166,169,2) AND (b.product&#95;access = 'all' OR b.product&#95;access LIKE '%,9,%') AND ( ( case when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '1' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1)+(b.price&#95;value/1)&#42;0 when b.price&#95;currency&#95;id = '1' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '2' and b.product&#95;tax&#95;id = '11' then b.price&#95;value+b.price&#95;value&#42;0 when b.price&#95;currency&#95;id = '2' and b.product&#95;tax&#95;id NOT IN ('11') then b.price&#95;value when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '4' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/0.8377)+(b.price&#95;value/0.8377)&#42;0 when b.price&#95;currency&#95;id = '4' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/0.8377) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '5' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1.4085)+(b.price&#95;value/1.4085)&#42;0 when b.price&#95;currency&#95;id = '5' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1.4085) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '6' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1.4422)+(b.price&#95;value/1.4422)&#42;0 when b.price&#95;currency&#95;id = '6' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1.4422) end ) &gt;= 1 ) AND ( case when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '1' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1)+(b.price&#95;value/1)&#42;0 when b.price&#95;currency&#95;id = '1' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '2' and b.product&#95;tax&#95;id = '11' then b.price&#95;value+b.price&#95;value&#42;0 when b.price&#95;currency&#95;id = '2' and b.product&#95;tax&#95;id NOT IN ('11') then b.price&#95;value when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '4' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/0.8377)+(b.price&#95;value/0.8377)&#42;0 when b.price&#95;currency&#95;id = '4' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/0.8377) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '5' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1.4085)+(b.price&#95;value/1.4085)&#42;0 when b.price&#95;currency&#95;id = '5' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1.4085) when b.price&#95;currency&#95;id IS NULL then 0 when b.price&#95;currency&#95;id = '6' and b.product&#95;tax&#95;id = '11' then (b.price&#95;value/1.4422)+(b.price&#95;value/1.4422)&#42;0 when b.price&#95;currency&#95;id = '6' and b.product&#95;tax&#95;id NOT IN ('11') then (b.price&#95;value/1.4422) end ) BETWEEN 13934 AND 101000 AND (hikam&#95;vendor.vendor&#95;published IS NULL OR hikam&#95;vendor.vendor&#95;published = 1) ORDER BY a.ordering ASC")        Category: [Carousel &amp; Slider](/forum/43-carousel-slider "Everything about the nice looking Hikashop carousel")     Topic started 11 years 10 months ago, by [mohammadhassan](/forum/user/33093-mohammadhassan "View mohammadhassan's Profile")       [Last Post](/forum/43-carousel-slider/873857-product-listing-filter-product-by-price#184476 "Hi,  First, please update to the latest version and try again.") 11 years 10 months ago     by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:1  Views:2197 | [Last Post](/forum/43-carousel-slider/873857-product-listing-filter-product-by-price#184476 "Hi,  First, please update to the latest version and try again.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")      11 years 10 months ago |
| [](/forum/23-market-how-to/869066-create-vendor-in-the-front-end#160592) | [Create vendor in the front-end](/forum/23-market-how-to/869066-create-vendor-in-the-front-end#160592 "I have purchased the hikashop and hikamarket to build my store, I want users to be able to create vendor in the frontend, I think this is possible in hikamarket, any suggestion Thanks")        Category: [Market: How to?](/forum/23-market-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question about HikaMarket here.")     Topic started 12 years 4 months ago, by [mohammadhassan](/forum/user/33093-mohammadhassan "View mohammadhassan's Profile")       [Last Post](/forum/23-market-how-to/869066-create-vendor-in-the-front-end#160604 "Hi,  Did you follow the &quot;Multivendor tutorial&quot; of HikaMarket ?   www.hikashop.com/support/documentation/1...-multi-tutorial.html  In the section &quot;First configuration&quot;, you will find some notes about the &quot;registration mode&quot;. In the section &quot;Creating a menu&quot;, you will find some information about the required menu to have a vendor registration page.  Regards,") 12 years 4 months ago     by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:1  Views:1039 | [Last Post](/forum/23-market-how-to/869066-create-vendor-in-the-front-end#160604 "Hi,  Did you follow the &quot;Multivendor tutorial&quot; of HikaMarket ?   www.hikashop.com/support/documentation/1...-multi-tutorial.html  In the section &quot;First configuration&quot;, you will find some notes about the &quot;registration mode&quot;. In the section &quot;Creating a menu&quot;, you will find some information about the required menu to have a vendor registration page.  Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile")      12 years 4 months ago |

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.197 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)