JoomFish debug (new):
reference_table=menu
id IN(75,1,90,91,88,89,87,86,92,79,80,82,78,81,83,21,67,16)
language=english
class=stdClass

Shop arrow Shop

JoomFish debug (new):
reference_table=menu
id IN(5)
language=english
class=stdClass

Informations

JoomFish debug (new):
reference_table=menu
id IN(75,1,90,91,88,89,87,86)
language=english
class=stdClass

Shop
Main Page

JoomFish debug (new):
reference_table=menu
id IN(80)
language=english
class=stdClass

Versand

JoomFish debug (new):
reference_table=menu
id IN(79)
language=english
class=stdClass

Zahlung

JoomFish debug (new):
reference_table=menu
id IN(78)
language=english
class=stdClass

Widerrufsbelehrung

JoomFish debug (new):
reference_table=menu
id IN(82)
language=english
class=stdClass

Datenschutz

JoomFish debug (new):
reference_table=menu
id IN(81)
language=english
class=stdClass

AGB

JoomFish debug (new):
reference_table=menu
id IN(83)
language=english
class=stdClass

Impressum

Kundenanmeldung

 
 

Lost Password?
No account yet? Register

 
Debug: A Session called commerzo (ID: 1adacd78329ebeecab5060cfd1be4f12) was successfully started!

 

Cart

 

JoomFish debug (new):
reference_table=menu
id IN(75,92)
language=english
class=stdClass

Debug: Weight not specified for product 24206551000

Debug: Weight not specified for product

SKU Name Quantity Update
24206551000 Pfirsich Melba Früchtetee 1000 gr
Milder Früchtetee (Grundpreis: Eur 1,95/100gr)
18,22 18,22 0,00 7,00% 1,28


0,00 0,00 0,00 19,00% 0,00
  18,22 0,00
  0,00%   0,00    
  0,00%   0,00    
  Subtotal 18,22 0,00
  18,22
  Tax 7,00% 1,28
  Tax 19,00% 0,00
  Tax 0,00% 0,00
  19,50

 
If you have a coupon code, please enter it below:

 



 

Shop Core Variables

DEBUG CENTER

Version: COMMERZO VM 2.0.0 stable [Seminole Wind]
01.04.2008 10:00 CEST
RunTime: 0.0446960926056 sec.  Current Page: shop.cart
Queries executed: 5    Last Page: shop.cart 
UID: Return To Page:  
Username: demo  Function: cartAdd 
Perms:   Command (Result): $ok = $ps_cart->add($vars); (True)  
$func_perms:
Array
(
    [perms] => none
    [class] => ps_cart
    [method] => add
)
$ps_vendor_id: 1   
 
$dir_perms: Ok  global Log: 3 logged message(s).   
 
Joomla! Session ID: a3794369b0eab9231f2ad0b259f5f948 
commerzo Session ID: 1adacd78329ebeecab5060cfd1be4f12   
$cart: $cart[0]:ID[2710]->Qty:[1]
$cart[1]:ID[2582]->Qty:[1]
$auth: Array ( [show_prices] => 1 [user_id] => 0 [username] => demo [perms] => [first_name] => guest [last_name] => [shopper_group_id] => 2 [shopper_group_discount] => 0.00 [show_price_including_tax] => 1 [default_shopper_group] => 1 [is_registered_customer] => [has_vat_id] => )

Global Variables

$_GET:
$_COOKIE:
Array
(
    [commerzo] => 1adacd78329ebeecab5060cfd1be4f12
    [mosvisitor] => 1
    [82a8f0003931bcfead579200410bad17] => d701a8a7fb09a5fcbd2c4dcced955d26
    [mbfcookie] => Array
        (
            [lang] => en
        )

)
$_SESSION:
Array
(
    [cart] => Array
        (
            [idx] => 2
            [0] => Array
                (
                    [quantity] => 1
                    [product_id] => 2710
                    [description] => 
                    [discable] => Y
                    [group_disc_commerzo] => 18.22
                )

            [1] => Array
                (
                    [quantity] => 1
                    [product_id] => 2582
                    [description] => 
                    [discable] => 
                )

        )

    [ps_vendor_id] => 1
    [minimum_pov] => 0.00
    [vendor_currency] => EUR
    [auth] => Array
        (
            [show_prices] => 1
            [user_id] => 0
            [username] => demo
            [perms] => 
            [first_name] => guest
            [last_name] => 
            [shopper_group_id] => 2
            [shopper_group_discount] => 0.00
            [show_price_including_tax] => 1
            [default_shopper_group] => 1
            [is_registered_customer] => 
            [has_vat_id] => 
        )

    [session_userstate] => Array
        (
            [product_id] => 2582
            [category_id] => 0
            [keyword] => 
            [viewlistlimit] => 10
            [view333limitstart] => 0
            [view298limitstart] => 0
            [view322limitstart] => 0
            [view304limitstart] => 0
            [view0limitstart] => 0
            [view303limitstart] => 0
        )

    [last_page] => shop.cart
    [product_sess] => Array
        (
            [2292] => Array
                (
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137828
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2293] => Array
                (
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137828
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2294] => Array
                (
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137828
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2295] => Array
                (
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137828
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2770] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137829
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1178] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137829
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1101] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137829
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1076] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137829
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2485] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137829
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2216] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137908
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1485] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137908
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.1900
                )

            [1138] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137908
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1105] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137908
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1300] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137908
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2218] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137959
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1999] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137959
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1249] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137960
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1106] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137960
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1092] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137960
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1257] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137997
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2330] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137997
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.1900
                )

            [1134] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137997
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2725] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137997
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2692] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284137997
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2710] => Array
                (
                    [vendor_id] => 1
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138022
                        )

                    [tax_rate] => 0.0700
                    [flypage] => shop.flypage
                )

            [2230] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138023
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1516] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138023
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.1900
                )

            [2786] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138023
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2092] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138023
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1095] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138023
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2096] => Array
                (
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138074
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2760] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138074
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1206] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138074
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1374] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138074
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2677] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138074
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [1065] => Array
                (
                    [flypage] => shop.flypage
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138074
                        )

                    [vendor_id] => 1
                    [tax_rate] => 0.0700
                )

            [2582] => Array
                (
                    [vendor_id] => 
                    [discount_info] => Array
                        (
                            [amount] => 0
                            [is_percent] => 0
                            [create_time] => 1284138113
                        )

                    [tax_rate] => 0.1900
                    [flypage] => shop.flypage
                )

        )

    [sub_disc] => 18.22
    [sub_nodisc] => 0
    [sum_groupdisc] => 0
    [sum_taxable_disc] => 0.07|18.22
    [sum_taxable_nodisc] => 0.19|0#|0
    [taxtotal] => #0.19|0#|0
    [sum_discrates] => 0
    [sum_gdc] => 0
    [sum_invdisc] => 0
    [sum_globdisc] => 0
    [sum_paymdisc] => 0
    [mmz] => 0
    [gdc_rate] => 0.00
    [globdisc_rate] => 0.00
    [invdisc_rate] => 0
    [paymdisc_rate] => 0
    [subtotal] => 18.22
    [shipping_total] => 0
    [total_taxes] => 1.2754
    [order_total_withtax] => 19.5
    [taxrate] => Array
        (
            [1] => 0.1900
        )

)
   
$vars: commerzo=>1adacd78329ebeecab5060cfd1be4f12
mosvisitor=>1
82a8f0003931bcfead579200410bad17=>d701a8a7fb09a5fcbd2c4dcced955d26
mbfcookie=>Array
page=>shop.cart
func=>cartAdd
product_id=>2582
option=>com_commerzo
Itemid=>75
lang=>en
keyword=>
user_info_id=>0
description=>
zone_qty=>2

Your Basket

Show Cart
 
Debug: Weight not specified for product 24206551000

Debug: Weight not specified for product

2 Products,
19,50 EUR

Random Products

Schwarzkümmel 100gr
Schwarzkümmel 100gr
1,00 EUR
Add to Cart

Mistelkraut 500gr
Mistelkraut 500gr
4,50 EUR
Add to Cart

Mariendistelkraut 100gr
Mariendistelkraut 100gr
1,80 EUR
Add to Cart

Geflügelgewürz 500gr
Geflügelgewürz  500gr
5,50 EUR
Add to Cart

Earl Grey Rooibusch 1000 gr
Earl Grey Rooibusch 1000 gr
19,50 EUR
Add to Cart

40 queries executed. Script Runtime: 0.294965982437 Sec.

All the queries run on this pageload follow:
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
SELECT a.* FROM jos_components AS a WHERE a.name = 'Syndicate'
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level FROM jos_core_acl_aro_groups AS g1 INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt WHERE g1.lft BETWEEN 13 AND 20 GROUP BY g1.name ORDER BY g1.lft
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level FROM jos_core_acl_aro_groups AS g1 INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt WHERE g1.lft BETWEEN 3 AND 12 GROUP BY g1.name ORDER BY g1.lft
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search'
SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=27'
SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=28'
SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=29'
SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=30'
SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=31'
SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=32'
SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=27'
SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=28'
SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=29'
SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=30'
SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=31'
SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=32'
SELECT id, name, link FROM jos_menu WHERE menutype='mainmenu' and parent='0' AND access<='0' AND sublevel='0' AND published='1' ORDER BY ordering LIMIT 8
SELECT id, name, link, parent, type, menutype FROM jos_menu WHERE published = 1 ORDER BY menutype, parent, ordering
SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= '0' AND m.client_id != 1 AND ( mm.menuid = '75' OR mm.menuid = 0 ) ORDER BY ordering
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(15,37,35,42,3,4) AND jf_content.reference_table='modules' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(5) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(75,1,90,91,88,89,87,86) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(75,1,90,91,88,89,87,86) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(75,1,90,91,88,89,87,86,92,79,80,82,78,81,83,21,67,16) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(75,92) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(78) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(79) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(80) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(81) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(82) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content, jos_languages as languages WHERE jf_content.language_id=languages.id AND jf_content.published=1 AND jf_content.reference_id IN(83) AND jf_content.reference_table='menu' AND languages.code='english'
SELECT jos_menu.id, id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=27'
SELECT jos_menu.id, id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=28'
SELECT jos_menu.id, id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=29'
SELECT jos_menu.id, id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=30'
SELECT jos_menu.id, id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=31'
SELECT jos_menu.id, id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=32'
SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering